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
Multiple roles stuck in applied state after applying bulk change on multiple roles in RSA Governance & Lifecycle 303Number of Views Business descriptions are applied incorrectly when using a wildcard with an underscore in RSA Identity Governance and Life… 19Number of Views BlackBerry browser get stuck on javascript collector 19Number of Views Change Request Cancel and Revert is not Always Reverting Indirect Items in RSA Identity Governance & Lifecycle 13Number of Views Enhancement to the aveksaServerInfo.log file starting in version 7.2.0 of RSA Identity Governance & Lifecycle 117Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?