Article 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 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:
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:
|