Slow performance in Add Entitlement screen when creating or editing a role in RSA Governance & Lifecycle

[#1]

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 description

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

This issue is resolved in the following versions/patches:

• SecurID Governance & Lifecycle 7.5.2 P05
• RSA Identity Governance & Lifecycle 7.5.0 P09