Roles stuck in Applied state in SecurID Governance & Lifecycle
Last Modified: 2023-09-25
Article Number
Applies To
Issue
The AWR report may show the following SQL statement, as SQL ID a55znbsdprvx6, with a high number of "enq: TX - row lock contention" events:
| SELECT ID FROM T_AV_MODEL_EXPLODEDUSERENTS WHERE ID IN (SELECT MIN(E.ID) FROM GTT_ROLE_IDS G, T_AV_MODEL_EXPLODEDUSERENTS E WHERE E.ROLE_ID = G.ID AND E.ROLE_TYPE = 'C' GROUP BY E.ROLE_ID) FOR UPDATE |
Cause
Resolution
This issue is resolved in the following versions which include an optimized query for the Role metric calculation:
- SecurID Governance & Lifecycle 7.5.2
- RSA Identity Governance & Lifecycle 7.5.0 P05
- RSA Identity Governance & Lifecycle 7.2.1 P08
These versions/patches also include a migration script ACM-112571.sql to reduce the size of the T_AV_MODEL_EXPLODEDENTITLEMENTS table which further enhances performance.
Related Articles
Change Requests in Pending Submission state are not being deleted by the daily scheduled task in RSA Identity Governance &… Number of Views Multiple roles stuck in applied state after applying bulk change on multiple roles in RSA Governance & Lifecycle Number of Views Enhancement to the aveksaServerInfo.log file starting in version 7.2.0 of RSA Identity Governance & Lifecycle Number of Views Menu bar on the top and footer section in the bottom on the UI are not visible after applying patch in RSA Governance & Li… Number of Views Business descriptions are applied incorrectly when using a wildcard with an underscore in RSA Identity Governance and Life… Number of Views
Trending Articles
Artifacts to gather in RSA Identity Governance & Lifecycle How to Update the Root (Server) and Client Certificates in RSA Identity Governance & Lifecycle How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Troubleshooting AFX Connector issues in RSA Identity Governance & Lifecycle How to Download and Reinstall the AFX Server Archive in RSA Governance & Lifecycle
Don't see what you're looking for?
