Unexpected database connector error

[Former Member]

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]

Hi Penchal,

What is the backend database? Are you using ODBC or JDBC connectivity for your backend DB engine?

Make sure to have the required jars for your connection type inside your applications lib directory.

Does it happens with all the reports?

What happens if you do not change the datasource, are you able to view reports fine.

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

[Former Member]

HI Prithviraj,

I am using Oracle 11g Client using JDBC Connectivity.

Its working fine for 90% of reports without database change but few reports it is throwing the below error.

All variables not bound exception.

Thanks