Indirect Relationship Processing slower in Step 11/12 in RSA Governance & Lifecycle
2 years ago
Article Number
000069909
Applies To
This is a known issue in the following versions:
  • RSA Identity Governance & Lifecycle 7.2.0 P09
  • RSA Identity Governance & Lifecycle 7.2.1 P06
  • RSA Identity Governance & Lifecycle 7.5.0 P04
  • SecurID Governance & Lifecycle 7.5.2 Build 181843 (Original GA version with limited distribution)
Issue

Indirect Relationship Processing may be slower in Step 11/12 than in previous versions.

The following queries may show in the AWR report. 

SQL IdSQL Text
4ayd94cf95ucgBEGIN Common_Exploder.Process(...
bbrysfyw274pfINSERT INTO GTT_ROLEENTS_STAGI
Cause
This KB article tracks various improvements made to Indirect Relationship Processing (IRP) in later versions. 
Resolution

This issue is resolved in the following versions:

  • RSA Identity Governance & Lifecycle 7.2.1 P12
  • RSA Identity Governance & Lifecycle 7.5.0 P07
  • SecurID Governance & Lifecycle 7.5.2 P03
These versions include the following improvements in Indirect Relationship Processing (IRP)
  • Role Constraint Metrics are calculated periodically every 2 hours instead of calculating every time Indirect Relation Processing is run.
  • Role Missing Entitlement Metrics calculation is done for the affected roles in the case of EDC and RDC instead of calculating for all the roles.
  • Role Constraint or Missing Entitlement Metrics is now calculated during Rule execution. And this calculation is done only for the affected Roles.