cancel
Showing results for 
Search instead for 
Did you mean: 

CMC Report goes from running to failed

0 Kudos

I am trying to run a report in CMC and the Status gives me a running status for about ten seconds, then it goes to a failed status. I have double checked the Database Configuration, and it is configured correctly. I have also been able to run these reports in Crystal Server, just not the web interfaced CMC or the BI. the error that I am getting is "Error code:0 [CRWEB00000119"

DellSC
Active Contributor
0 Kudos

Is the connection to the database for the report configured on the server? In other words, is the 32-bit database client installed and do you have a 32-bit ODBC connection configured if you're using ODBC? (The platform everything runs on is 64-bit, including the processes that run Crystal for Enterprise reports, but the Crystal 2016 stuff is all 32-bit.)

When you published the report, did you go to the CMC and edit its Database Configuration to make sure that it's configured to log in to the database? The settings I usually use are:

When viewing and scheduling report: Use same database logon as when report is run. NOTE: If you're connecting to more than one data source in the report, you have to set this for each data source listed in the drop-down above it.

If the connection name is the same as where the report was designed, you can use the original database logon information, otherwise you have to use a custom database logon. In either case, you need to make sure the user ID is correct and you need to enter the database password for that user.

After saving that information, right-click on the report and go to Refresh Options. UN-check "Default database logon information" and save. This will set things up so that if you update the report and republish it, it won't overwrite the database configuration you just set.

-Dell

Accepted Solutions (0)

Answers (2)

Answers (2)

denis_konovalov
Active Contributor
0 Kudos

It would help if you provide details on the actuall product you are using.
If report is running in Crystal reports and doesn't run in CMC/BI - that usually means the CRystal report processing server has some issues.
So, you should enable high level traces on CR processing server, CR cash server and possibly RAS server in CMC and see what the traces show.

0 Kudos

I apologize, we are running 2016 Crystal Reports SP5 and 2016 Crystal Server SP6. Additionally I enabled high traces on CR processing server, CR Cache Server, and CR Report Application Server. But I'm not sure how to see what the traces show. Could you direct me how to view the traces so I may post them here.

denis_konovalov
Active Contributor
0 Kudos

traces will be in the /logging directory and have .glf extension and server name in the name.
They should show a actual errors that happened.

Alternatively, you can follow KBA 1861180 - Customer instructions and best practice for collecting a BI Platform 4.x end to end trace, and analyze the whole workflow.

0 Kudos

So I followed KBA 1861180, and it instructs to delete any files that are named "BO_trace.ini.err". I keep deleting it, and I'm assuming the trace would run and then a file labeled "BO_trace.ini" would appear. This doesn't happen, it just keeps popping up a "BO_trace.ini.err" file. I have high trace set in the servers in CMC. What should I do at this point?

denis_konovalov
Active Contributor
0 Kudos

deleting this file will not start the trace, if that file is generated that means there are errors in your bo_trace.ini and you need to troubleshoot as per KBA 2627515
BO_trace.ini will not appear it should already be there.

To generate trace you need to follow content in the Part 2 of the KBA I gave you "GENERATE THE TRACE"

ayman_salem
Active Contributor
0 Kudos

Getting BO_trace.ini.err means you have typeo in the BO_trace.ini file, so if you look in BO_trace.ini.err, you will see which text caused the error of BO_trace.ini

then correct it and the trace will be generated

0 Kudos

I generated reports following the guideline given. What should I be looking for error-wise, or should I just upload a certain file?

denis_konovalov
Active Contributor
0 Kudos

Now you could use KBA https://service.sap.com/sap/support/notes/2203047 to analyze those traces. (it is referenced in the E2E trace KBA).

Basically, you need to look at the workflow, see what errors are shown at which point and follow up on them.

If you need help analyzing the traces - you should create an SAP Support incident with BI-BIP-ADM component.

DellSC
Active Contributor
0 Kudos

Unfortunately, that it a generic error code that may apply to a number of different issues. Is there any other text in the error that might tell us what's happening?

-Dell

0 Kudos

Here is the additional error code that I get with it:

2018-10-04 10:26:32
com.businessobjects.report.web.shared.WebReportingException: The viewer could not process an event. Failed to open the connection.
ASURION 38 & UNDER [] ---- 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:1561)
	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:661)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	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:742)
	at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:275)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:203)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:808)
Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Failed to open the connection.
ASURION 38 & UNDER---- 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:1543)
	... 60 more
denis_konovalov
Active Contributor
0 Kudos

When I search for this error i get following KBA https://launchpad.support.sap.com/#/notes/1558691