How to fix crystal report runtime error -2147467259

Sreejith_S · December 5, 2016, 11:21am

Hi ,

While executing the crystal reports in ReportServer , I am getting the following error message even though the database connection was successful, could you please figure out this issue:-

An error occurred during report execution.
The report could not be executed: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Unexpected database connector error---- Error code:-2147467259 Error code name:failed
To get help please contact an administrator.
Details
net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Unexpected database connector error---- Error code:-2147467259 Error code name:failed at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:218) at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:119) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exeucteReport(ReportExportServlet.java:535) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doExportReport(ReportExportServlet.java:416) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReport(ReportExportServlet.java:346) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportViaSession(ReportExportServlet.java:339) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(ReportExportServlet.java:168) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$6e3f6a15.CGLIB$doGet$7() at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$6e3f6a15$$FastClassByGuice$$a0f663b2.invoke() at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$6e3f6a15.doGet() at javax.servlet.http.HttpServlet.service(HttpServlet.java:622) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$6e3f6a15.CGLIB$service$18() at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$6e3f6a15$$FastClassByGuice$$a0f663b2.invoke() at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$6e3f6a15.service() at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:873) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:687) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2508) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2497) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorRuntimeException: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Unexpected database connector error---- Error code:-2147467259 Error code name:failed at net.datenwerke.rs.crystal.service.crystal.reportengine.CrystalReportEngine.executeReport(CrystalReportEngine.java:104) at net.datenwerke.rs.crystal.service.crystal.reportengine.CrystalReportEngine.doExecute(CrystalReportEngine.java:63) at net.datenwerke.rs.core.service.reportmanager.engine.ReportEngine.execute(ReportEngine.java:148) at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:186) … 57 more Caused by: 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.setTableLocation(SourceFile:2906) at net.datenwerke.rs.crystal.service.crystal.reportengine.CrystalReportServiceImpl.replaceTableConnectionInfo(CrystalReportServiceImpl.java:98) at net.datenwerke.rs.crystal.service.crystal.reportengine.CrystalReportServiceImpl.replaceDatasourceWithJndi(CrystalReportServiceImpl.java:76) at net.datenwerke.rs.crystal.service.crystal.reportengine.CrystalReportEngine.executeReport(CrystalReportEngine.java:88) … 60 more Caused by: com.crystaldecisions.reports.common.QueryEngineException: Unexpected database connector error at com.crystaldecisions.reports.queryengine.Connection.be(SourceFile:1078) at com.crystaldecisions.reports.queryengine.Table.bv(SourceFile:2312) at com.crystaldecisions.reports.queryengine.Table.a(SourceFile:595) at com.crystaldecisions.reports.queryengine.Table.vc(SourceFile:2421) 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) … 86 more

Regards,
Sreejith

IF_Eduardo · December 6, 2016, 8:11am

Hi Sreejith,

does this happen on ALL your crystal reports or only on specific ones? do you got subreports on your report?

Sreejith_S · December 6, 2016, 10:58am

Hi ,

Step to Reprodce the issue :

Uploaded the .rpt file to report manager and datasource running on remote server ( Tested db connectivity with JRXML which works fine )
Click on newly created crystal report , select parameter click Extract Parameter.
Extract Parameter shows up a bunch of keys. Click submit button.
Click Execute Report which will display the prevoiusly mentioned error code.

If I tried to change the parameter order , the error message ends up in showing Regex Failed.

What I’m missing here.

Regards,
Sreejith

IF_Eduardo · December 6, 2016, 1:52pm

Hi Sreejith,

so, again, does this happen on all crystal reports?
Could you make a minimal, simple crystal report which throws this error? For example with one parameter and one table, so we can isolate the issue.

Sreejith_S · December 6, 2016, 2:09pm

Hi ,

I have simple crystal report on the server which works fine. But it uses the local DB and neither it have any parameters. How can I resolve the parameter issue ?

Thanks
Sreejith

IF_Eduardo · December 7, 2016, 2:56pm

Hi,

you said that when you select parameter then click extract parameter a lot of keys are shown up. And now you say your report doesn’t have any parameters?

Please provide a minimal report that throws this exception.

Sreejith_S · December 8, 2016, 12:34pm

Hi ,

Now I have managed to run the crystal report , but still getting error while trying run crystal report using the datasource as Databasebundle.
I have a databae bundle that points to three identical copies of a db , but while trying to execute the report with databasebundle as datasource getting the following error.

The report could not be executed: Could not open connection to: null with user: null. null
To get help please contact an administrator.
Details
net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: Could not open connection to: null with user: null. null at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:218) at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:119) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exeucteReport(ReportExportServlet.java:535) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doExportReport(ReportExportServlet.java:416) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReport(ReportExportServlet.java:346) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportViaSession(ReportExportServlet.java:339) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(ReportExportServlet.java:168) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$2f1766ce.CGLIB$doGet$1() at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$2f1766ce$$FastClassByGuice$$30574e5d.invoke() at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$2f1766ce.doGet() at javax.servlet.http.HttpServlet.service(HttpServlet.java:622) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$2f1766ce.CGLIB$service$18() at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$2f1766ce$$FastClassByGuice$$30574e5d.invoke() at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$2f1766ce.service() at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:873) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:687) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2508) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2497) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: net.datenwerke.rs.core.service.reportmanager.exceptions.DatabaseConnectionException: Could not open connection to: null with user: null. null at net.datenwerke.rs.base.service.datasources.transformers.bundle.Bundle2JdbcDatasourceTransformer.transform(Bundle2JdbcDatasourceTransformer.java:38) at net.datenwerke.rs.base.service.datasources.transformers.bundle.Bundle2JdbcDatasourceTransformer.transform(Bundle2JdbcDatasourceTransformer.java:1) at net.datenwerke.rs.base.service.datasources.transformers.DatasourceTransformationServiceImpl.transform(DatasourceTransformationServiceImpl.java:29) at net.datenwerke.rs.core.service.reportmanager.engine.ReportEngine.transformDatasource(ReportEngine.java:240) at net.datenwerke.rs.crystal.service.crystal.reportengine.CrystalReportEngine.doExecute(CrystalReportEngine.java:61) at net.datenwerke.rs.core.service.reportmanager.engine.ReportEngine.execute(ReportEngine.java:148) at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:186) … 57 more Caused by: java.lang.NullPointerException at net.datenwerke.rs.base.service.datasources.definitions.DatabaseDatasource.getConnectionConfig(DatabaseDatasource.java:161) at net.datenwerke.rs.base.service.datasources.transformers.bundle.Bundle2JdbcDatasourceTransformer.transform(Bundle2JdbcDatasourceTransformer.java:35) … 63 more

Could you please look ino this.

Regards,
Sreejith

IF_Eduardo · December 13, 2016, 1:25pm

Hi Sreejith,

we identified the issue with:
The report could not be executed: Could not open connection to: null with user: null. null
To get help please contact an administrator.
Details
net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: Could not open connection to: null with user: null. null at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:218) at
…

There was a bug trying to run a Crystal report with the translation from the bundle entry to the corresponding JDBC datasource. We have corrected this and will be fixed in the next reportserver release.

Best regards,
Eduardo

Sreejith_S · December 14, 2016, 9:42am

Hi Eduardo ,

Thank you for looking into the issue. I thought it might have something to do with the db URL format since format of MsSQL db URL differ from MySQL.

Thanks & Regards,
Sreejith