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
