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

book

Article ID: 206171

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation CA Automic Operations Manager CA Automic Oracle

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

Cause

Possible corrupt folder structure within the Automic Automation Engine database.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

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 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.