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

Document ID : KB000005239
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When trying to view a Crystal Report in Infoview the following error message is received:

 

1 CRWEB00000119.JPG

when click on Show Details error is:

2017-01-17 13:48:47
com.businessobjects.report.web.shared.WebReportingException: The viewer could not process an event. Failed to open the connection.
Survey Summary [] ---- 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:1439)
	at com.businessobjects.report.web.WorkflowController.doEventProcessing(WorkflowController.java:353)
	at com.businessobjects.report.web.WorkflowController.doLifecycle(WorkflowController.java:255)
	at com.businessobjects.report.web.WorkflowController.doAsyncLifecycle(WorkflowController.java:106)
	at com.crystaldecisions.report.web.viewer.CrystalReportViewerUpdater._processHttpRequest(CrystalReportViewerUpdater.java:61)
	at com.crystaldecisions.report.web.ServerControl.processHttpRequest(ServerControl.java:345)
	at com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet.doUpdate(CrystalReportViewerServlet.java:206)
	at com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet.doPost(CrystalReportViewerServlet.java:194)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	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.bip.core.web.filter.BrowserRenderingModeFilter.doFilter(BrowserRenderingModeFilter.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.bip.core.web.boetrustguard.BOETrustPrepareFilter.doFilter(BOETrustPrepareFilter.java:35)
	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.bip.core.web.supportabilty.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.bip.core.web.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:722)
	at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
	at java.lang.Thread.run(Thread.java:761)
Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Failed to open the connection.
Survey Summary---- 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:141)
	at com.crystaldecisions.sdk.occa.managedreports.ps.internal.CacheReportSource.sendRequest(CacheReportSource.java:1796)
	at com.crystaldecisions.sdk.occa.managedreports.ps.internal.CacheReportSource.getPage(CacheReportSource.java:1283)
	at com.businessobjects.report.web.event.PageListener.renderContentLocally(PageListener.java:377)
	at com.businessobjects.report.web.event.PageListener.getPage(PageListener.java:178)
	at com.businessobjects.report.web.event.PageListener.updatePage(PageListener.java:120)
	at com.businessobjects.report.web.event.UpdatePageEvent.processListener(UpdatePageEvent.java:47)
	at com.businessobjects.report.web.event.ViewerBroadcaster.broadCastEvent(ViewerBroadcaster.java:136)
	at com.businessobjects.report.web.event.ViewerBroadcaster.broadcast(ViewerBroadcaster.java:110)
	at com.businessobjects.report.web.event.EventQueue.processEvents(EventQueue.java:53)
	at com.businessobjects.report.web.component.ViewerContainer.processEvents(ViewerContainer.java:1426)
	... 51 more

 

Environment:
BusinessObjects Enterprise 4.0 SP6BusinessObjects Enterprise 4.1 SP3/SP5
Cause:

This issue is caused by Improper database credentials for the report.

Resolution:
  1. Log in to CMC.
  2. Locate the report.
  3. Right click on the report, select 'Database Configuration'.
  4. Provide correct database connection details and click on 'Update'.
  5. Re-run the report from Infoview.
Additional Information:

https://launchpad.support.sap.com/#/notes/0001558691