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

Document ID:  TEC1936338
Last Modified Date:  08/04/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Spectrum

Releases

  • CA Spectrum:Release:10.2

Components

  • JASPERSOFT FOR CA SPECTRUM:SPCJSP
Symptoms:

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)

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >