DB Unload error ORA-02292 integrity constraint UC4.FK.... violated - child record found

Document ID : KB000123224
Last Modified Date : 20/12/2018
Show Technical Document Details
Issue:

When performing the AE DB Unload Utility following Oracle error occurs:
U00003592 UCUDB - Status: '' NativeError: '2292' Msg: 'ORA-02292: integrity constraint (UC4.FK_OFS_OH_F) violated - child record found'
U00003594 UCUDB-Ret: '2' Opcode: 'EXEC' SQL-Stmnt: 'delete from OH where OH_idnr in (select DIVDB_PK from DIVDB)'

This error appears for each execution of AE DB Unload.

The issue occurred when DB Unload was started in batch mode with the following parameters: ucybdbun -breorg -c1000

Cause:
There was an error in the business logic. First, the records in the detail table must be deleted but there where condition is different to the filter for the master table. The problem has been fixed where the DB Unload utility cannot remove a deleted folder because there are existing records in a child table.
Resolution:

Solution:

Update to a fix version listed below or a newer version if available.

 

Fix version:

Component(s): DB Unload Utility, Utility

Automation.Engine v12.1.3 - Available

Automation.Engine v12.2.0 - Available


Updating the Utilities is sufficient to fix the problem.