Article Number
000067984
Applies To
RSA Product Set: RSA Governance & Lifecycle
RSA Version/Condition: 7.x.x
Issue
When clicking on the Requests tab it takes a lot of time to load, also, when clicking on Requests under a user page it takes a lot of time to load.
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
This issue may occur if the indexes are absent on the T_AV_WFERRORS table
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
If an index is missing, please reach out to RSA technical support team by opening a case and mention the KB article number.
Resolution
This is resolved in the following versions which correct the problem.
- RSA Governance & Lifecycle 7.5.0 P09
- RSA Governance & Lifecycle 7.5.2 P05
- RSA Governance & Lifecycle 7.6
