Skip to Content
0
Jun 21, 2020 at 11:32 AM

Crystal Server 2016 / Oracle 10g Database Connection

107 Views Last edit Jun 20, 2020 at 09:07 PM 2 rev

Just installed Crystal Reports Server on Windows 2012 R2 Server. Have created a report in Crystal 2016 by connecting to the Oracle 10g database but when i try to view the report in CMC or through the web browser I get the error below. I left the database login info the same as what was in the report and have tried several ways to change it but cannot get a connection. I have tested tnsping on my windows server and all databases in my tnsnames file connect fine via tnsping.

The viewer could not process an event. Error in File crystal_test: Failed to load database information. [] ---- Error code:0 [CRWEB00000119] 2020-06-20 13:57:55 com.businessobjects.report.web.shared.WebReportingException: The viewer could not process an event. Error in File crystal_test: Failed to load database information. [] ---- 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:1615) at com.businessobjects.report.web.WorkflowController.doEventProcessing(WorkflowController.java:373) at com.businessobjects.report.web.WorkflowController.doLifecycle(WorkflowController.java:275) at com.businessobjects.report.web.WorkflowController.doAsyncLifecycle(WorkflowController.java:108) 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:660) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) 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: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.webutil.boetrustguard.ClickjackingPreventionFilter.doFilter(ClickjackingPreventionFilter.java:51) 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:41) 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:47) 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:741) at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:275) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:205) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.businessobjects.http.HttpMethodValidatorFilter.doFilter(HttpMethodValidatorFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.businessobjects.saml.CustomSAMLDelegatingFilterProxy.doFilter(CustomSAMLDelegatingFilterProxy.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:836) Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Error in File crystal_test: Failed to load database information.---- 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:1802) at com.crystaldecisions.sdk.occa.managedreports.ps.internal.CacheReportSource.getPage(CacheReportSource.java:1283) at com.businessobjects.report.web.event.PageListener.renderContentLocally(PageListener.java:379) at com.businessobjects.report.web.event.PageListener.getPage(PageListener.java:180) at com.businessobjects.report.web.event.PageListener.updatePage(PageListener.java:121) 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:1597) ... 66 more Show Details Hide Details OK

FIXED

ADDED TNS_ADMIN TO REGISTRY UNDER ORACLE HOME AS MENTIONED HERE:

https://apps.support.sap.com/sap/support/knowledge/public/en/1752459