Report Export failing with Error Message

[former_member1362161]

Hi

Facing an issue while exporting online report to PDF.

After pressed export icon and selected the PDF type and pressed export button, Getting Error message.

No exception in the server. Simply its showing “Error”. Please find the attachment for the error details.

Environment :

IBM Web sphere Application server 6.1

Crystal report java runtime version : crjava-runtime_12.2.218

DB : DB2 9.5

IE 8

Please advice what could be the problem.

Note : Few time able to save the reports and few time showing “Error”

Thanks & Regards

A. Viswa..

[former_member1362161]

Hi,

We are Facing an issue while exporting  report to PDF.

After pressed export icon and selected the PDF type and pressed export button, Getting following error in HTTP trace.

Stack Dump = java.io.IOException: Recover report client document state failed.

        at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.readExternal(SourceFile:1492)

        at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.readExternal(SourceFile:131)

        at java.io.ObjectInputStream.readExternalData(ObjectInputStream.java:1820)

        at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1782)

        at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1347)

        at java.io.ObjectInputStream.readObject(ObjectInputStream.java:382)

        at java.util.Hashtable.readObject(Hashtable.java:892)

        at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:619)

        at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:1127)

        at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1877)

        at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1784)

        at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1347)

        at java.io.ObjectInputStream.readObject(ObjectInputStream.java:382)

        at com.ibm.ws.webcontainer.httpsession.BackedHashtable.getValue(BackedHashtable.java:1466)

        at com.ibm.ws.webcontainer.httpsession.DatabaseSessionData.fillAppData(DatabaseSessionData.java:776)

        at com.ibm.ws.webcontainer.httpsession.DatabaseSessionData.getSwappableData(DatabaseSessionData.java:317)

        at com.ibm.ws.webcontainer.httpsession.DatabaseSessionData.checkActivationListeners(DatabaseSessionData.java:343)

        at com.ibm.ws.webcontainer.httpsession.SessionData.notifyActivateListeners(SessionData.java:1346)

        at com.ibm.ws.webcontainer.httpsession.SessionContext.getIHttpSession(SessionContext.java:1591)

        at com.ibm.ws.webcontainer.httpsession.SessionContext.getIHttpSession(SessionContext.java:2557)

        at com.ibm.ws.webcontainer.httpsession.SessionContext.sessionPreInvoke(SessionContext.java:2930)

        at com.ibm.ws.webcontainer.srt.SRTRequestContext.sessionPreInvoke(SRTRequestContext.java:56)

        at com.ibm.ws.webcontainer.webapp.WebAppDispatcherContext.sessionPreInvoke(WebAppDispatcherContext.java:254)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:525)

        at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:526)

        at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3673)

        at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:269)

        at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:844)

        at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1478)

        at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:133)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:457)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:300)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:271)

        at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)

        at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialR

Environment :

IBM Web sphere Application server 6.1 with Clusters and two JVM

Crystal report java runtime version : crjava-runtime_12.2.218

DB : DB2 9.5

IE 8

IBM DB2 Session DB.

Success Scenario:

1. 1) We are able to export report to PDF format, If application running in only one JVM with Load balancer/without Load Balancer.

Failure Scenario  with F5 Load balancer and two JVM running in two different box:  

1. Online report loaded in JVM 1
2. Export to PDF request hit JVM 2 and getting above error.

We are persisting session in IBM DB2 Session DB. And F5 doing round robin.

Please advice..

Thanks

Viswa..