Poor Jasper performance

book

Article ID: 130385

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

Jasper takes very long time to process anything. Including logging in and generating a simple report. Sometimes the reports are created after a while. Sometimes they never complete.

Cause

Model security on the individual and group reports.

Environment

Spectrum integrated with jasper

Resolution

To resolve this issue:

1. Ensure the Enable Security parameter in the OneClick Administration -> Report Manager -> Preferences page is set to False



2. Remove the model security for the q_entity_id query in Jasper by doing the following:

    a. Log into the Jasper Console as the superuser
    b. Select View -> Repository from the top level menu
    c. Navigate to the Public -> ca -> Spectrum -> inputcontrols -> queries folder
    d. Select q_entry_id and click on the Edit button
    e. Click the Next button twice until the "Define the Query" is highlighted
    f. Change the query to the following:

SELECT e.entity_name, e.entity_id, l.domain_name,CONCAT(e.entity_name," ",'(@',l.domain_name,')') name 
FROM (select current_model_key,entity_id,entity_name,destroy_time,landscape_h from entity) e 
inner join landscape l on e.landscape_h = l.landscape_h 
inner join devicemodel d on e.current_model_key=d.model_key 
WHERE e.destroy_time is NULL 
GROUP BY e.current_model_key 
ORDER BY e.entity_name
 
   
g. Click on the Save button

3. Remove the model security for the q_group_name query in Jasper by doing the following:

    a. Log into the Jasper Console as the superuser
    b. Select View -> Repository from the top level menu
    c. Navigate to the Public -> ca -> Spectrum -> inputcontrols -> queries folder
    d. Select q_group_name and click on the Edit button
    e. Click the Next button twice until the "Define the Query" is highlighted
    f. Change the query to the following:

select distinct entity_group_name, group_id from entitygroup 
inner join groupentitygroups on groupentitygroups.entity_group_id=entitygroup.entity_group_ID 
inner join entitygroupentity on entitygroupentity.entity_group_ID = groupentitygroups.entity_group_id 
inner join entity e on e.entity_id = entitygroupentity.entity_ID 
inner join model m on e.current_model_key = m.model_key 
where $X{EQUAL,entitygroup.entity_group_type,p_group_type} 


g. Click on the Save button

4. Restart the JasperServer on the Jasper system

Attachments

1558687962401000130385_sktwi1f5rjvs16fgn.png get_app