Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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.

CRJava Modify DB Location

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
Not what you were looking for? View more on this topic or Ask a question