Failure to generate any CA Spectrum reports after a fresh installation of CABI 4.1 SP3

book

Article ID: 38211

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

After fresh installing CABI 4.1 on Linux the user is not able to run default CA Reports.  The following error is displayed in the screen:   

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

Cause

The “Update Content” is failing to update the Data Sources field in the BOXI.

The NoSuchMethodError error was found in the Spectrum Tomcat log (catalina.out) file after enabling the  “SRM – BOXI – Content Installer” module in debug module (In OneClick Administration web page -> Debugging -> Web Server Debug Page (Runtime):

Feb 16, 2016 16:15:42.725 (http-bio-8080-exec-4) (SRMConInst) - MySQL privilege grant operation completed.
Feb 16, 2016 16:15:42.726 (http-bio-8080-exec-4) (SRMConInst) - Modifying database parameters of SRM on-demand reports.
Feb 16, 2016 16:15:42.961 (http-bio-8080-exec-4) (SRMConInst) - Processing on-demand folder "CA Spectrum" (id=7853)
Feb 16, 2016 16:15:43.000 (http-bio-8080-exec-4) (SRMConInst) - Processing on-demand folder "Alarm" (id=7974)
Feb 16, 2016 16:15:43.021 (http-bio-8080-exec-4) (SRMConInst) - Processing on-demand folder "All" (id=7964)
Feb 16, 2016 16:15:43.265 - CrystalReportDAO.updateReportLogonCredentials:
java.lang.NoSuchMethodError: com.crystaldecisions.sdk.occa.report.application.ReportAppSession.setReportEngineTypeValue(I)V
     at com.crystaldecisions.sdk.occa.managedreports.ras.internal.RASReportAppFactory.getReportAppSession(RASReportAppFactory.java:688)
     at com.crystaldecisions.sdk.occa.managedreports.ras.internal.RASReportAppFactory.openDocument(RASReportAppFactory.java:512)
     at com.crystaldecisions.sdk.occa.managedreports.ras.internal.RASReportAppFactory.openDocument(RASReportAppFactory.java:485)
     at com.crystaldecisions.sdk.occa.managedreports.ras.internal.RASReportAppFactory.openDocument(RASReportAppFactory.java:438)
     at com.aprisma.spectrum.app.repmgr.re.bo.u11x.dao.crystal.CrystalReportDAO.updateReportLogonCredentials(CrystalReportDAO.java:354)
     at com.aprisma.spectrum.app.repmgr.install.crystal.SRMContentManager.processFolder(SRMContentManager.java:901)
     at com.aprisma.spectrum.app.repmgr.install.crystal.SRMContentManager.processFolder(SRMContentManager.java:914)
     at com.aprisma.spectrum.app.repmgr.install.crystal.SRMContentManager.processFolder(SRMContentManager.java:914)
     at com.aprisma.spectrum.app.repmgr.install.crystal.SRMContentManager.updateCrystalReports(SRMContentManager.java:817)
     at com.aprisma.spectrum.app.repmgr.install.crystal.SRMContentManager.doImport(SRMContentManager.java:125)
     at com.aprisma.spectrum.app.repmgr.dc.admin.web.action.ImportBOXIContentAction.execute(ImportBOXIContentAction.java:40)
     at com.aprisma.spectrum.app.repmgr.dc.admin.web.AdminDispatcherServlet.doPost(AdminDispatcherServlet.java:137)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
     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 org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
     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:613)
     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
     at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
     at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
     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.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:745)
 

 

Environment

CA Spectrum 10.2.3 or below integrated with CABI 4.1 SP3
 

Resolution

1. Login to Spectrum OneClick SRM machine as the user that owns the Spectrum installation and navigate to $SPECROOT/tomcat/lib directory.

2. Please take the back up of rasapp.jar & rascore.jar files and keep it in any other directory or desktop folder.

3. Then remove the rasapp.jar & rascore.jar from $SPECROOT/tomcat/lib directory.

4. Once the jar files are removed then restart the Spectrum Tomcat service.

5. Log into the OneClick web page as an ADMIN user and run "Update Content" from Administration -> Report Manager -> Manage Business Objects Content.

Attachments

1558686422091000038211_sktwi1f5rjvs16f0r.png get_app