RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.x
When clicking on the Activities page it takes a lot of time to load.
The following query shows in the Oracle AWR report as being executed for a very large number of times:
|4ksjup0yzz7px||select state, count(*) from (select * from (SELECT /*+ complete-pend-count-by-workitem */ WI.CR_ID, (CASE WHEN WI.WORK_STATE_ID IN (:"SYS_B_00", :"SYS_B_01", :"SYS_B_02") AND WI.JOB_STATE_ID = :"SYS_B_03" THEN :"SYS_B_04" ELSE :"SYS_B_05" END) as state FROM V_AV_WFWORKITEMS WI left join t_av_change_requests PCR on PCR.ID = WI.CR_ID WHERE WI.WORK_TYPE = :"SYS_B_06" AND WI.WORK_STATE_ID IN (:"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11")) ) group by state|
This is a known issue reported in Engineering ticket ACM-110328.
This is resolved in the following versions which correct the problem by creating a new Index on table T_AV_CHANGE_REQUESTS_MST:
- RSA Identity Governance & Lifecycle 7.5.0 P09
- SecurID Governance & Lifecycle 7.5.2 P05