RSA Identity Governance and Lifecycle IDC Unification is slow in "Step 8/10: Post-Processing: Populate Role Metrics" after upgrading to 7.0.1
Originally Published: 2017-01-17
Article Number
Applies To
RSA Version/Condition: 7.0.1
Issue
If you select Admin > Monitoring and view the Identity Data Unification task details, the processing times for Step 8/10: Post-Processing: Populate Role Metrics are longer than normal.
The Oracle Automatic Workload Repository (AWR) report shows long processing times for the query "BEGIN UNFC_Processor.UnifyUsers(:1 , :2 ); END;"
Rationale
Top level calls to execute the PL/SQL statement with SQL_ID
"df0mrjg1ptucs" are responsible for 100% of the database time spent on
the DELETE statement with SQL_ID "8h5g9538kqd9k".
Related Object
SQL statement with SQL_ID df0mrjg1ptucs.
BEGIN UNFC_Processor.UnifyUsers(:1 ,:2 ); END;Cause
Resolution
Related Articles
"Error - could not execute query" shows instead of the role name when listing roles in RSA Identity Governance & Lifecycle Number of Views Identity Data Unification longer in Step 8/11 Populate Role Metrics in RSA Governance & Lifecycle Number of Views Unification hangs in Step 9/11 Post-Processing: Purge Old Identity Data in RSA Identity Governance & Lifecycle Number of Views ACM-100162 || PV_USER_ALL_ACCESS view does not include custom attributes post 7.1.1 installation Number of Views Indirect Relationship Processing slower in Step 11/12 Calculate Role Metrics in RSA Governance & Lifecycle Number of Views
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Mandatory Certificate Upgrade Required by 6th October 2025 for RSA MFA Agent for PAM, RSA MFA Agent for Apache, and Third … RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
