XmlError in xml source program

[Former Member]

In my program, xml is pushed as an input to the crystal report and pdf is exported as an output. But I got the following error.

 2008-09-08 [13:09:13:968] *** ERROR *** CRPushXML.java           ::                               main(113) - ERROR
com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: XmlError---- Error code:-2147467259 Error code name:failed
	at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)
	at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)
	at com.crystaldecisions.reports.sdk.PrintOutputController.export(Unknown Source)
	at com.sumco.cert.framework.util.CRPushXML.main(CRPushXML.java:95)
Caused by: com.crystaldecisions.reports.reportdefinition.datainterface.e: XmlError
	at com.crystaldecisions.reports.common.CrystalException.<init>(Unknown Source)
	at com.crystaldecisions.reports.common.CrystalException.<init>(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.datainterface.n.<init>(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.datainterface.e.<init>(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.datainterface.g.a(Unknown Source)
	at com.businessobjects.reports.sdk.b.b.byte(Unknown Source)
	at com.businessobjects.reports.sdk.b.b.int(Unknown Source)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)
	at com.crystaldecisions.proxy.remoteagent.x.a(Unknown Source)
	at com.crystaldecisions.proxy.remoteagent.q.a(Unknown Source)
	at com.crystaldecisions.sdk.occa.report.application.dd.a(Unknown Source)
	at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)
	at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)
	... 4 more
Caused by: com.crystaldecisions.reports.queryengine.driverImpl.c: XmlError
	at com.crystaldecisions.reports.queryengine.driverImpl.a.if(Unknown Source)
	at com.crystaldecisions.reports.queryengine.ax.new(Unknown Source)
	at com.crystaldecisions.reports.queryengine.ax.byte(Unknown Source)
	... 17 more
Caused by:
com.crystaldecisions.reports.reportdefinition.datainterface.e: XmlError
	at com.crystaldecisions.reports.common.CrystalException.<init>(Unknown Source)
	at com.crystaldecisions.reports.common.CrystalException.<init>(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.datainterface.n.<init>(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.datainterface.e.<init>(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.datainterface.g.a(Unknown Source)
	at com.businessobjects.reports.sdk.b.b.byte(Unknown Source)
	at com.businessobjects.reports.sdk.b.b.int(Unknown Source)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)
	at com.crystaldecisions.proxy.remoteagent.x.a(Unknown Source)
	at com.crystaldecisions.proxy.remoteagent.q.a(Unknown Source)
	at com.crystaldecisions.sdk.occa.report.application.dd.a(Unknown Source)
	at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)
	at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)
	at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)
	at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)
	at com.crystaldecisions.reports.sdk.PrintOutputController.export(Unknown Source)
	at com.sumco.cert.framework.util.CRPushXML.main(CRPushXML.java:95)
Caused by: com.crystaldecisions.reports.queryengine.driverImpl.c: XmlError
	at com.crystaldecisions.reports.queryengine.driverImpl.a.if(Unknown Source)
	at com.crystaldecisions.reports.queryengine.ax.new(Unknown Source)
	at com.crystaldecisions.reports.queryengine.ax.byte(Unknown Source)
	... 17 more

What might be the cause of the error?

[former_member203619]

You can use the XML driver in a java program - however you cannot use the ADO .NET driver in a java app unfortunately.

You can however use resultsets which are similar.

Regards,

Shawn

[former_member203619]

Hi Makesh,

Unfortunately we don't have anything available which defines the accepted structure for our XML driver. At the moment the best I can suggest is to look at the XML from the sample you looked at and try to make your data similar to it.

Barring that, you might want to try the ADO .NET dataset driver instead. It also takes XML and seems to work a lot better.

Regards,

Shawn

[Former Member]

Thank you Shawn for your reply.

Can I use it in the java program?

[Former Member]

I tried the program with the example report given Link: [here|ftp://ftp.businessobjects.com/pub/incoming/XML_XSD_sample_reports_XI.zip]

It works fine. So I think the problem should be in my XML data.

What are the limitations in XML passed as an input?

Makesh

[ted_ueda]

Documentation describing limitations in the native XML driver is here:

[Structuring XML Data for the Crystal Reports XI Native XML Driver|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/90faaea7-8e1e-2b10-e6a7-ea82e11d9e8b]

Sincerely,

Ted Ueda