Error in switching from one database location to another database location in Crystal Reports using JSP

[Former Member]

Hi,

Please help me in resolving the issue while changing the database dynamically in crystal reports using JSP. I followed the below link to change DB connection dynamically.

Please help me on this.

While switching from one database to another i found the issue.

dbController.replaceConnection(oldConnectionInfo, newConnectionInfo,pFields,replaceParams);

The Error is:

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Subreport does not exist.---- Error code:-2147467259 Error code name:failed

    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:2284)

    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:732)

    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:166)

    at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:528)

    at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:526)

    at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102)

    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:524)

    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:423)

    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:480)

    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:421)

    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:351)

    at com.businessobjects.sdk.erom.jrc.a.a(SourceFile:54)

    at com.businessobjects.sdk.erom.jrc.a.execute(SourceFile:67)

    at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(SourceFile:716)

    at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(SourceFile:125)

    at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(SourceFile:537)

    at com.crystaldecisions.proxy.remoteagent.RemoteAgent.char(SourceFile:220)

    at com.crystaldecisions.proxy.remoteagent.RemoteAgent.new(SourceFile:240)

    at com.crystaldecisions.proxy.remoteagent.RemoteAgent.do(SourceFile:452)

    at com.crystaldecisions.proxy.remoteagent.RemoteAgent.if(SourceFile:429)

    at com.crystaldecisions.proxy.remoteagent.UndoUnitBase.performDo(SourceFile:156)

    at com.crystaldecisions.proxy.remoteagent.UndoUnitBase.a(SourceFile:106)

    at com.crystaldecisions.sdk.occa.report.application.an.a(SourceFile:65)

    at com.crystaldecisions.sdk.occa.report.application.ParameterFieldController.a(SourceFile:1921)

    at com.crystaldecisions.sdk.occa.report.application.ParameterFieldController.setCurrentValues(SourceFile:2237)

    at com.crystaldecisions.sdk.occa.report.application.ParameterFieldController.setCurrentValue(SourceFile:2328)

    at org.apache.jsp.DynamicDB_jsp._jspService(DynamicDB_jsp.java:255)

    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

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

    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)

    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)

    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)

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

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)

    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)

    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)

    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)

    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: com.crystaldecisions.reports.reportdefinition.ReportModificationException: Subreport does not exist.

    at com.businessobjects.reports.sdk.requesthandler.ParameterRequestHandler.a(SourceFile:229)

    at com.businessobjects.reports.sdk.requesthandler.ParameterRequestHandler.for(SourceFile:214)

    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.do(SourceFile:1492)

    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:660)

    ... 47 more

Any help Appreciated.

Thanks

Penchal

[Former Member]

Do you have subreports in your reports?

If yes, set the connection info for the subreports as well.

Additionaly refer to the below discussion

http://scn.sap.com/thread/3153289

As you are using Crystal reports for ecllipse runtime libraries to build your jsp, you would need to post your dicussions in the below forum to get better response.

http://scn.sap.com/community/crystal-reports-for-eclipse

The above space is dedicated for the issues with crystal reports for ecllipse.

Thanks,

Prithvi