Integration failure in Jasper Reports 6.3.0

Document ID:  TEC1786574
Last Modified Date:  06/08/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Spectrum

Releases

  • CA Spectrum:Release:10.2
  • CA Spectrum:Release:10.2.1

Components

  • JASPERSOFT FOR CA SPECTRUM:SPCJSP
Problem:

After a successful installation of JasperReports Server 6.3.0, the following error is displayed in the Jasper Integration web page:

Error:Internal Server Error. Integration failed

Jasper_Reports_integration_failed.png

 

 

Environment:
CA Spectrum 10.2.x and JasperReports Server 6.3.0
Cause:

The JasperReports 6.3.0 was not installed from the CA Spectrum product. It was installed from CA Service Desk Manager product.

 

The following entries were found in the Tomcat log file (stdout.log) after enabled the "SRM - Core - Report Manager" module in debug mode and tried to enable the Jasper Integration:

May 31, 2017 17:15:23.011 (http-bio-80-exec-18) (RepMgr) - (DEBUG) - Granting MySQL privileges to JasperServer Jasper_Reports_server_host 

May 31, 2017 17:15:23.011 (http-bio-80-exec-18) (RepMgr) - (DEBUG) - MySQL privilege grant operation completed. 

May 31, 2017 17:15:23.027 (http-bio-80-exec-18) (ReportManager) - (ERROR) - Error Importing: 

Caused by: java.io.FileNotFoundException: http://Jasper_Reports_server_host:8080/SpectrumProxy/actionController?action=integrate&srmHost=OneClick_SRM_server_host&srmTomcatPort=80&jasperHost=Jasper_Reports_server_host&jasperTomcatPort=8080&protocol=http&jasperUser=superuser&jasperPassword=ffffff8e,ffffffbe,4f,ffffff8c,31,ffffffbd,4a,ffffffdb,1d,27,ffffff92,64,fffffff6,ffffffb1,ffffffab,3b,19,ffffff81,7d,ffffffce,ffffffce,79,ffffffca,ffffff99,d,1e,ffffff8e,fffffff7,ffffffda,4b,3d,43&webappName=jasperserver-pro&group=spectrum 

 

The SpectrumProxy folder and SpectrumProxy.war file under the C:\Program Files\CA\SC\CA Business Intelligence\apache-tomcat\webapps\ directory are missing. 

 

As per the CABusinessIntelligence_install_yyyy_mm_dd_hh_mm_ss.log file, the ..\overlay\spectrum\webapps folder was not imported:

ImportingFiles:

     [echo]  Moving the Required Web Application files to the Application server...

2017-05-31 15:33:10 INFO  ProgressThread:103 - After run: null

     [echo] The webapps to be copied from CA_SDM to the webapps/jasperserver-pro directory of the application server

     [copy] Copying 17 files to C:\Program Files\CA\SC\CA Business Intelligence\apache-tomcat\webapps\jasperserver-pro

     [echo] ..\overlay\CA_SDM\webapps is copied to the webapps/jasperserver-pro directory of the application server

     [echo] The webapps to be copied from ca_common to the webapps/jasperserver-pro directory of the application server

     [copy] Copying 36 files to C:\Program Files\CA\SC\CA Business Intelligence\apache-tomcat\webapps\jasperserver-pro

     [echo] ..\overlay\ca_common\webapps is copied to the webapps/jasperserver-pro directory of the application server

 

path_creation:

     [echo]  ../../overlay/CA_SDM/scripts 

 

These are the expected entries in the CABusinessIntelligence_install_yyyy_mm_dd_hh_mm_ss.log file:

ImportingFiles:

     [echo]  Moving the Required Web Application files to the Application server...

2017-06-01 17:10:14 INFO  ProgressThread:103 - After run: null

     [echo] The webapps to be copied from ca_common to the webapps/jasperserver-pro directory of the application server

     [copy] Copying 36 files to C:\Program Files\CA\SC\CA Business Intelligence\apache-tomcat\webapps\jasperserver-pro

     [echo] ..\overlay\ca_common\webapps is copied to the webapps/jasperserver-pro directory of the application server

     [echo] The webapps to be copied from spectrum to the webapps/jasperserver-pro directory of the application server

     [copy] Copying 1 file to C:\Program Files\CA\SC\CA Business Intelligence\apache-tomcat\webapps\jasperserver-pro

     [echo] ..\overlay\spectrum\webapps is copied to the webapps/jasperserver-pro directory of the application server

     [copy] Copying 1 file to C:\Program Files\CA\SC\CA Business Intelligence\apache-tomcat\webapps

 

Resolution:

If you are using JasperReports Server that comes with other than CA Spectrum product, then do the following before integration along with webservers supported.

 

Copy the SpectrumProxy.war file from the location $SPECROOT\Spectrum\Install-Tools\SRM-Tools\jasper\ of the OneClick+SRM host to Japserserver\tomcat\webapps folder (C:\Program Files\CA\SC\CA Business Intelligence\apache-tomcat\webapps\) of the JasperReports server.

Restart the Jasper Tomcat Server.

Additional Information:

https://docops.ca.com/ca-spectrum/10-2-1/en/installing-and-upgrading/install-report-manager/cabi-jasperreports-server/cabi-jasperreports-server-integration-with-ca-spectrum

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >