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 ID Plus Admin Logs Connector - RSA Ready Implementation Guide Number of Views Recursive Faulty view upon clicking on 'Additional Information' under CR link in the Activity/Approval tabs in RSA Governa… Number of Views MFA Agent Lookup REST API Number of Views How to calculate the RSA REST API Authentication Response Time Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.8 Setup and Configuration Guide
Don't see what you're looking for?
