MySQL connection issue creating Ad Hoc reports using the JasperReports Server

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

Issue: 

  I have done Jasper Integration and I was able to generate General reports (CA pre-defined reports). However when I selected "SpectrumDomain" to create an Ad Hoc report on CABI JasperConsole I got the following error at the stage of drag and dropping available Availability fields into Columns or Groups fields or Ad Hoc View contents frame.

"An error occurred while creating the connection. Try again."

ConnectError.jpg

 

If I looked into <Tomcat Install Dir>\webapps\jasperserver-pro\WEB-INF\logs\jasperserver.log I found the following java exception

  java.sql.SQLNonTransientConnectionException: Could not connect to breeze-w2k8vm3:3306 : Connection timed out: connect

If I went to home page of JasperConsole, clicked "View List" link under Data Sources section, right-clicked spectrum_domain_ds data source and clicked Edit, I saw breeze-w2k8vm3 was populated in "Host(required):" field.

breeze-w2k8vm3.jpg

Environment:  

Spectrum 10.1.1 with CABI JasperReports Server 6.1.0

Resolution: 

This issue has been addressed in Spectrum 10.01.01.D58. Please contact Technical Support to download the debug patch and apply it on your OneClick + SRM machine and redo the Jasper integration to fix this problem. When the problem is fixed spectrum_domain_ds data source should have "Host(required):" field correctly populated, i.e. with your Oneclick + SRM machine's name. 

Additional Information: 

Bug id (DE158525, 00357615).

Generate Ad Hoc Reports in JasperConsole