000039139 - Rule Pre-processing is slow in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jul 17, 2020Last modified by RSA Customer Support Employee on Aug 24, 2020
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000039139
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.1.0, 7.1.1, 7.2.0
 
IssueRule Pre-Processing run time is slow in RSA Identity Governance & Lifecycle as seen under Admin > Monitoring > Run Type: Rules Pre-processing.

An AWR report may show the following query as a top consumer:

3zj0h93pydczf  DELETE FROM T_AV_UA_RULE_COVERAGE RC WHERE RC.RULE_ID = :B1


For information on how to generate an AWR report, see RSA Knowledge Base Article 000037779 -- How to generate an Oracle Automatic Workload Repository (AWR) report for RSA Identity Governance & Lifecycle.
 
CauseThis is a known issue reported in engineering ticket ACM-104642.

An index on internal table T_AV_UA_RULE_COVERAGE (the table in the query from the AWR) is defined incorrectly.
 
ResolutionThis issue is resolved in RSA Identity Governance & Lifecycle 7.2.0 P03.
 

Attachments

    Outcomes