Data Purging process (as part of Data Archiving) fails with ORA-01722 in RSA Identity Governance & Lifecycle
Originally Published: 2021-02-25
Last Modified: 2022-06-20
Article Number
Applies To
RSA Version/Condition: 7.2.1, 7.2.0, 7.1.1
Issue
10/31/2020 21:15:39.830 ERROR (Exec Task Consumer#0 - Main) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=1294636 RunID=503884 Source=1 Type=DataPurging Status=InProgress] com.aveksa.server.xfw.ExecutionException: com.aveksa.server.db.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1176 ORA-02292: integrity constraint (AVUSER.FK_T_TEMP_PWD_CHG_REQ_DET) violated - child record found ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 200 ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 99 ORA-06512: at line 1
Cause
This is a known issue in the following versions:
- RSA Identity Governance & Lifecycle 7.1.1
- RSA Identity Governance & Lifecycle 7.2.0
- RSA Identity Governance & Lifecycle 7.2.1
This is caused by archiving canceled and rejected Change Requests with certain legacy data in them.
Resolution
This issue is resolved in the following versions:
- RSA Identity Governance & Lifecycle 7.1.1 P12
- RSA Identity Governance & Lifecycle 7.2.0 P07
- RSA Identity Governance & Lifecycle 7.2.1 P03
These versions contain an updated data migration package ACM-108570.sql that automatically removes references to legacy data in Change Requests so that Data Purging (as part of Data Archiving) can complete.
Workaround
Notes
Related Articles
Embedded links in the body of Workflow Nodes that are defined with Job Level Variables as part of the link are not saved i… Number of Views Generic REST Collector does not replace Query Parameters passed as part of the POST Request Body in RSA Identity Governanc… Number of Views What about Profile Timeline in RSA Web Threat Detection, CProfileUpdater and Cassandra as part of version 6.1 upgrade? Number of Views Data Purging after Data Archiving run may take longer than expected in RSA Identity Governance & Lifecycle Number of Views AFX Requests fails to process as the Usage Store Manager is full in RSA Governance & Lifecycle Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Manual synchronization introduced in RSA Authentication Manager 8.2 Service Pack 1 patch 6 Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to verify NTP server synchronization is not working in RSA Authentication Manager 8.x RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?
