Skip to Content

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

Unexpected database connector error

Hi Team,

I am trying to do Dynamic database change for Crystal reports and i 'm struggling with the following error. I am following below code listed in the following link

CRJava Modify DB Location

Please help me in resolve this issue. I have been struck up with this from 2 days

The Error Stack Trace is:

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Unexpected database connector error---- Error code:-2147467259 Error code name:failed

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

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

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

    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.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.sdk.occa.report.application.ds.a(SourceFile:186)

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

    at com.crystaldecisions.sdk.occa.report.application.b0.if(SourceFile:148)

    at com.crystaldecisions.sdk.occa.report.application.b0.b(SourceFile:95)

    at com.crystaldecisions.sdk.occa.report.application.bb.int(SourceFile:96)

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

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

    at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(SourceFile:2159)

    at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(SourceFile:543)

    at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(SourceFile:3898)

    at com.crystaldecisions.sdk.occa.report.application.DatabaseController.replaceConnection(SourceFile:3865)

    at org.apache.jsp.DynamicDBChange_jsp._jspService(DynamicDBChange_jsp.java:213)

    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.common.QueryEngineException: Unexpected database connector error

    at com.crystaldecisions.reports.queryengine.Table.new(SourceFile:1014)

    at com.crystaldecisions.reports.queryengine.Table.byte(SourceFile:1791)

    at com.crystaldecisions.reports.queryengine.Table.a(SourceFile:638)

    at com.crystaldecisions.reports.queryengine.Table.vc(SourceFile:2419)

    at com.crystaldecisions.reports.dataengine.datafoundation.AddDatabaseTableCommand.new(SourceFile:529)

    at com.crystaldecisions.reports.common.CommandManager.a(SourceFile:71)

    at com.crystaldecisions.reports.common.Document.a(SourceFile:203)

    at com.businessobjects.reports.sdk.requesthandler.f.a(SourceFile:175)

    at com.businessobjects.reports.sdk.requesthandler.DatabaseRequestHandler.byte(SourceFile:1079)

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

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

    ... 46 more

Caused by: com.businessobjects.reports.jdbinterface.common.DBException: Unexpected database connector error

    at com.crystaldecisions.reports.queryengine.driverImpl.jdbc.JDBCQueryDefinition.Execute(Unknown Source)

    at com.crystaldecisions.reports.queryengine.driverImpl.jdbc.JDBCQueryDefinition.Execute(Unknown Source)

    at com.crystaldecisions.reports.queryengine.driverImpl.jdbc.JDBCTable.GetFields(Unknown Source)

    at com.crystaldecisions.reports.queryengine.Table.new(SourceFile:1010)

    ... 56 more

Caused by: java.sql.SQLException: ORA-01008: not all variables bound

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)

    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)

    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)

    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)

    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)

    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)

    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1882)

    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1847)

    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301)

    ... 60 more

Waiting for reply

Thanks

Penchal

Former Member
Not what you were looking for? View more on this topic or Ask a question