Unable to connect to the server: {0}. --- Broken pipe---- Error code:-21472

[Former Member]

Hi

We are facing an issue while running reports that take aroung 15 mins+ to execute.We use the RAS SDK to generate the reports. The datasource is POJO.

We have been able to generate smaller reports OK. The datasource (POJO) are generated using EJB and passed as a collection to the Report Server to generate the reports. But when the EJB transaction takes 15 + minutes to generate the POJO, the following exception is shown when the POJO are sent out to the RAS server. We use Reports Server XI R2. Application server is Websphere 6.1.

Any thoughts ?

[8/6/08 9:35:11:900 IST] 00000053 SystemErr R com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: Unable to connect to the server: . - Broken pipe-- Error code:-2147217387 Error code name:connectServer

at com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException.throwReportSDKServerException(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.TCPIPCommunicationAdapter.request(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.cf.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.DatabaseController.setDataSource(Unknown Source)

at com.ibsplc.cts.report.crystal.util.RasUtil.configureDataSource(RasUtil.java:310)

at com.ibsplc.cts.report.crystal.RASReportAttributeBuilder.configureReportInfo(RASReportAttributeBuilder.java:138)

at com.ibsplc.cts.report.ReportController.getReportInfo(ReportController.java:267)

at com.ibsplc.cts.report.ReportController.generateReport(ReportController.java:128)

at org.avient.app.mlt.ui.ReportBaseAction.generateReport(ReportBaseAction.java:276)

at org.avient.app.mlt.ui.RollingHoursAction.performAction(RollingHoursAction.java:275)

at org.avient.app.common.ui.AbstractAction.perform(AbstractAction.java:338)

at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1786)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1585)

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:509)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)

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

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

at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:92)

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

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

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

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

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)

at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)

at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)

at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)

at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)

at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)

at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)

at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)

at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)

Caused by: java.net.SocketException: Broken pipe

at java.net.SocketOutputStream.socketWrite0(Native Method)

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)

at java.net.SocketOutputStream.write(SocketOutputStream.java:136)

at java.io.DataOutputStream.write(DataOutputStream.java:90)

at java.io.FilterOutputStream.write(FilterOutputStream.java:80)

... 36 more

Caused by:

java.net.SocketException: Broken pipe

at java.net.SocketOutputStream.socketWrite0(Native Method)

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)

at java.net.SocketOutputStream.write(SocketOutputStream.java:136)

at java.io.DataOutputStream.write(DataOutputStream.java:90)

at java.io.FilterOutputStream.write(FilterOutputStream.java:80)

at com.crystaldecisions.proxy.remoteagent.TCPIPCommunicationAdapter.request(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.cf.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.DatabaseController.setDataSource(Unknown Source)

at com.ibsplc.cts.report.crystal.util.RasUtil.configureDataSource(RasUtil.java:310)

at com.ibsplc.cts.report.crystal.RASReportAttributeBuilder.configureReportInfo(RASReportAttributeBuilder.java:138)

at com.ibsplc.cts.report.ReportController.getReportInfo(ReportController.java:267)

at com.ibsplc.cts.report.ReportController.generateReport(ReportController.java:128)

at org.avient.app.mlt.ui.ReportBaseAction.generateReport(ReportBaseAction.java:276)

at org.avient.app.mlt.ui.RollingHoursAction.performAction(RollingHoursAction.java:275)

at org.avient.app.common.ui.AbstractAction.perform(AbstractAction.java:338)

at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1786)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1585)

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:509)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)

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

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

at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:92)

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

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

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

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

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)

at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)

at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)

at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)

at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)

at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)

at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)

at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)

at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)

[8/6/08 9:35:11:901 IST] 00000053 SystemErr R at com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException.throwReportSDKServerException(Unknown Source)

[8/6/08 9:35:11:901 IST] 00000053 SystemErr R at com.crystaldecisions.proxy.remoteagent.TCPIPCommunicationAdapter.request(Unknown Source)

[8/6/08 9:35:11:902 IST] 00000053 SystemErr R at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)

[8/6/08 9:35:11:902 IST] 00000053 SystemErr R at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)

[8/6/08 9:35:11:902 IST] 00000053 SystemErr R at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)

[8/6/08 9:35:11:902 IST] 00000053 SystemErr R at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)

[8/6/08 9:35:11:902 IST] 00000053 SystemErr R at com.crystaldecisions.sdk.occa.report.application.cf.a(Unknown Source)

[8/6/08 9:35:11:902 IST] 00000053 SystemErr R at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(Unknown Source)

[8/6/08 9:35:11:902 IST] 00000053 SystemErr R at com.crystaldecisions.sdk.occa.report.application.DatabaseController.setDataSource(Unknown Source)

[8/6/08 9:35:11:903 IST] 00000053 SystemErr R at com.ibsplc.cts.report.crystal.util.RasUtil.configureDataSource(RasUtil.java:310)

[8/6/08 9:35:11:903 IST] 00000053 SystemErr R at com.ibsplc.cts.report.crystal.RASReportAttributeBuilder.configureReportInfo(RASReportAttributeBuilder.java:138)

[8/6/08 9:35:11:903 IST] 00000053 SystemErr R at com.ibsplc.cts.report.ReportController.getReportInfo(ReportController.java:267)

[8/6/08 9:35:11:903 IST] 00000053 SystemErr R at com.ibsplc.cts.report.ReportController.generateReport(ReportController.java:128)

[8/6/08 9:35:11:903 IST] 00000053 SystemErr R at org.avient.app.mlt.ui.ReportBaseAction.generateReport(ReportBaseAction.java:276)

[8/6/08 9:35:11:904 IST] 00000053 SystemErr R at org.avient.app.mlt.ui.RollingHoursAction.performAction(RollingHoursAction.java:275)

[8/6/08 9:35:11:904 IST] 00000053 SystemErr R at org.avient.app.common.ui.AbstractAction.perform(AbstractAction.java:338)

[8/6/08 9:35:11:904 IST] 00000053 SystemErr R at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1786)

[8/6/08 9:35:11:904 IST] 00000053 SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1585)

[8/6/08 9:35:11:904 IST] 00000053 SystemErr R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:509)

[8/6/08 9:35:11:904 IST] 00000053 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)

[8/6/08 9:35:11:905 IST] 00000053 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

[8/6/08 9:35:11:905 IST] 00000053 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)

[8/6/08 9:35:11:905 IST] 00000053 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)

[8/6/08 9:35:11:905 IST] 00000053 SystemErr R at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)

[8/6/08 9:35:11:905 IST] 00000053 SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:92)

[8/6/08 9:35:11:906 IST] 00000053 SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744)

[8/6/08 9:35:11:906 IST] 00000053 SystemErr R at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)

[8/6/08 9:35:11:906 IST] 00000053 SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)

[8/6/08 9:35:11:906 IST] 00000053 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)

[8/6/08 9:35:11:906 IST] 00000053 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)

[8/6/08 9:35:11:907 IST] 00000053 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)

[8/6/08 9:35:11:907 IST] 00000053 SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)

[8/6/08 9:35:11:907 IST] 00000053 SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)

[8/6/08 9:35:11:907 IST] 00000053 SystemErr R at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)

[8/6/08 9:35:11:907 IST] 00000053 SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)

[8/6/08 9:35:11:908 IST] 00000053 SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)

[8/6/08 9:35:11:908 IST] 00000053 SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)

[8/6/08 9:35:11:908 IST] 00000053 SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)

[8/6/08 9:35:11:908 IST] 00000053 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)

[8/6/08 9:35:11:908 IST] 00000053 SystemErr R Caused by: java.net.SocketException: Broken pipe

[8/6/08 9:35:11:908 IST] 00000053 SystemErr R at java.net.SocketOutputStream.socketWrite0(Native Method)

[8/6/08 9:35:11:909 IST] 00000053 SystemErr R at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)

[8/6/08 9:35:11:909 IST] 00000053 SystemErr R at java.net.SocketOutputStream.write(SocketOutputStream.java:136)

[8/6/08 9:35:11:909 IST] 00000053 SystemErr R at java.io.DataOutputStream.write(DataOutputStream.java:90)

[8/6/08 9:35:11:909 IST] 00000053 SystemErr R at java.io.FilterOutputStream.write(FilterOutputStream.java:80)

[8/6/08 9:35:11:909 IST] 00000053 SystemErr R ... 36 more

[8/6/08 9:35:11:910 IST] 00000053 SystemErr R Caused by

[8/6/08 9:35:11:910 IST] 00000053 SystemErr R java.net.SocketException: Broken pipe

at java.net.SocketOutputStream.socketWrite0(Native Method)

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)

at java.net.SocketOutputStream.write(SocketOutputStream.java:136)

at java.io.DataOutputStream.write(DataOutputStream.java:90)

at java.io.FilterOutputStream.write(FilterOutputStream.java:80)

[Former Member]

Hi

We invoke the RAS only after completing the EJB transaction. If you notice from the exception stack,

at com.crystaldecisions.proxy.remoteagent.TCPIPCommunicationAdapter.request(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.cf.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.DatabaseController.setDataSource(Unknown Source)

at com.ibsplc.cts.report.crystal.util.RasUtil.configureDataSource(RasUtil.java:310)

at com.ibsplc.cts.report.crystal.RASReportAttributeBuilder.configureReportInfo(RASReportAttributeBuilder.java:138)

at com.ibsplc.cts.report.ReportController.getReportInfo(ReportController.java:267)

The POJO collection is retrived and the method ReportController.getReportInfo returns. Only after this point do we go for invoking the RAS SDK. I do suspect that it could be thetimeout limit between the RAS SDK and RAS that "might" be the issue. Any inputs on how we could override this ?

Thanks

[ted_ueda]

Hello Ramesh,

I saw the stack trace, and that's why I asked the question above. Let me restate to make sure we're on the same page.

From the stack trace, the DatabaseController.setDataSource method is invoked within the ReportController.getReportInfo - i.e., the getReportInfo method hasn't returned yet, and does not return until the setDataSource method returns.

So my inference is that you're retrieving the POJO within the getReportInfo method call, and that takes greater than 10 minutes.

Since there's no method call to open the report in the RAS in the stack trace, my assumption is that there's a >10 minute delay between opening the report in the RAS, till the setDataSource method is called. The > 10 minute duration doesn't have any communication to the RAS server, so the connection times out.

Would you be able to retrieve the POJO before opening the report in the RAS, and inject immediately?

There are ways to increase the timeout, but that may lead to loading/performance issues - i.e., you'll be taking up a RAS connection and report job during the duration where it's just sitting idle while your app is retrieving the data.

Sincerely,

Ted Ueda

[Former Member]

Hi Ted

We are actually generating the POJO before setting the connection to RAS. The following piece of exception stack would be useful.

As you can see we get the complete POJO after returning from RollingHoursManager getRollingHours. This returns via the Bean class and gets passed back to the RollingHoursAction.performAction. This then invokes the rest of the report generation via RAS SDK. We get the ReportClientDocument using RAS SDK and then passes it on (after sucessful generation) to the CrystalReportViewer.jsp.

[8/8/08 13:17:02:747 IST] 0000005f SystemErr R <RollingHoursDetails> <FINER> :<08-08-08:01:17> :RollingHoursOracleDAO calculateTakeoff() : RETURN

[8/8/08 13:17:02:748 IST] 0000005f SystemErr R <RollingHoursDetails> <FINER> :<08-08-08:01:17> :RollingHoursOracleDAO executeProcedure :Exit () : RETURN

[8/8/08 13:17:10:678 IST] 0000005f SystemErr R <RollingHoursDetails> <FINER> :<08-08-08:01:17> :RollingHoursOracleDAO getFinalRollingHoursCol () : ENTRY

[8/8/08 13:17:11:019 IST] 0000005f SystemErr R <RollingHoursDetails> <FINER> :<08-08-08:01:17> :RollingHoursOracleDAO getFinalRollingHoursCol: Exit () : RETURN

[8/8/08 13:17:11:021 IST] 0000005f SystemErr R <RollingHoursDetails> <FINER> :<08-08-08:01:17> :RollingHoursOracleDAO getRolligHours() : RETURN

[8/8/08 13:24:12:886 IST] 0000005f SystemErr R <RollingHoursManager> <FINER> :<08-08-08:01:24> :RollingHoursManager getRollingHours() : RETURN

[8/8/08 13:24:12:887 IST] 0000005f SystemErr R <ReportDetails> <FINER> :<08-08-08:01:24> :ReportControllerBean getRollingHours() : RETURN

[8/8/08 13:24:27:565 IST] 0000005f SystemErr R <ReportDetails> <FINER> :<08-08-08:01:24> :ReportDelegate getRolligHours() : RETURN

[8/8/08 13:24:46:708 IST] 0000005f SystemErr R com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: Unable to connect to the server: . - Broken pipe-- Error code:-2147217387 Error code name:connectServer

at com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException.throwReportSDKServerException(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.TCPIPCommunicationAdapter.request(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.cf.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.DatabaseController.setDataSource(Unknown Source)

at com.ibsplc.cts.report.crystal.util.RasUtil.configureDataSource(RasUtil.java:310)

at com.ibsplc.cts.report.crystal.RASReportAttributeBuilder.configureReportInfo(RASReportAttributeBuilder.java:138)

at com.ibsplc.cts.report.ReportController.getReportInfo(ReportController.java:267)

at com.ibsplc.cts.report.ReportController.generateReport(ReportController.java:128)

at org.avient.app.mlt.ui.ReportBaseAction.generateReport(ReportBaseAction.java:276)

at org.avient.app.mlt.ui.RollingHoursAction.performAction(RollingHoursAction.java:275)

at org.avient.app.common.ui.AbstractAction.perform(AbstractAction.java:338)

at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1786)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1585)

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:509)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)

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

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

at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:92)

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

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

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

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

Thanks

[Former Member]

Do you know if setDataSource method in com.crystaldecisions.sdk.occa.report.application.DatabaseController has any upper limit on the resultSet size it can take in ?

Thanks

[ted_ueda]

Let me repeat:

You either call ReportClientDocument.open or IReportAppFactory.openDocument to open a connection to the RAS for a report.

That's when the timer starts ticking.

Are you retrieving the POJO after either of the two open methods, then injecting the data?

If you are, then you will have exceeded the > 10 minutes for the RAS timeout if it takes longer that 10 minutes to retrieve the POJO.

I'm not asking whether you're retrieving the POJO before injecting it into the report - that's a given.

There's no a-priori limits on how much data you can push - that's limited by the max heap size for the Java process.

Sincerely,

Ted Ueda

[Former Member]

Hi Ted

I confirm that the reportClientDoc.open is called only after generating the POJO.

The reportClientDoc.open is done only after collecting the pojo. Within 5 seconds the databaseController.setDataSource is called.It is after this that we get the error.- in another 5-10 seconds.

Thank you for your valuable suggestions.

[ted_ueda]

If you're calling ReportClientDocument.open and within 5-10 seconds calling setDataSource that fails, then it's not the 10 minute RAS - RAS SDK timeout that's failing.

Something else is blocking the communication of the data from the SDK to unmanaged RAS.

I would investigate networking/firewall configs.

Sincerely,

Ted Ueda

[Former Member]

Hi Ted

I too thought on similar lines. So, I installed the web server, application server and the Report Server in the same machine. But no luck !..It still throws up.

And the odd thing was the report did get generated after 5-6 tries in the earlier setup (where the RAS was on a different machine). It came only once, and never came after that.

Any other thoughts ?

Thanks.

[Former Member]

Hi Ted

I think the issue was because the RAS was hosted on Windows XP.

Windows XP seems to block high size TCP segments due to built in security features.

Thanks for you help over the past week.

[ted_ueda]

Hello Ramesh,

I can validate that the RAS server won't be fully supported on XP, since it's considered a client, and not server, OS.

Sincerely,

Ted Ueda

[ted_ueda]

Default idle wait timeout from the RAS to the RAS SDK and RAS SDK to RAS are both set by default to 10 minutes.

Any way you can change the workflow invoke the EJB POJO and wait till you get the data before opening the report using RAS?

Sincerely,

Ted Ueda