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
ORA-22285 error running Data Archiving of RSA Identity Governance & Lifecycle Number of Views Data Archiving fails with 'Error saving data archival job for the date range' in RSA Identity Governance & Lifecycle Number of Views Creating Multiple Requests and Archiving Requests Number of Views Applying role changes in RSA Identity Governance & Lifecycle takes longer to complete when Generate Indirect Entitlements … Number of Views ASR fails to generate with an 'ORA-31011: XML parsing failed ORA-06512: at "AVUSER.SYSTEM_REPORT", line 245' error in RSA … Number of Views
Trending Articles
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Release Notes for RSA Authentication Manager 8.8 Deploying RSA Authenticator 6.2.2 for Windows Using DISM Downloading RSA Authentication Manager license files or RSA Software token seed records
Don't see what you're looking for?
