Slow response time on Requests tab in RSA Governance & Lifecycle
Last Modified: 2023-10-06
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
Slow response time on Activities page in RSA Identity Governance & Lifecycle Number of Views Slow INSERT statement executing from the SoD_Rule_Pkg in RSA Identity Governance & Lifecycle Number of Views How to calculate the RSA REST API Authentication Response Time Number of Views How to check the connectivity and response time of an Identity source for RSA Authentication Manager using ldapsearch Number of Views On RSA Via Lifecycle and Governance the aveksa_server start returns message: Cannot connect to the database, but the DB is up Number of Views
Trending Articles
Deploy an Identity Router Virtual Machine in Microsoft Azure How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide Offline Days Are Not Downloaded for RSA MFA Agent 2.x After Enabling Offline Authentication Policy in Authentication Manag… RSA-2026-18: RSA Security Update for PHP Vulnerabilities
Don't see what you're looking for?
