Jasper report parameter screen not loading

Products

• Spectrum
• Network Observability

Issue/Introduction

The Jasper report parameter screen is hanging and not loading when attempting to run it

Environment

Jasper 6.x, 7.x

Cause

Unnecessary model security portion of the report query

Resolution

To resolve do the following:

1. Connect to mysql and run a show full processlist
   
   
2. If you see  SELECT if(is_security_enabled='true',1,0) from registry into retval then kill the process as this indicates the model security portion of the query is causing the hang
   
   
3. Go to View repository ~~> Public ~~> ca ~~> Spectrum ~~> inputcontrols ~~> queries
   
   
   
   
   
4. Edit both q_entity_id and q_group_name and remove the following line:
   
   inner join reporting.v_security_string_accessibility_by_landscape sec on (d.landscape_h=sec.landscape_h) and (d.security_string=sec.security_string) and (is_security_enabled()= FALSE or sec.user_name=$P{LoggedInUsername})
   
   
   
   
   
   
   
   
   
5. After saving the updated query the report parameter screen should now open