Receiving Error when running Crystal reports with Images in WebSphere 6.1

[Former Member]

I am designing a report with a sub report that displays images via (BLOBS). The images are between 10-20 kb in size and there could be up to 200 images in the report.

There are no problems when I run the report using Java 1.5 with Tomcat 5.5 server and JDBC connection (using ojdbc14.jar) to an Oracle 10g database.

It seems that if I attempt to run the same report on a WebSphere 6.1 environment, the below error is encountered (stack trace is below)

I am using Crystal 2008 (ver 12.0.0.683).

Based on the stack trace, I think it is either an IBM JDK javax.* package compatibility issue or the current version of Crystal reports (no service packs installed - current client environment) has a known issue with Websphere.

I searched the forums for any similiar issues but could not find one.

Could installing Service pack 3 solve this issue or is there another possibility?

Any assistance would be greatly appreciated.

Thank you.

Tony.

• Stack Trace follows (Needed to trim due to size, trying to keep unique messges) *******

ERROR [pool-14-thread-1] c.u.p.e.g.c.GenerateCrystalReport [GenerateCrystalReport.java : 211] Generate Report: Template =
pusehk08\evm$\EVM REPORTS 5.7.2010\Staging\TEARDOWN_COM.rpt, ReportSDKException caught: javax/imageio/metadata/IIOMetadata.getAsTree(Ljava/lang/String;)Lorg/w3c/dom/Node;

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: javax/imageio/metadata/IIOMetadata.getAsTree(Ljava/lang/String;)Lorg/w3c/dom/Node;

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.if(SourceFile:237) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:147) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:128) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:111) [CrystalReportsRuntime.jar:12.2.207.916]

at com.utc.pw.evm2.generatereports.crystalreports.GenerateCrystalReport.generateReport(GenerateCrystalReport.java:152) [classes/:na]

at com.utc.pw.evm2.generatereports.ReportThread.run(ReportThread.java:144) [classes/:na]

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:678) [na:1.5.0]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:703) [na:1.5.0]

at java.lang.Thread.run(Thread.java:811) [na:1.5.0]

Caused by: java.lang.VerifyError: javax/imageio/metadata/IIOMetadata.getAsTree(Ljava/lang/String;)Lorg/w3c/dom/Node;

at com.crystaldecisions.reports.common.image.ImageUtils.a(SourceFile:901) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.reports.common.image.ImageUtils.if(SourceFile:873) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.reports.common.JavaImage.do(SourceFile:183) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.reports.common.CrystalImage.createImage(SourceFile:50) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.reports.formatter.formatter.objectformatter.FormattedBlobFieldObject.if(SourceFile:103) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.reports.formatter.formatter.objectformatter.FormattedBlobFieldObject.<init>(SourceFile:57) [CrystalReportsRuntime.jar:12.2.207.916]

...

[CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.formatPage(SourceFile:236) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.reports.formatter.export2.a.a(SourceFile:96) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.reports.formatter.export2.a.a(SourceFile:247) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.reports.formatter.export2.ExportSupervisorEx.if(SourceFile:642) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.reports.formatter.export2.ExportSupervisorEx.a(SourceFile:586) [CrystalReportsRuntime.jar:12.2.207.916]

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.a(SourceFile:636) [CrystalReportsRuntime.jar:12.2.207.916]

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.int(SourceFile:672) [CrystalReportsRuntime.jar:12.2.207.916]

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.do(SourceFile:1944) [CrystalReportsRuntime.jar:12.2.207.916]

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:661) [CrystalReportsRuntime.jar:12.2.207.916]

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:167) [CrystalReportsRuntime.jar:12.2.207.916]

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:529) [CrystalReportsRuntime.jar:12.2.207.916]

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:527) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102) [CrystalReportsRuntime.jar:12.2.207.916]

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:525) [CrystalReportsRuntime.jar:12.2.207.916]

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:424) [CrystalReportsRuntime.jar:12.2.207.916]

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:352) [CrystalReportsRuntime.jar:12.2.207.916]

at com.businessobjects.sdk.erom.jrc.a.a(SourceFile:54) [CrystalReportsRuntime.jar:12.2.207.916]

at com.businessobjects.sdk.erom.jrc.a.execute(SourceFile:67) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(SourceFile:716) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(SourceFile:125) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(SourceFile:537) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.sdk.occa.report.application.ds.a(SourceFile:186) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:1558) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:337) [CrystalReportsRuntime.jar:12.2.207.916]

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.if(SourceFile:223) [CrystalReportsRuntime.jar:12.2.207.916]

... 8 common frames omitted

2010-07-20 15:57:11,147 ERROR [pool-14-thread-1] c.u.p.e.g.ReportThread [ReportThread.java : 233] Attempt to generate report TEARDOWN using
pusehk08\evm$\EVM REPORTS 5.7.2010\Staging\TEARDOWN_COM.rpt for E733570-01 failed: Generate Report: Template =
pusehk08\evm$\EVM REPORTS 5.7.2010\Staging\TEARDOWN_COM.rpt, ReportSDKException caught: javax/imageio/metadata/IIOMetadata.getAsTree(Ljava/lang/String;)Lorg/w3c/dom/Node;, REPORTSDKEXCEPTION

2010-07-20 15:57:11,147 ERROR [pool-14-thread-1] c.u.p.e.g.ReportThread [ReportThread.java : 238] Exception was caught trying to build report:

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: javax/imageio/metadata/IIOMetadata.getAsTree(Ljava/lang/String;)Lorg/w3c/dom/Node;

Edited by: Liro9999 on Jul 21, 2010 1:55 PM

[former_member11696 · Accepted solution]

Moved to Java SDK forum

First thing you want to do is upgrade to Service Pack 3, re-deploy and test again

[Adam_Stone]

Looking at the file versions listed in the stack trace, it appears you are on the latest version of Crystal Reports for Eclipse.

Websphere 6.1 with JDK 1.5 is on our supported platforms list so this should be working, but it is possible that you may have some additional files being loaded that are causing conflicts. Is this a fresh install of Websphere? Are there other applications already installed on it as well?

[Former Member]

Thank you for your reply.

The answer to your question concerning if Websphere is a clean install is no. The client has other applications running on that server. We do not have access to that server other than the log files and I requested information as to what other applications are on the server.

.

We did try adding a known working version of the IIOMetadata class in the ear file and deploying it in the hopes that class will be loaded before using any other version. Unfortunately, we receive the posted errors. Which may mean that a different version of the class has already been loaded in memory and that is the one being accessed. A request would have to be made to the client for a shutdown and restart of Websphere in determining if that may be the case. Since there are other applications running, coordination and communication to the other application owner will need to be done first.

Any additional ideas will be appreciated.

Thank you.

Tony.