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 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 Persistence layer issue in RSA Identity Governance & Lifecycle degrades performance and potentially leads to system crash Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA Authentication Manager Patch Updates How to factory reset an RSA Authentication Manager 8.x hardware appliance without a factory reset button from the Operatio… Limiting users to one token per user ID in RSA Authentication Manager 8.x Configure Session and Authentication Method Settings
Don't see what you're looking for?
