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.
Check the constraint:
select * from dba_constraints where CONSTRAINT_NAME = 'FK_APD_AH'
and owner = ’UC4RN’ -- "UC4RN" needs to be substituted with the actual schema name
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 ) ;
2. Delete record:
delete from APD where APD_AH_Idnr in (select AH_idnr from AH where AH_DeleteFlag = 1 ) ;
Cause type: Other Root Cause: refer to description