Error with Crystal Reports Server

[former_member785560]

Server - Crystal Report Server 2011

Client - Crystal Reports 2011

Initially we had an issue when opening reports via the Crystal Reports portal. When opening reports, it asked for the ODBC settings to be entered. I think I may have solved this by ammending the ODBC connection details so that the Name is the server name of the SQL server as when imported to Crystal Server, it used the Name field as the server name.

However not we get the following error when opening:

The viewer could not process an event. Failed to open the connection.
Report Test []
---- Error code:0 [CRWEB00000119]

2018-01-08 15:19:56
com.businessobjects.report.web.shared.WebReportingException: The viewer could not process an event. Failed to open the connection.
Report Test [] ---- Error code:0 [CRWEB00000119]
	at com.businessobjects.report.web.shared.WebReportingException.throwWebReportingException(WebReportingException.java:71)
	at com.businessobjects.report.web.component.ViewerContainer.processEvents(ViewerContainer.java:2021)
	at com.businessobjects.report.web.WorkflowController.doEventProcessing(WorkflowController.java:425)
	at com.businessobjects.report.web.WorkflowController.doLifecycle(WorkflowController.java:262)
	at com.businessobjects.report.web.WorkflowController.doAsyncLifecycle(WorkflowController.java:110)
	at com.crystaldecisions.report.web.viewer.CrystalReportViewerUpdater._processHttpRequest(CrystalReportViewerUpdater.java:61)
	at com.crystaldecisions.report.web.ServerControl.processHttpRequest(ServerControl.java:342)
	at com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet.doUpdate(CrystalReportViewerServlet.java:89)
	at com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet.doPost(CrystalReportViewerServlet.java:78)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at com.businessobjects.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:110)
	at com.businessobjects.http.servlet.internal.ServletLastFilterChainElement.service(ServletLastFilterChainElement.java:30)
	at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:46)
	at com.businessobjects.webutil.boetrustguard.BOETrustPrepareFilter.doFilter(BOETrustPrepareFilter.java:32)
	at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)
	at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)
	at com.businessobjects.swd.shared.tracelog.TraceLogScopeFilter.doFilter(TraceLogScopeFilter.java:38)
	at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)
	at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)
	at com.businessobjects.sdk.actionfilter.WorkflowFilter.doFilter(WorkflowFilter.java:45)
	at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)
	at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)
	at com.businessobjects.swd.appcontext.RequestInitFilter.doFilter(RequestInitFilter.java:26)
	at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)
	at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)
	at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.serviceHelper(BundlePathAwareServiceHandler.java:235)
	at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.service(BundlePathAwareServiceHandler.java:197)
	at com.businessobjects.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:248)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:159)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:619)
Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Failed to open the connection.
Report Test---- Error code:-2147215357 [] Error code name:internal
	at com.crystaldecisions.sdk.occa.report.lib.ReportSDKException.throwReportSDKException(ReportSDKException.java:120)
	at com.crystaldecisions.sdk.occa.managedreports.ps.internal.SendRequestHelper.sendRequest(SendRequestHelper.java:123)
	at com.crystaldecisions.sdk.occa.managedreports.ps.internal.CacheReportSource.sendRequest(CacheReportSource.java:1523)
	at com.crystaldecisions.sdk.occa.managedreports.ps.internal.CacheReportSource.getPage(CacheReportSource.java:1036)
	at com.businessobjects.report.web.event.PageListener.renderContentLocally(PageListener.java:337)
	at com.businessobjects.report.web.event.PageListener.getPage(PageListener.java:165)
	at com.businessobjects.report.web.event.PageListener.updatePage(PageListener.java:114)
	at com.businessobjects.report.web.event.UpdatePageEvent.processListener(UpdatePageEvent.java:47)
	at com.businessobjects.report.web.event.ViewerBroadcaster.broadcast(ViewerBroadcaster.java:104)
	at com.businessobjects.report.web.event.EventQueue.processEvents(EventQueue.java:53)
	at com.businessobjects.report.web.component.ViewerContainer.processEvents(ViewerContainer.java:2008)
	... 45 more