Slow response time on Activities page in RSA Identity Governance & Lifecycle
Article Number
Applies To
RSA Version/Condition: 7.x
Issue
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 |
Cause
Resolution
- RSA Identity Governance & Lifecycle 7.5.0 P09
- SecurID Governance & Lifecycle 7.5.2 P05
Related Articles
The Requested On date for Change Requests is incorrectly updated to the time of any Approval or Activity that is performed… Number of Views Authentication using acetest fails TRANSACTION_ROLLBACK on real time authentication activity monitor for RSA Authenticatio… Number of Views Entitlements manually added when an Application has 'Complete Manual Activity Before Collection' enabled are not removed w… Number of Views Entitlements manually added when an Application has 'Complete Manual Activity Before Collection' enabled do not show in th… Number of Views How to calculate the RSA REST API Authentication Response Time Number of Views
Trending Articles
RSA SecurID software token .sdtid file fails to import into RSA SecurID Software Token 5.0 for Windows RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide Customizing TLS Protocol Version RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device
Don't see what you're looking for?
