CA Spectrum - Jaspersoft Error "jrs.jsexception.error.creating.connection"
search cancel

CA Spectrum - Jaspersoft Error "jrs.jsexception.error.creating.connection"

book

Article ID: 115218

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

After new Jasperreport Server installation and successful integration you receive a popup window in Jasperreport Server with the following exception message, when trying to run a report.

jrs.jsexception.error.creating.connection
java.sql.SQNNonTransientConnectionException: Could not connect to address ....

Environment

Spectrum OneClick Server 10.X
Jasperreport Server 6.4.3

Cause

The datasource setting in Jasperreport Server is wrong after initial integration or executing Re-deploy in
Spectrum OneClick - Administration - Report Manager - Jasper Integration

Resolution

This issue has been addressed in Spectrum 10.2.3 with the 10.02.03.PTF_10.3.336 patch.

This issue has also been addresses in Spectrum 10.4.1.

This issue can also be addressed by doing the following:

    1. Login to Jasperreport Server
    2. In the menu bar select: View -> Repository
    3. Open the folder: root -> Public -> ca -> Spectrum -> datasources
    4. Right click on spectrum_domain_ds in the Repository area and select Edit
    5. In the upcoming screen (Edit Data Source: spectrum_domain_ds) edit the URL to fit your SRM (Spectrum Report Manager) name:
      • jdbc:mysql://<<your_SRM_Server_Name>>:3306/srmdbapi
      • Note : Do not Enter FQDN in the SRM Server Name, just enter Host Name
    6. Click Save to leave the screen and click Save on the upcoming popup, too.
    7. Repeat steps 4 to 6 for spectrum_ds

Note : Please restart the Apache Tomcat on the Jaspersoft Server & Relaunch the browser.

If you test the connection and you are still unable to connect, try adding the fully qualified domain name to the name of the SRM machine.  For example instead of:

mysql://spec_mls:3306/srmdbapi

Add the FQDN:

mysql://spec_mls.broadcom.com:3306/srmdbapi