Slow performance in Add Entitlement screen when creating or editing a role in RSA Governance & Lifecycle
Last Modified: 2023-10-06
Article Number
Applies To
- SecurID Governance & Lifecycle 7.5.2
- RSA Identity Governance & Lifecyle 7.5.0
Issue
And the following query shows as long-running with a large number of executions in the AWR.
| SQLID | Query |
| dyzx6jjcmp62y |
WITH ROLE_VERS (ROLE_TYPEID, ROLE_ID, ROLEVERSION_ID, ROOT_TYPEID) AS ( SELECT 'P'||ROLEVERSION_ID ROLE_TYPEID, ROLE_ID, ROLEVERSION_ID, 'P'||ROLEVERSION_ID ROOT_TYPEID FROM T_AV_ROLEVERSIONS WHERE ROLEVERSION_ID = :B1 UNION ALL SELECT 'C'||D.ENT_ID, D.ENT_ID, TO_NUMBER(NULL) ROLEVERSION_ID, R.ROOT_TYPEID FROM ROLE_VERS R JOIN T_AV_ROLEVERDEFINITIONS D ON D.ROLEVERSION_ID = R.ROLEVERSION_ID WHERE D.ENT_TYPE = 'global-role' ), ROLES (ROLE_TYPEID, ROLE_ID, ROLEVERSION_ID, ROOT_TYPEID) AS ( SELECT ROLE_TYPEID, ROLE_ID, ROLEVERSION_ID, ROOT_TYPEID FROM ROLE_VERS UNION ALL SELECT 'C'||D.ENT_ID, D.ENT_ID, TO_NUMBER(NULL) ROLEVERSION_ID, R.ROOT_TYPEID FROM ROLES R JOIN T_AV_ROLEDEFINITIONS D ON D.ROLE_ID = R.ROLE_ID WHERE R.ROLEVERSION_ID IS NULL AND D.DELETION_DATE IS NULL AND D.ENT_TYPE = 'global-role' ) SELECT ROLE_TYPEID_TYPE(ROLE_TYPEID , ROLE_ID, ROLEVERSION_ID, ROOT_TYPEID) FROM (SELECT DISTINCT ROLE_ID, ROLEVERSION_ID, ROOT_TYPEID, ROLE_TYPEID FROM ROLES) |
Resolution
- SecurID Governance & Lifecycle 7.5.2 P05
- RSA Identity Governance & Lifecycle 7.5.0 P09
Related Articles
Persistence layer issue in RSA Identity Governance & Lifecycle degrades performance and potentially leads to system crash 70Number of Views Provisioning Termination Rule creating request to revoke groups even though there is already a request from rule to remove… 37Number of Views Job Level variables are sometimes lost when REST or SOAP nodes are configured to work in parallel with other nodes in RSA … 44Number of Views Performance issues seen when processing Role modifications in RSA Identity Governance & Lifecycle 91Number of Views Provisioning/Termination Rule does not create change requests to revoke entitlements if the rule also disables and/or dele… 181Number 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?