Skip to Content
0
Former Member
Nov 01, 2012 at 11:41 AM

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

464 Views

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.