Collections are slow in Indirect Relationship Processing step in RSA Identity Governance & Lifecycle
Originally Published: 2021-04-29
Last Modified: 2022-06-20
Article Number
Applies To
RSA Version/Condition: 7.2.0, 7.2.1, 7.5.0
Issue
RSA Identity Governance & Lifecycle collector slow in Indirect Relationship Processing.
The following query may be identified in AWR reports as running long.
f8sj8nc35b82w UPDATE T_AV_EXPLODEDUSERENTITLEMENTS old_ SET DELETION_DATE = SYSDATE WHERE DELETION_DATE IS NULL AND RUN_ID = -:"SYS_B_00
The Database Logs for Run may show slower processing in the step "9/12: Process New Role Relationships", specifically in 4 sub steps in Explode_LocalRoles related to T_AV_EXPLODEDUSERENTITLEMENTS.
Cause
This issue is caused by poor execution plans for some SQL queries related to Roles.
This is a known issue in the following versions which have additional steps in Indirect Relationship Processing:
- RSA Identity Governance & Lifecycle 7.2.0
- RSA Identity Governance & Lifecycle 7.2.1
- RSA Identity Governance & Lifecycle 7.5.0
Resolution
This issue has been resolved in the following versions/patches which introduce code changes and new indexes which increase performance:
- RSA Identity Governance & Lifecycle 7.5.0 P02
- RSA Identity Governance & Lifecycle 7.2.1 P05
Workaround
Rebuilding indexes on T_AV_EXPLODEDUSERENTITLEMENTS can improve general performance on queries against this table but customers should apply the patch in order to fully resolve this issue.
Related Articles
Indirect Relationship Processing slower in Step 11/12 Calculate Role Metrics in RSA Governance & Lifecycle Number of Views RSA Identity Governance and Lifecycle Account Data Collector (ADC) and Entitlement Data Collectors (EDC) are slow in step … Number of Views Unification slow and identity collections show users in reprocessed state in RSA Identity Governance & Lifecycle Number of Views Remote collection agents fail after installing JRE/JDK 1.7.0_191+ or 1.8.0_181+ in RSA Identity Governance & Lifecycle Number of Views Data Archiving fails in Data Purging step in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Reporting on RSA Authentication Manager 8.x users with On-Demand Token, a fixed passcode or a hardware/software token assi… How to Download OTP Token Seed Files from myRSA Anomalix idGenius - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
