Data purging fails with ORA-02292: integrity constraint (AVUSER.FK_xxxxxx violated - child record found) in RSA Identity Governance & Lifecycle
3 years ago
Originally Published: 2019-06-12
Article Number
000044081
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
Attachments
If the attachment does not open when clicked, please refresh the page and try again. You must be logged into view the file(s).

    Related Articles

    Trending Articles

    Don't see what you're looking for?