ucybdbun: U0037107 Error during reorganization of table 'AH'
Issue/Introduction:
Error Message :
'ORA-02292: integrity constraint (UC4RN.FK_APD_AH) violated - child record found'.
DB.Unload finished with error during reorg:
20160801/112332.616 - U0037032 0000137 - 20160801 ERROR ;OH,MELD,AH,RH,XAO
20160801/112332.631 - U0037111 Starting reorganization for client: 'ALL'
20160801/112334.694 - U0003524 UCUDB: ===> Time critical DB call! OPC: 'EXEC' time: '1:626.123.284'
20160801/112334.694 - U0003525 UCUDB: ===> 'delete from AH where AH_idnr in (select DIVDB_PK from DIVDB)'
20160801/112334.694 - U0037107 Error during reorganization of table 'AH'. Program exits with error.
20160801/112334.694 - U0037022 ABORTING due to error.
20160801/112332.631 - U0037111 Starting reorganization for client: 'ALL'
20160801/112334.694 - U0003524 UCUDB: ===> Time critical DB call! OPC: 'EXEC' time: '1:626.123.284'
20160801/112334.694 - U0003525 UCUDB: ===> 'delete from AH where AH_idnr in (select DIVDB_PK from DIVDB)'
20160801/112334.694 - U0037107 Error during reorganization of table 'AH'. Program exits with error.
20160801/112334.694 - U0037022 ABORTING due to error.
Check the constraint:
select *
from dba_constraints
where CONSTRAINT_NAME = 'FK_APD_AH'
from dba_constraints
where CONSTRAINT_NAME = 'FK_APD_AH'
and owner = ’UC4RN’ -- "UC4RN" needs to be substituted with the actual schema name
;
<Please see attached file for image>
Proposal for solution
1. Check which data will be deleted
select *
from APD where APD_AH_Idnr in (select AH_idnr
from AH
where AH_DeleteFlag = 1
)
;
from APD where APD_AH_Idnr in (select AH_idnr
from AH
where AH_DeleteFlag = 1
)
;
2. Delete record:
delete from APD where APD_AH_Idnr in (select AH_idnr
from AH
where AH_DeleteFlag = 1
)
;
from AH
where AH_DeleteFlag = 1
)
;
commit;
Cause:
Cause type:
Other
Root Cause: refer to description
Environment:
Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:
Resolution:
This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.
Fix Status: No Fix
Additional Information:
Workaround :
N/A