Data Purging after Data Archiving run may take longer than expected in RSA Identity Governance & Lifecycle
Originally Published: 2021-04-12
Article Number
Applies To
RSA Version/Condition: 7.2.0, 7.2.1
Issue
Data Purging after a Data Archiving run may take longer than expected.
An Oracle Automatic Workload Repository (AWR) report at the time of Data Purging may show the following SQL query as running long.
b0v56u167hqwd merge into (select * from WP_USER_DATA where archive_id is null) child using (select * from WP_PROCI where archive_id = :in_archive_id) parent on (parent.proci_id = child.proci_id and parent.proci_db = child.proci_db and rownum <= :batchSize) when matched then update set child.archive_id = :in_archive_id
Cause
Resolution
The Data Purging of WorkPoint data related to Data Archive has been improved in the following versions:
- RSA Identity Governance & Lifecycle 7.2.0 P09
- RSA Identity Governance & Lifecycle 7.2.1 P05
- RSA Identity Governance & Lifecycle 7.5.0 P01
Related Articles
Editing a cloned AFX connector may fail with error 'Duplicate (internal) name for Connector, name: connector-raw-name' in … Number of Views Approval items that are rejected by email and have multiple concurrent approvers may potentially be provisioned in RSA Ide… Number of Views Data purging fails with "ORA-20001: No jobs were found to delete" in RSA Identity Governance & Lifecycle 7.1.1 Number of Views Application is in a questionable state and collections may get stuck after an unexpected database failure in RSA Identity … Number of Views Data Purging stuck "in Progress" in "Step 7/12 Purging Workflow Custom Tasks" in RSA Identity 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?
