Required PTF to integrate Spectrum 10.2.1 to CABI JasperReports Server for Unified Dashboard

Document ID : KB000007827
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

I tried to integrate Spectrum 10.2.1 with CABI JasperReports Server for Unified Dashboard 6.3 and got Internal Server error like the following.

IntegrationError.png

Tomcat log, i.e. $SPECROOT/tomcat/logs/stdout.log (on Windows) or catalina.out (on Linux/Solaris) shows the following exceptions.

(http-bio-8080-exec-2) (ReportManager) - (ERROR) - Error Importing:
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at java.net.Socket.connect(Socket.java:538 

 

 

Environment:
Spectrum 10.2.1, CABI JasperReports Server for Unified Dashboard 6.3
Cause:

10.02.01.PTF_10.2.117 is required to be applied on Spectrum 10.2.1 OneClick Server prior the integration. You can download the PTF from Download Manager section in Support Online Portal. After you login and go to Download Manager and select Spectrum Product download item, e.g. CA Spectrum Device Based Suite MULTI-PLATFORM, set upper-right Release pull-down to 10.2 and Service Pack pull-down to 1. The PTF download items are on the 2nd page.

PTF117Download.png

Resolution:

Shutdown OneClick Server (Spectrum Tomcat service) on OneClick Server machine, apply 10.02.01.PTF_10.2.117, restart OneClick Server. Now you need to go to your CABI JasperReports Server, launch Internet Browser and navigate to CA Spectrum OneClick Web server > Administration > Report Manager > Report Manager Admin Tools > Jasper Integration page. Click on 'Integration Components' link to download spectrumConfigInstaller.jar. On a DOS or terminal go to CABI java/bin directory and run the below command:

java -jar spectrumConfigInstaller.jar -host <OneClick Server URL including port> -username <OneClick Admin user> -password <OneClick Admin Password> -jasperTomcat <CABI Tomcat Location> -appName <Jasper webapp name>

For example, on Windows launched a DOS prompt and change directory to "C:\Program Files\CA\SharedComponents\CA Business Intelligence\java\bin" and run the following command

.\java.exe -jar C:\Path\to\spectrumConfigInstaller.jar -host http://<OneClick Server hostname>:8080 -username <username> -password <password> -jasperTomcat "C:\Program Files\CA\SharedComponents\CA Business Intelligence\apache-tomcat" -appName jasperserver-pro

RunIntegrationComponentOnCABI.png

Note: CABI Jasper Tomcat restart is required after running this utility.

After that you can redo the integration. 

Additional Information: