RSA Identity Governance and Lifecycle Account Data Collector (ADC) and Entitlement Data Collectors (EDC) are slow in step Calculate Role Metrics of the Indirect Relationship Processing task
4 years ago
Originally Published: 2017-08-11
Article Number
000045608
Applies To
RSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0.1, 7.0.2

 
Issue
RSA Identity Governance and Lifecycle Account Data Collector (ADC) and Entitlement Data Collectors (EDC) are slow in step Calculate Role Metrics of  the Indirect Relationship Processing task

An Oracle Automatic Workload Repository (AWR) report shows the following two queries as consuming most of the time.  
INSERT INTO GTT_ROLECONSTRAINT_USERS (ID) SELECT ID FROM T_MASTER_ENTERPRISE_USERS USERS WHERE DELETION_DATE IS NULL AND ...
  
BEGIN Common_Exploder.Process(:1 , :2 ); END;


 
Cause
This issue may occur if the database statistics package has not completed an initial run on table T_AV_USER_ACCOUNT_MAPPINGS.   It is more likely to occur immediately after a new installation. 
Resolution
Generate an Aveksa System Report (ASR) from the Diagnostics tab under the Admin System menu. 

In the Database Performance Statistics section, inspect the column for Last Analyzed Date for the table T_AV_USER_ACCOUNT_MAPPINGS.  If the date is absent or old, then force statistics to be collected on this table.

To force database statistics on this table, in SQL*Plus or using Oracle SQL Developer, run the following SQL command. 
  
EXEC DATABASE_STATISTICS.GATHER_TABLE('T_AV_USER_ACCOUNT_MAPPINGS');
Notes
Note that this issue is more likely to occur immediately after a new installation and will automatically resolve itself after a period of time when database statistics are collected automatically for this table.   RSA Identity Governance and Lifecycle uses a complex algorithm to determine when to run database statistics on specific tables.  It may take a few days or weeks after a new installation before the algorithm targets all of the tables for database statistics.  

Related Articles

Trending Articles

Don't see what you're looking for?