Slow response time on Requests tab in RSA Governance & Lifecycle
Article Number
Applies To
RSA Version/Condition: 7.x.x
Issue
The following query shows in the AWR report as being executed for a very large number of times:
| 1ugmvsurbj3tj | select changerequ0_."ID" as ID1_12_0_, changerequ0_.NAME as NAME2_12_0_, .... |
Also, the AWR reports that a Full scan of TABLE "AVUSER.T_AV_WFERRORS" consumed 100% of the database time.
Cause
To check if you have this issue run the following SQL query as AVUSER:
Select INDEX_NAME From User_Indexes Where lower(Table_Name)='t_av_wferrors';
The query output should contain the following 3 indexes
- IXN_WFERROR_JOBREF_CL
- IXN_WFERROR_JOB
- IXN_WFERROR_NODE
Resolution
- RSA Governance & Lifecycle 7.5.0 P09
- RSA Governance & Lifecycle 7.5.2 P05
- RSA Governance & Lifecycle 7.6
Related Articles
Service Provider hangs at throughput of 5 assertions per second Number of Views RSA SecurID Hardware Appliance IEC 62368 certification Number of Views RSA ID Plus Admin Logs Connector - RSA Ready Implementation Guide Number of Views FIM not able to handle authentication cycles taking longer then 5 minutes Number of Views Microsoft Sentinel as SIEM for RSA Admin Logs Using Logic Apps - RSA Ready Implementation Guide Number of Views
Trending Articles
RSA Authentication Manager 8.9 Release Notes (January 2026) RSA announces the availability of the RSA SecurID Hardware Appliance 230 based on the Dell PowerEdge R240 Server How to troubleshoot Oracle database ORA-04030 errors in RSA Identity Governance & Lifecycle RSA Authentication Manager Upgrade Process Microsoft SQL Server Collectors can no longer connect to the SQL Server database after upgrade to Microsoft SQL Server 201…
Don't see what you're looking for?
