DB Unload is failing: U00037107 Error during reorganization of table 'OH'.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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)'

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

Possible corrupt folder structure within the Automic Automation Engine database.

Resolution

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 No rows found

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.