Jaspersoft Error "jrs.jsexception.error.creating.connection"

Document ID : KB000115218
Last Modified Date : 24/09/2018
Show Technical Document Details
Issue:
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.2.3
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:
There are 2 ways to address this problem:
  1. Changing datasource settings manually
    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
    6. Click Save to leave the screen and click Save on the upcoming popup, too.
    7. Repeat steps 4 to 6 for spectrum_ds
  2. Request and apply patch 10.02.03.PTF_10.2.336