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
RSA ID Plus Admin Logs Connector - RSA Ready Implementation Guide Number of Views Language Codes for Security Questions Number of Views MFA Agent Lookup REST API Number of Views RSA Authentication Manager 8.7 SP1 False Positive Security Vulnerabilities Number of Views Unexpected MFA Challenge for Unchallenged Users when machines are in WORKGROUP environment Number of Views
Trending Articles
RSA Authentication Manager 8.9 Release Notes (January 2026) RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Troubleshooting AFX Server issues in RSA Identity Governance & Lifecycle Downloading RSA Authentication Manager license files or RSA Software token seed records
Don't see what you're looking for?
