on Jun 12, 2019Article Content
| 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 foundORA-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 foundORA-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 foundORA-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 foundORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 1101ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 85ORA-06512: at line 1 Examples of foreign key constraints violated are:
|
| Cause | This is a known defect where deletes were not using proper columns for data removal during the data pruning process. |
| Resolution | Fixed in RSA Identity Governance & Lifecycle 7.0.2 P14, 7.1.0 P08, and 7.1.1 P02. |