Jasper report parameter screen not loading

book

Article ID: 127082

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

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

Cause

Unnecessary model security portion of the report query

Environment

Jasper 6.x

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
  4. Edit 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