Slow performance in Add Entitlement screen when creating or editing a role in RSA Governance & Lifecycle
Last Modified: 2023-10-06
Article Number
000068051
Applies To
  • SecurID Governance & Lifecycle 7.5.2
  • RSA Identity Governance & Lifecyle 7.5.0
Issue
When trying to add entitlement in the Entitlements tab during creating/editing the role, it takes a lot of time to load the entitlements into the GUI.

image.png

And the following query shows as long-running with a large number of executions in the AWR.
SQLIDQuery
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
This issue is resolved in the following versions/patches:
  • SecurID Governance & Lifecycle 7.5.2 P05
  • RSA Identity Governance & Lifecycle 7.5.0 P09

Related Articles

Trending Articles

Don't see what you're looking for?