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

Document created by RSA Customer Support Employee on Jun 12, 2019Last modified by RSA Customer Support Employee on Jul 25, 2019
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000037618
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.2, 7.1.0, 7.1.1
 
IssueData 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.

CauseThis 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.

 
ResolutionThis 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

Attachments

    Outcomes