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

[Former Member]

Hi All,

We are getting the following exception on Pre-Prod and Production environment while printing the Crystal Report certificate. But this Certificate is working fine in

lower environments( Local, DEV and QA). Please see the exception stack trace and please help on this. Since 4days onwards we are figuring out this issue but we did not get any clue. I appreciate your help on this.

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

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Unexpected database connector error---- Error code:-2147467259 Error code name:failed

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.if(SourceFile:237)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:147)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:128)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:111)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.aig.alico.webapp.actions.FulfillmentDocumentsAction.processPDF(FulfillmentDocumentsAction.java:2961)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.aig.alico.webapp.actions.FulfillmentDocumentsAction.printReport(FulfillmentDocumentsAction.java:1854)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at java.lang.reflect.Method.invoke(Method.java:618)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1213)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1154)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.aig.alico.webapp.service.AuthenticationFilter.doFilter(AuthenticationFilter.java:330)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:848)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:691)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:654)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:526)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:764)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1478)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:133)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:457)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:300)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1830)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:751)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R  at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1560)

[11/26/12 22:51:22:758 CET] 00000029 SystemErr     R Caused by: com.crystaldecisions.reports.common.QueryEngineException: Unexpected database connector error

at com.crystaldecisions.reports.queryengine.Connection.br(SourceFile:1788)

at com.crystaldecisions.reports.queryengine.Connection.bs(SourceFile:491)

at com.crystaldecisions.reports.queryengine.Connection.t1(SourceFile:2978)

at com.crystaldecisions.reports.dataengine.dfadapter.DFAdapter.a(SourceFile:696)

at com.crystaldecisions.reports.dataengine.dfadapter.DFAdapter.for(SourceFile:706)

at com.crystaldecisions.reports.reportdefinition.ReportHelper.a(SourceFile:198)

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.long(SourceFile:957)

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.a(SourceFile:635)

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.int(SourceFile:672)

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

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

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

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:529)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:527)

at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:525)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:424)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:352)

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.ReportSource.a(SourceFile:1558)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:337)

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.if(SourceFile:223)

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:147)

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:128)

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:111)

at com.aig.alico.webapp.actions.FulfillmentDocumentsAction.processPDF(FulfillmentDocumentsAction.java:2961)

at com.aig.alico.webapp.actions.FulfillmentDocumentsAction.printReport(FulfillmentDocumentsAction.java:1854)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:618)

at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)

at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)

at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1213)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1154)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)

at com.aig.alico.webapp.service.AuthenticationFilter.doFilter(AuthenticationFilter.java:330)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)

at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:848)

at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:691)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:654)

at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:526)

at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)

at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:764)

at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1478)

at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:133)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:457)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:300)

at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)

at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1830)

at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)

at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)

at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:751)

at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1560)

Caused by: com.crystaldecisions.reports.queryengine.driverImpl.javabean.JBLogonFailed: Unexpected database connector error

at com.crystaldecisions.reports.queryengine.driverImpl.javabean.JavaBeanConnection.Open(Unknown Source)

at com.crystaldecisions.reports.queryengine.JDBConnectionWrapper.Open(SourceFile:123)

at com.crystaldecisions.reports.queryengine.Connection.br(SourceFile:1771)

[DellSC]

What version of the software are you using?  Are you running the report through BusinessObjects, some third-party software, or software that you've written?  What type of database are you connecting to? 

Are you using an ODBC connection?  If so, please verify that you have a 32-bit ODBC connection set up in each of the environments (Crystal will NOT connect using a 64-bit connection regardless of how the server is set up!) and that the connection is set up the same way in all of the environments.

-Dell