Slow response time on Activities page in RSA Identity Governance & Lifecycle
Last Modified: 2023-10-06
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
Unable to update time servers on Aveksa 6.8.1 Number of Views Troubleshooting the Authentication Test Number of Views Enable RADIUS on Identity Routers in a Cluster Number of Views Troubleshooting tips on testing and configuring NTP for time synchronization on RSA Identity Governance & Lifecycle servers Number of Views How to view workflow variable values during workflow execution in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Manual synchronization introduced in RSA Authentication Manager 8.2 Service Pack 1 patch 6 Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to verify NTP server synchronization is not working in RSA Authentication Manager 8.x RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?
