Issue with running Crystal Reports from Web application running Websphere 8.5.5

[former_member773590]

Hello, I have an issue with running crystal reports from Websphere application(Websphere 8.5.5).

I had it working in Websphere 6.1, but after the upgrade none of the reports work, getting the message below:

ERROR com.crystaldecisions.reports.queryengine - Error occored at setQueryDefinitionInfo():Unexpected database connector error

The are few differences between Websphere 8.5.5 and Websphere 6.1:

1) Websphere 8.5.5 is running Java 8, while Websphere 6.1 Java 5

2) Websphere 8.5.5 is using Microsoft JDBC Driver 9.4 while Websphere 6.1 is using embedded JDBC SQL server driver

The method which fails is viewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);

This method is called from JSP file CrystalReportViewer.jsp

The complete stack trace is shown below:

[10/26/21 11:50:12:798 EDT] 0000006a SystemOut O 11:50:12.798 [WebContainer : 0] ERROR com.crystaldecisions.reports.queryengine - Error occored at setQueryDefinitionInfo():Unexpected database connector error

[10/26/21 11:50:12:798 EDT] 0000006a SystemOut O 11:50:12.798 [WebContainer : 0] ERROR com.businessobjects.reports.sdk.JRCCommunicationAdapter - detected an exception: Unexpected database connector error

at com.crystaldecisions.reports.datafoundation.DFQuery.for(SourceFile:632)

at com.crystaldecisions.reports.datalayer.a.do(SourceFile:1622)

at com.crystaldecisions.reports.datalayer.a.a(SourceFile:1405)

at com.crystaldecisions.reports.dataengine.m.void(SourceFile:336)

at com.crystaldecisions.reports.dataengine.j.void(SourceFile:531)

at com.crystaldecisions.reports.dataengine.m.o(SourceFile:422)

at com.crystaldecisions.reports.dataengine.m.a(SourceFile:173)

at com.crystaldecisions.reports.dataengine.ContextNode.a(SourceFile:114)

at com.crystaldecisions.reports.dataengine.ContextNode.a(SourceFile:95)

at com.crystaldecisions.reports.dataengine.j.case(SourceFile:1096)

at com.crystaldecisions.reports.dataengine.h.<init>(SourceFile:108)

at com.crystaldecisions.reports.dataengine.DataContext.a(SourceFile:258)

at com.crystaldecisions.reports.dataengine.DataProcessor2.a(SourceFile:4665)

at com.crystaldecisions.reports.dataengine.DataProcessor2.a(SourceFile:4579)

at com.crystaldecisions.reports.dataengine.DataProcessor2.try(SourceFile:2656)

at com.crystaldecisions.reports.dataengine.DataProcessor2.case(SourceFile:2614)

at com.crystaldecisions.reports.dataengine.DataProcessor2.byte(SourceFile:2286)

at com.crystaldecisions.reports.dataengine.DataProcessor2.new(SourceFile:2446)

at com.crystaldecisions.reports.dataengine.DataProcessor2.I(SourceFile:1015)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.ft(SourceFile:526)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.if(SourceFile:613)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.a(SourceFile:578)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.Y(SourceFile:387)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.moveToPageN(SourceFile:339)

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

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.byte(SourceFile:219)

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

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:526)

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.dt.a(SourceFile:186)

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

at com.crystaldecisions.sdk.occa.report.application.ReportSource.getPage(SourceFile:767)

at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.getPage(SourceFile:324)

at com.businessobjects.report.web.event.s.a(SourceFile:158)

at com.businessobjects.report.web.event.s.a(SourceFile:127)

at com.businessobjects.report.web.event.bt.a(SourceFile:47)

at com.businessobjects.report.web.event.bw.broadcast(SourceFile:93)

at com.businessobjects.report.web.event.am.a(SourceFile:53)

at com.businessobjects.report.web.a.v.if(SourceFile:2152)

at com.businessobjects.report.web.e.a(SourceFile:304)

at com.businessobjects.report.web.e.a(SourceFile:206)

at com.businessobjects.report.web.e.a(SourceFile:135)

at com.crystaldecisions.report.web.ServerControl.a(SourceFile:607)

at com.crystaldecisions.report.web.ServerControl.processHttpRequest(SourceFile:342)

at com.ibm._jsp._CrystalReportViewer._jspService(_CrystalReportViewer.java:199)

at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:99)

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

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

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

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

at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)

at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:122)

at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:220)

at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)

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

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

at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)

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

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

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

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

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

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

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:138)

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

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

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

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

I tried using CrystalReportsJars_SP22 and CrystalReportsJars_SP27 libraries - still same issue

Any hints would be greatly appreciated

Thanks, Sam

[former_member11696]

Hi Sam,

Need to know what version of CR for Eclipse, or BOE/CRS Java you are using?

And typically when upgrading CR/BOE/CRS Server you need to update the JAR's also.

See the PAM on help.sap.com for what's supported with your version.

Here's the one for 4.2:

Short Presentation Title (sap.com)

[former_member773590]

Thanks, issue was solved by changing data source in Websphere configuration from embedded driver for MSSQL server to native Microsoft ODBC Driver 9.4