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
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Reporting on RSA Authentication Manager 8.x users with On-Demand Token, a fixed passcode or a hardware/software token assi… How to Download OTP Token Seed Files from myRSA Anomalix idGenius - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
