Purging runs have been failing with ORA-02292: integrity constraint (AVUSER.FK_T_TEMP_PWD_CHG_REQ_DET) violated - child record found error in RSA Governance & Lifecycle
Originally Published: 2026-03-31
Article Number
Applies To
This is an issue in the following versions:
- RSA Governance & Lifecycle 8.0.0 P07, 8.0.0 P08, 8.0.0 P09 and 8.0.0 P10
Issue
Scheduled purging runs fail with the error below in the aveksaServer.log. They stop at Step 9 and Purging Archives - Substep 2/2: Backup of Archive tables. Both statuses are In Progress.
01/24/2026 03:03:13.348 ERROR (Exec Task Consumer#3 - Main) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=967306 RunID=917110 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.DATA_PRUNING_PKG", line 395
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1398
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1500
ORA-02292: integrity constraint (AVUSER.FK_T_TEMP_PWD_CHG_REQ_DET) violated - child record found
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1473
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1353
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1353
ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 392
ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 111
ORA-06512: at line 1
at com.aveksa.server.xfw.DataPruningTaskExecutor.executeTask(DataPruningTaskExecutor.java:61) ~[server.jar:?]
at com.aveksa.server.xfw.TaskExecutor.execute(TaskExecutor.java:101) ~[server.jar:?]
at com.aveksa.server.xfw.ExecutionTaskQueue$Worker.run(ExecutionTaskQueue.java:137) ~[server.jar:?]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_442]
Caused by: com.aveksa.server.db.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 395
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1398
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1500
ORA-02292: integrity constraint (AVUSER.FK_T_TEMP_PWD_CHG_REQ_DET) violated - child record found
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1473
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1353
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1353
ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 392
ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 111
ORA-06512: at line 1
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1463) ~[server.jar:?]
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1395) ~[server.jar:?]
at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:196) ~[server.jar:?]
at com.aveksa.server.xfw.DataPruningTaskExecutor.executeTask(DataPruningTaskExecutor.java:56) ~[server.jar:?]
... 3 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 395
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1398
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1500
ORA-02292: integrity constraint (AVUSER.FK_T_TEMP_PWD_CHG_REQ_DET) violated - child record found
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1473
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1353
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1353
ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 392
ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 111
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442) ~[?:?]
at com.aveksa.server.db.persistence.work.PersistenceServiceBaseWork.executeCallableStatement(PersistenceServiceBaseWork.java:36) ~[server.jar:?]
at com.aveksa.server.db.persistence.work.StoredProcedureCallWork.execute(StoredProcedureCallWork.java:80) ~[server.jar:?]
at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37) ~[hibernate-core-5.3.36.Final.jar:5.3.36.Final]
at org.hibernate.internal.SessionImpl$1.accept(SessionImpl.java:2409) ~[hibernate-core-5.3.36.Final.jar:5.3.36.Final]
at org.hibernate.internal.SessionImpl$1.accept(SessionImpl.java:2406) ~[hibernate-core-5.3.36.Final.jar:5.3.36.Final]
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:306) ~[hibernate-core-5.3.36.Final.jar:5.3.36.Final]
at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2428) ~[hibernate-core-5.3.36.Final.jar:5.3.36.Final]
at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2413) ~[hibernate-core-5.3.36.Final.jar:5.3.36.Final]
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1441) ~[server.jar:?]
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1395) ~[server.jar:?]
at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:196) ~[server.jar:?]
at com.aveksa.server.xfw.DataPruningTaskExecutor.executeTask(DataPruningTaskExecutor.java:56) ~[server.jar:?]
... 3 more
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01722: invalid number
ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 395
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1398
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1500
ORA-02292: integrity constraint (AVUSER.FK_T_TEMP_PWD_CHG_REQ_DET) violated - child record found
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1473
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1353
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1353
ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 392
ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 111
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442) ~[?:?]
at com.aveksa.server.db.persistence.work.PersistenceServiceBaseWork.executeCallableStatement(PersistenceServiceBaseWork.java:36) ~[server.jar:?]
at com.aveksa.server.db.persistence.work.StoredProcedureCallWork.execute(StoredProcedureCallWork.java:80) ~[server.jar:?]
at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37) ~[hibernate-core-5.3.36.Final.jar:5.3.36.Final]
at org.hibernate.internal.SessionImpl$1.accept(SessionImpl.java:2409) ~[hibernate-core-5.3.36.Final.jar:5.3.36.Final]
at org.hibernate.internal.SessionImpl$1.accept(SessionImpl.java:2406) ~[hibernate-core-5.3.36.Final.jar:5.3.36.Final]
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:306) ~[hibernate-core-5.3.36.Final.jar:5.3.36.Final]
at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2428) ~[hibernate-core-5.3.36.Final.jar:5.3.36.Final]
at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2413) ~[hibernate-core-5.3.36.Final.jar:5.3.36.Final]
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1441) ~[server.jar:?]
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1395) ~[server.jar:?]
at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:196) ~[server.jar:?]
at com.aveksa.server.xfw.DataPruningTaskExecutor.executeTask(DataPruningTaskExecutor.java:56) ~[server.jar:?]
... 3 moreCause
A dependency record was found in the T_AV_TEMP_PASSWORD table while executing the Archive Purging process, which caused the problem.
Resolution
Upgrade to RSA Governance & Lifecycle 8.0.0 P11 or later
Workaround
Please contact RSA Technical Support for a workaround until 8.0.0 P011 is released.
Notes
To further diagnose the issue, and confirm similarity to this KB, run the following SQL query. Please replace <run id> with the Purging run's run ID.
SELECT * FROM t_av_job_stats WHERE av_run_id='<run id>';Expected output (match to this issue):
Output of "SELECT * FROM t_av_job_stats WHERE av_run_id='917110';"Related Articles
Account and Identity collection related jobs are failing in after a Role membership rule changes in RSA Governance & Lifec… Number of Views Data Purging after Data Archiving run may take longer than expected in RSA Identity Governance & Lifecycle Number of Views Understanding and managing log archival maintenance in RSA Authentication Manager 8.x Number of Views XudaInstanceOf failed to get xuda_cert_req object! result = 48 Number of Views Program Error: 'req-authorize.xuda: Line 518: [XrcNOTFOUND] unable to locate requested member or object. Unable to sign ce… Number of Views
Trending Articles
RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager Upgrade Process Artifacts to gather in RSA Identity Governance & Lifecycle Form approval node shows exception caught during script evaluation error in RSA Via Lifecycle and Governance RSA Release Notes for RSA Authentication Manager 8.8
Don't see what you're looking for?
