Data purging fails with ORA-02292: integrity constraint (AVUSER.FK_xxxxxx violated - child record found) in RSA Identity Governance & Lifecycle

[#1]

Article Number

000037618

Applies To

RSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.2, 7.1.0, 7.1.1
 

Issue

Data purging fails with various foreign key constraint errors as seen in the aveksaServer.log, shown below:
 

03/29/2019 20:50:14.916 ERROR (Exec Task Consumer#2 - Main) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=414469 RunID=211664 Source=1 Type=DataPurging Status=InProgress] com.aveksa.server.xfw.ExecutionException: com.aveksa.server.db.PersistenceException: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (AVUSER.FK_T_PCS_EXN_HY_PC_ID_T_PCS_ID) violated - child record found ORA-06512:

at "AVUSER.DATA_PRUNING_PKG", line 995 ORA-06512:

at "AVUSER.DATA_PRUNING_PKG", line 85 ORA-06512:

at line 1

04/03/2019 20:03:33.196 ERROR (Exec Task Consumer#0 - Main) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=415287 RunID=212296 Source=1 Type=DataPurging Status=InProgress]
04/03/2019 20:03:33.196 ERROR (Exec Task Consumer#0 - Main) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=415287 RunID=212296 Source=1 Type=DataPurging Status=InProgress] com.aveksa.server.xfw.ExecutionException: com.aveksa.server.db.PersistenceException: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (AVUSER.FK_T_IDCAV_T_IDCA_ID) violated - child record found ORA-06512:

at "AVUSER.DATA_PRUNING_PKG", line 1109ORA-06512:
at "AVUSER.DATA_PRUNING_PKG", line 85ORA-06512:
at line 1
at com.aveksa.server.xfw.DataPruningTaskExecutor.executeTask(DataPruningTaskExecutor.java:54)
at com.aveksa.server.xfw.TaskExecutor.execute(TaskExecutor.java:99)
at com.aveksa.server.xfw.ExecutionTaskQueue$Worker.run(ExecutionTaskQueue.java:116)
at java.lang.Thread.run(Thread.java:748)Caused by: com.aveksa.server.db.PersistenceException: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (AVUSER.FK_T_IDCAV_T_IDCA_ID) violated - child record found ORA-06512:
at "AVUSER.DATA_PRUNING_PKG", line 1109ORA-06512:
at "AVUSER.DATA_PRUNING_PKG", line 85ORA-06512:
at line 1 04/09/2019 18:03:31.864 ERROR (Exec Task Consumer#2 - Main) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=420961 RunID=215203 Source=1 Type=DataPurging Status=InProgress] 04/09/2019 18:03:31.864 ERROR (Exec Task Consumer#2 - Main) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=420961 RunID=215203 Source=1 Type=DataPurging Status=InProgress] com.aveksa.server.xfw.ExecutionException: com.aveksa.server.db.PersistenceException: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (AVUSER.FK_T_IDCAH_IDCAID_T_IDCA_ID) violated - child record found ORA-06512:
at "AVUSER.DATA_PRUNING_PKG", line 1101ORA-06512:
at "AVUSER.DATA_PRUNING_PKG", line 85ORA-06512:
at line 1
at com.aveksa.server.xfw.DataPruningTaskExecutor.executeTask(DataPruningTaskExecutor.java:54)
at com.aveksa.server.xfw.TaskExecutor.execute(TaskExecutor.java:99)
at com.aveksa.server.xfw.ExecutionTaskQueue$Worker.run(ExecutionTaskQueue.java:116)
at java.lang.Thread.run(Thread.java:748)

Caused by: com.aveksa.server.db.PersistenceException: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (AVUSER.FK_T_IDCAH_IDCAID_T_IDCA_ID) violated - child record found ORA-06512:

at "AVUSER.DATA_PRUNING_PKG", line 1101 ORA-06512:

at "AVUSER.DATA_PRUNING_PKG", line 85 ORA-06512:

at line 1

Examples of foreign key constraints violated are:

• AVUSER.FK_T_PCS_EXN_HY_PC_ID_T_PCS_ID
• AVUSER.FK_T_IDCAV_T_IDCA_ID
• AVUSER.FK_T_IDCAH_IDCAID_T_IDCA_ID

If your foreign key constraint error is AVUSER.FK_AFX_REQUEST_CHANGE_ITEM_ID, please see article 000037556 Data Purging fails with ORA-02292: integrity constraint (AVUSER.FK_AFX_REQUEST_CHANGE_ITEM_ID) violated - child record found in RSA Identity Governance & Lifecycle. The symptom is the same, but the problem cause is different and cleanup may be needed.
 

Please refer to 000030327 - Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the aveksaServer.log file for your specific deployment.

Cause

This is a known defect reported in engineering ticket ACM-97194 where deletes do not use the proper columns for data removal during the data pruning process.

 

Resolution

This issue is resolved in the following RSA Identity Governance & Lifecycle patches:

• RSA Identity Governance & Lifecycle 7.0.2 P14
• RSA Identity Governance & Lifecycle 7.1.0 P08
• RSA Identity Governance & Lifecycle 7.1.1 P02