Integration failure in Jasper Reports 6.3.0
Article ID: 7066
Updated On:
Products
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
Environment
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
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
Feedback
