Cant View or Shedule Report on BusinessObjects | Error code:0 [CRWEB00000119]

[kevin_stulert76]

Hi everybody,

I get the error "The viewer could not process an event. Failed to open the connection ---- Error code:0 [CRWEB00000119]" if I try to view or shedule 2 reports.

Those reports work fine on Crystal Reports but not on the BusinessObject server.

What I dont understand is, that 2 other reports, which generate much larger results are running without problems on the same connection with the same credentials.

I already set the Database Records paramter on the Processing Server to unlimited:

And also the records on the application server to unlimited:

This changed nothing.

I hope somebody is able to help me to resolve this issue.

Thanks and best regards,

Kevin Stulert

The server is:

SAP BusinessObjects BI Platform 4.3 Support Pack 3 Patch 1
Version: 14.3.3.4496

And the Crystal Reports

Full Error log:

2023-03-30 10:27:18<br>com.businessobjects.report.web.shared.WebReportingException: Der Viewer konnte kein Ereignis verarbeiten. Fehler beim Öffnen der Verbindung.<br>VEREINNAHMUNG UNGEPLANTE RETOUREN_V1.3 [] ---- Error code:0 [CRWEB00000119]<br>    at com.businessobjects.report.web.shared.WebReportingException.throwWebReportingException(WebReportingException.java:71)<br>    at com.businessobjects.report.web.component.ViewerContainer.processEvents(ViewerContainer.java:1551)<br>    at com.businessobjects.report.web.WorkflowController.doEventProcessing(WorkflowController.java:374)<br>    at com.businessobjects.report.web.WorkflowController.doLifecycle(WorkflowController.java:276)<br>    at com.businessobjects.report.web.WorkflowController.doAsyncLifecycle(WorkflowController.java:109)<br>    at com.crystaldecisions.report.web.viewer.CrystalReportViewerUpdater._processHttpRequest(CrystalReportViewerUpdater.java:61)<br>    at com.crystaldecisions.report.web.ServerControl.processHttpRequest(ServerControl.java:345)<br>    at com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet.doUpdate(CrystalReportViewerServlet.java:206)<br>    at com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet.doPost(CrystalReportViewerServlet.java:194)<br>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)<br>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)<br>    at com.businessobjects.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:110)<br>    at com.businessobjects.http.servlet.internal.ServletLastFilterChainElement.service(ServletLastFilterChainElement.java:30)<br>    at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:46)<br>    at com.businessobjects.bip.core.web.filter.BrowserRenderingModeFilter.doFilter(BrowserRenderingModeFilter.java:38)<br>    at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)<br>    at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)<br>    at com.businessobjects.webutil.boetrustguard.ClickjackingPreventionFilter.doFilter(ClickjackingPreventionFilter.java:66)<br>    at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)<br>    at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)<br>    at com.businessobjects.webutil.security.SecurityFilter.doFilter(SecurityFilter.java:22)<br>    at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)<br>    at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)<br>    at com.businessobjects.bip.core.web.boetrustguard.BOETrustPrepareFilter.doFilter(BOETrustPrepareFilter.java:35)<br>    at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)<br>    at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)<br>    at com.businessobjects.bip.core.web.supportabilty.TraceLogScopeFilter.doFilter(TraceLogScopeFilter.java:41)<br>    at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)<br>    at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)<br>    at com.businessobjects.sdk.actionfilter.WorkflowFilter.doFilter(WorkflowFilter.java:47)<br>    at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)<br>    at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)<br>    at com.businessobjects.bip.core.web.appcontext.RequestInitFilter.doFilter(RequestInitFilter.java:26)<br>    at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)<br>    at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)<br>    at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.serviceHelper(BundlePathAwareServiceHandler.java:235)<br>    at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.service(BundlePathAwareServiceHandler.java:197)<br>    at com.businessobjects.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:248)<br>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)<br>    at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:275)<br>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)<br>    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)<br>    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br>    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)<br>    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br>    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br>    at com.businessobjects.http.HstsFilter.doFilter(HstsFilter.java:70)<br>    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br>    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br>    at com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:213)<br>    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br>    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br>    at com.businessobjects.http.HttpMethodValidatorFilter.doFilter(HttpMethodValidatorFilter.java:43)<br>    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br>    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br>    at com.businessobjects.saml.CustomSAMLDelegatingFilterProxy.doFilter(CustomSAMLDelegatingFilterProxy.java:57)<br>    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br>    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br>    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)<br>    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)<br>    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)<br>    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)<br>    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)<br>    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)<br>    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)<br>    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)<br>    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)<br>    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)<br>    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)<br>    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)<br>    at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)<br>    at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)<br>    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)<br>    at java.lang.Thread.run(Thread.java:838)<br>Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Fehler beim Öffnen der Verbindung.<br>VEREINNAHMUNG UNGEPLANTE RETOUREN_V1.3---- Error code:-2147215357 [] Error code name:internal<br>    at com.crystaldecisions.sdk.occa.report.lib.ReportSDKException.throwReportSDKException(ReportSDKException.java:120)<br>    at com.crystaldecisions.sdk.occa.managedreports.ps.internal.SendRequestHelper.sendRequest(SendRequestHelper.java:141)<br>    at com.crystaldecisions.sdk.occa.managedreports.ps.internal.CacheReportSource.sendRequest(CacheReportSource.java:1831)<br>    at com.crystaldecisions.sdk.occa.managedreports.ps.internal.CacheReportSource.getPage(CacheReportSource.java:1311)<br>    at com.businessobjects.report.web.event.PageListener.renderContentLocally(PageListener.java:383)<br>    at com.businessobjects.report.web.event.PageListener.getPage(PageListener.java:180)<br>    at com.businessobjects.report.web.event.PageListener.updatePage(PageListener.java:121)<br>    at com.businessobjects.report.web.event.UpdatePageEvent.processListener(UpdatePageEvent.java:47)<br>    at com.businessobjects.report.web.event.ViewerBroadcaster.broadCastEvent(ViewerBroadcaster.java:136)<br>    at com.businessobjects.report.web.event.ViewerBroadcaster.broadcast(ViewerBroadcaster.java:110)<br>    at com.businessobjects.report.web.event.EventQueue.processEvents(EventQueue.java:53)<br>    at com.businessobjects.report.web.component.ViewerContainer.processEvents(ViewerContainer.java:1533)<br>    ... 72 more<br>

[DellSC]

In the CMC, you need to go to the Database Configuration for each of the report and make sure that you've set the password for the database connection. If the reports are configured to use AD SSO to the database, then the service account that is being used to run the SIA needs to have access to log in and read data in the report's database.

If the SIA is not using a service account, by default it's using the local service account on the server. This account doesn't have access to any network resources. If this is the case, you'll either need to:

1. Have a service account created on the network. Make this account a member of the Administrators user group on the server and give it access to the database.

2. Change the connection on the report to use a specific logon instead of AD SSO.

Also, if you're using an ODBC connection, you'll need to make sure that you have a 64-bit ODBC DSN configured on the server that has the same name as the DSN on your development computer.

-Dell

[kevin_stulert76]

Hi Dell,

thanks for the fast response!

The ODBC connection on the server is the same as on the develompment computer:

Thas guaranteed because the reports are developed on the same instance as the server is installed at (both SAP BusinessObjects and Crystal Reports 2020 are installed on the same instance).

Database configuration was done for all reports (those which work perfectly fine as well as those which get the error message I attached):

The password is correct. It's copied from a password manager and does not generate any errors on Crystal Reports 2020.

As far as I can say the report should not use any AD SSO. At least I did not consciously configured this on Crystal Reports 2020. How ca I check this?

Are there any other things I can check to get an idea why those 2 reports may not work?

Best regards,

Kevin

[DellSC]

Do those two reports have subreports that might be using a different connection than the main report? If so, you'll need to set the DB password for those as well - there should be an option at the top-left of the DB configuration screen in the CMC that will let you select any other connections in the report to do that.

To check for AD SSO, you would open the report in Crystal and then open the Database Expert. Find the connection the report uses, right-click on it and select "Properties". Scroll down and look for "Integrated Security". If it's set to True, the connection is using SSO. You would do this same process for any subreports as well.

-Dell