DB Unload is failing with:
20210107/112734.869 - U00037107 Error during reorganization of table 'OH'. Program exits with error. 20210107/112734.877 - U00037022 ABORTING due to error. Restart the program when the error cause has been removed. 20210107/112734.877 - U00037055 Error occurred when reorganizing database. Please check your Log/Trace file for more details.
The trace file shows the following:
20210107/112734.869 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 1726bb0 DB-HDBC: 17a0b90 20210107/112734.869 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR' 20210107/112734.869 - U00003592 UCUDB - Status: '' Native error: '2292' Msg: 'ORA-02292: integrity constraint (UC4_MP.FK_OFS_OH_F) violated - child record found' 20210107/112734.869 - U00003594 UCUDB Ret: '2' opcode: 'EXEC' SQL Stmnt: 'delete from OH where OH_idnr in (select DIVDB_PK from DIVDB)'
Release : 12.3
Component : AUTOMATION ENGINE
Possible corrupt folder structure within the Automic Automation Engine database.
Run the following SQL statement:
select oh_idnr, oh_client, oh_name, oh_otype from oh where (OH_DeleteFlag = 1 or OH_Deleteflag = 5) and oh_idnr in (select ofs_oh_idnr_f from ofs);
This returns the following:
This object can now be deleted through the AWI. If there are multiple objects or a SQL delete statement is needed, please contact Broadcom Support for further instructions.