CR4Ev2 - JRCCommunicationAdapter:719 - detected an exception: Unexpected database connector error

[Former Member]

I am using Crystal Report Viewer which has key components built on CR JAVA Runtime v. 12.2.214, JDK 1.6, Tomcat 7, Windows 7 64bit.

The source was generated by the report context menue "generate viewer jsp". I try to load the report and export to PDF.

The exception is thrown in the codeline:

                    clientDoc.getDatabaseController().setTableLocation(origTable, newTable);

which is part of the provided CRJavaHelper class.

12:03:57,434 DEBUG commandmanager:66 - command SETUP: AddDatabaseTableCommand
12:03:57,434 DEBUG commandmanager:70 - command PERFORM: AddDatabaseTableCommand
12:03:57,434  INFO AddDatabaseTableCommand:192 - AddDatabaseTableCommand,549050,Enter perform,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:57,440  INFO queryengine:1761 - Connection logon:Database DLL=s(crdb_jdbc.dll);Trusted_Connection=s(false);PreQEServerType=s(JDBC (JNDI));Server Type=s(JDBC (JNDI));Use JDBC=s(true);Database Class Name=s(oracle.jdbc.OracleDriver);JNDI Datasource Name=s();Connection URL=s(jdbc:oracle:thin:@<IP Address removed>:rdb);User ID=s(statserv40);Password=
12:03:57,479 DEBUG config:? - Configuration queried; key="JDBC.JDBCURL", result="null"
12:03:57,480 DEBUG config:? - Configuration queried; key="JDBC.JDBCClassName", result="null"
12:03:57,481 DEBUG config:? - Configuration queried; key="JDBC.JNDIURL", result="null"
12:03:57,481 DEBUG config:? - Configuration queried; key="JDBC.JNDIUserName", result="null"
12:03:57,482 DEBUG config:? - Configuration queried; key="JDBC.JNDIInitContext", result="null"
12:03:57,487 DEBUG config:? - Configuration queried; key="JDBC.JDBCUserName", result="null"
12:03:58,541 DEBUG jdbc:? - logged on with url 
12:03:58,551  INFO jdbc:? - Connection Opened null
12:03:58,569  INFO queryengine:1856 - Connection logon successfully
12:03:59,199 DEBUG commandmanager:127 - command UNDO: SetDataConnectionPropertyCommand
12:03:59,200  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,10401072,Enter undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,201  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,10401072,Exit undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,201 DEBUG commandmanager:199 - --- Purging command SetDataConnectionPropertyCommand
12:03:59,202 DEBUG commandmanager:127 - command UNDO: SetDataConnectionPropertyCommand
12:03:59,202  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,10310316,Enter undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,203  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,10310316,Exit undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,203 DEBUG commandmanager:199 - --- Purging command SetDataConnectionPropertyCommand
12:03:59,204 DEBUG commandmanager:127 - command UNDO: SetDataConnectionPropertyCommand
12:03:59,204  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,23375256,Enter undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,205  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,23375256,Exit undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,205 DEBUG commandmanager:199 - --- Purging command SetDataConnectionPropertyCommand
12:03:59,206 DEBUG commandmanager:127 - command UNDO: SetDataConnectionPropertyCommand
12:03:59,206  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,30497252,Enter undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,207  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,30497252,Exit undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,207 DEBUG commandmanager:199 - --- Purging command SetDataConnectionPropertyCommand
12:03:59,207 DEBUG commandmanager:127 - command UNDO: SetDataConnectionPropertyCommand
12:03:59,208  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,526882,Enter undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,208  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,526882,Exit undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,208 DEBUG commandmanager:199 - --- Purging command SetDataConnectionPropertyCommand
12:03:59,208 DEBUG commandmanager:127 - command UNDO: SetDataConnectionPropertyCommand
12:03:59,208  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,18733613,Enter undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,209  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,18733613,Exit undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,209 DEBUG commandmanager:199 - --- Purging command SetDataConnectionPropertyCommand
12:03:59,209 DEBUG commandmanager:127 - command UNDO: SetDataConnectionPropertyCommand
12:03:59,210  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,6657298,Enter undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,210  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,6657298,Exit undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,211 DEBUG commandmanager:199 - --- Purging command SetDataConnectionPropertyCommand
12:03:59,211 DEBUG commandmanager:127 - command UNDO: SetDataConnectionPropertyCommand
12:03:59,211  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,4264825,Enter undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,212  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,4264825,Exit undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,212 DEBUG commandmanager:199 - --- Purging command SetDataConnectionPropertyCommand
12:03:59,213 DEBUG commandmanager:127 - command UNDO: SetDataConnectionPropertyCommand
12:03:59,213  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,24382967,Enter undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,213  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,24382967,Exit undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,214 DEBUG commandmanager:199 - --- Purging command SetDataConnectionPropertyCommand
12:03:59,214 DEBUG commandmanager:127 - command UNDO: SetDataConnectionPropertyCommand
12:03:59,215  INFO SetDataConnectionPropertyCommand:192 - SetDataConnectionPropertyCommand,3656932,Enter undo,<document=ReportDocument:<report=main><reportPath=D:\Projekte\isipt\eclipse\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\isipt\WEB-INF\classes\session.rpt>>;
12:03:59,238 DEBUG commandmanager:136 - -- Failed to UNDO -> purge undo stack
12:03:59,239 DEBUG commandmanager:185 - --- Purging command SetDataConnectionPropertyCommand
12:03:59,239 DEBUG commandmanager:185 - --- Purging command CreateDataConnectionCommand
12:03:59,240 FATAL JRCCommunicationAdapter:686 - Request failed and JRC Command failed to be undone
12:03:59,240 ERROR JRCCommunicationAdapter:719 -  detected an exception: Unerwarteter Datenbank-Connector-Fehler
          at com.crystaldecisions.reports.queryengine.Table.vb(SourceFile:2423)
          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)
          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.setTableLocation(SourceFile:2906)
          at com.businessobjects.samples.CRJavaHelper.changeDataSource(CRJavaHelper.java:184)
          at com.businessobjects.samples.CRJavaHelper.changeDataSource(CRJavaHelper.java:82)
          at org.apache.jsp.cnt.etc.crystal.session_002dviewer_jsp._jspService(session_002dviewer_jsp.java:105)
          at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
          at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
          at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
          at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
          at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
          at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
          at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:300)
          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)

The same report works fine on the same machine within Crystal Reports XI and an VB code using the native API.

[Former Member]

OK, now I know the reason for this, but still have no solution. I wonder after reading so many crystal related error messages why nobdoy so far pointed out that this code:

try{

     //code 

} catch (ReportSDKExceptionBase ex) {

              out.println(ex);

              ex.printStackTrace();

          }

          catch (Exception ex) {

              out.println(ex);

              ex.printStackTrace();

          }

I mean, printing the stacktrace, reveals the root cause of the exception!

In my case it's:

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

          at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

          at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)

          at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)

          at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)

          at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)

          at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132)

          at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)

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

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

          ... 62 more

(See attachment for full output)

There is in fact a parameter to set, which is called "INREPORTHANDLE". This is how I set this (addDiscreteParameterValue):

String stringValue = new String();

stringValue = "222";

CRJavaHelper.addDiscreteParameterValue(clientDoc,"","INREPORTHANDLE",stringValue);

// Switch all tables on the main report and sub reports

CRJavaHelper.changeDataSource(clientDoc, userName, password, connectString, driverName, JNDIName);

// logon to database

CRJavaHelper.logonDataSource(clientDoc, userName, password);

The code just doesn't work, although I see while debugging, that the parameter is found and modified,

Any ideas?

TIA,

Thomas

JRCCommunicationAdapter-ORA-01008.txt.zip

[Former Member]

I've had a similar issue, in my case I traced the problem to a specific tablealias substitution at runtime, which worked in other reports with similar structures. I eventually rebuilt the report using a different table structure (used a stored procedure to flatten out the data) and this solved the problem, but this bug (from the goolging I've done) seems to be insoluble, and posts on the subject seem to just not get answered.