Crystal Report Connections Failing

[seanarchernz]

We have recently upgraded to SAP Crystal Server 2013 SP06 from CRS2011.

All went well with the upgrade including the Crystal Reports which updated from 2011 to 2013.

Post upgrade we have had to update the Database Connection details for a number of Crystal Reports due to a migration of Database Servers.

All of the reports connect to the new source databases and run successfully within Crystal Designer.  However, only some run once saved back to the repository.

Some of the ones that failed WILL run if I choose Save As and give the report a new name. 

For the ones that worked with a new name I have tried Deleting the old report and then saving the new report with the old name.  In one case this worked and with others it hasn't.

It seems to me that the report connection details are being cached somewhere and are being used in place of any new credentials provided.  Any suggestions on where to look for the connection caches or what services might need to be restart would be appreciated. 

The error received when running the reports is:

"The viewer could not process an event. The database logon information for this report is either incomplete or incorrect. [] ---- Error code:0 [CRWEB00000119]"

Details of error:

2015-07-03 12:35:51 com.businessobjects.report.web.shared.WebReportingException: The viewer could not process an event. The database logon information for this report is either incomplete or incorrect. [] ---- 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:1503) 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:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) 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:727) at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:168) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:763) Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: The database logon information for this report is either incomplete or incorrect.---- 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: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:1490) ... 52 more

[seanarchernz · Accepted solution]

Well can probably scratch this question...after waiting for a period of time and then retrying the reports they are working...whatever was cached must have cleared.  Horrible, random....horrible application...