CABI/Jaspersoft reports stop working upon upgrade of Spectrum to 24.3.7 and 24.3.8

Products

• Network Observability
• Spectrum

Issue/Introduction

After upgrading to Spectrum to 24.3.7, CA Business Intelligence (CABI) / JasperReports reports fail with a popup error of:

Error Message
jsexception.error.creating.connection

Error Trace
com.jaspersoft.jasperserver.api.ErrorDescriptorException: jsexception.error.creating.connection at
com.jaspersoft.jasperserver.remote.services.ReportExecution.getFinalReportUnitResult(ReportExecution.java:173) at
com.jaspersoft.jasperserver.remote.services.impl.RunReportServiceImpl$2.run(RunReportServiceImpl.java:491) at
com.jaspersoft.jasperserver.api.logging.util.LoggableExecutorService$1.run(LoggableExecutorService.java:84) at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750)

When testing the spectrum_ds data source the following error is seen at the bottom of the page:

Could not connect to HostAddress{host='<Report Manager Server Hostname>', port=3306, type='master'}. Host '<CABI server hostname>' is not allowed to connect to this MySQL server 

 

Environment

Spectrum 24.3.7, 24.3.8

Cause

Defect: DE168734

Resolution

A script is attached to this article to address this issue.

To run, s the spectrum installation owner:

1) Download the zipped script to $SPECROOT on the Report Manager Server (the OneClick host used for the CABI integration)

2) If on Windows, enter a bash shell:

bash -login

3) cd to $SPECROOT if needed and unzip the 

unzip update_CR_user.zip

4) Make the script executable:

chmod +x update_CR_user.sh

5) Execute the script:

./update_CR_user.sh

Note: Do not run the script more than once.

Verify the CABI reports now run.

If you still receive an error, test the spectrum_ds data source:

Home->Data Sources
RIght click and edit the spectrum_ds data source
Test the data source


If it fails, you may need to update the data source URLs in CABI after re-deploying the reports.

Also make sure the version of CABI is as noted in the Compatibility Matrix

 

Additional Information

This issue has been fixed in DX NetOps Spectrum 24.3.9:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/spectrum/24-3/release-information/issues-resolved.html

Symptom: After upgrading to 24.3.7, the Jasper server is unable to generate reports. 
Resolution: With this fix, Spectrum fixes the CR_user plugin type and adds a new script to move the CR_user plugin type from native to cache_ss2 and conversely. 
(DE168734, 36265250, 36252213, 24.3.9)