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

book

Article ID: 5239

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

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

 

<Please see attached file for image>

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

 

Cause

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

Environment

BusinessObjects Enterprise 4.0 SP6BusinessObjects Enterprise 4.1 SP3/SP5

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

Attachments

1558704499084000005239_sktwi1f5rjvs16qjb.jpeg get_app