Poor Jasper performance

Products

• Spectrum
• Network Observability

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.

Environment

Spectrum integrated with jasper

Cause

Model security on the individual and group reports.

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_entity_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