JasperReports - Individual reports hang in loading and never load the Parameter page

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

The following individual reports hang in loading when they are launched, and the Parameter page is never loaded: 

 

Alarm 

Individual Alarm Log-Selected Devices and Models 

 

Assets 

Individual Current Asset Detail: Selected Devices 

Individual Current Ports Detail: Selected Devices 

Individual Current Ports Summary: Selected Devices 

 

Availability 

Individual Availability Selected Devices 

Individual Availability Selected Models 

Environment:
CA Spectrum 10.2 and JasperReports 6.3
Cause:

Wrong joins in the MySQL queries is causing performance slow down.

Resolution:

Issue was resolved in CA Spectrum 10.2.1 release.

 

This is the workaround for CA Spectrum 10.2.0 release:

Optimize the queries in the following input controls:

 

Steps to Edit the queries: 

1) Please login as Superuser. 

 

2) Now in home page go to View drop down we will get an option like "Repository", Click on that. 

 

3) Now Navigate to root-->Organizations-->spectrum-->capability-->inputcontrols folder. 

 

4) Now choose queries. 

 

5) Now choose q_entity_id cilck on 'edit'. 

 

6) Now click on 'Next' again 'Next'. 

 

7) Now you will have a tab with name Query String, remove three lines below from the existing query: 

inner join v_security_string_accessibility_by_landscape v 

on m.landscape_h = v.landscape_h 

AND m.security_string = v.security_string 

 

8) After removing click on 'save'. 

 

9) Now under inputcontrols we will have "resportspecific", click on that and click on "Alarm Log-Selected Devices and Models" folder, on right side we will get some items. 

 

10) Now choose $R{p_modelName} click on edit. 

 

11) Now click on 'Next' again 'Next', again 'Next', again 'Next'. 

 

12) Now we will have a tab with name Query String, remove one line from the existing query: 

INNER JOIN v_security_string_accessibility_by_landscape v on(m.landscape_h = v.landscape_h and m.security_string = v.security_string ) 

 

13) After removing click on 'save'. 

 

14) Now click on 'Submit'. 

 

Additional Information:

If you enabled the JasperReports integration on 10.2 release and then upgraded to 10.2.1, you MUST re-deploy the reports.

 

https://docops.ca.com/ca-spectrum/10-2-1/en/release-information/issues-resolved#IssuesResolved-FixestoReportManager

Fixes to Report Manager

Symptom: Spectrum Jasper reports are taking long time to open and consume more memory.
Resolution: Spectrum Jasper reports are optimized to perform better than earlier.
(10.2.1, DE269954, 00503003)