Integration failure in Jasper Reports 6.3.0

book

Article ID: 7066

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

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

<Please see attached file for image>

Jasper_Reports_integration_failed.png

 

 

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

 

Environment

CA Spectrum 10.2 or 10.3 and JasperReports Server 6.3.0

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

Please reference the "CABI JasperReports Server Integration with CA Spectrum" section of the documentation for more information.

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

Attachments

1558691570985000007066_sktwi1f5rjvs16gnr.png get_app