U00003592 UCUDB - Status: '' Native error: '1' Msg: 'ORA-00001: unique constraint (UC4V8PRD.UK_OH_NAME) violated'

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Running the DB Unload utility results in error:
20180516/083222.223 - U00037147 Could not update Table OH.
20180516/083222.223 - U00037124 Folders in 'No Folder' could not be restored.

or

U00003592 UCUDB - Status: '' Native error: '1' Msg: 'ORA-00001: unique constraint (UC4V8PRD.UK_OH_NAME) violated'

Environment

Release:
Component: AAUTEN

Resolution

Set database=4 trace on the DB Unload utility. Search for ORA-00001. Above that line you will find the SQL that caused the DB Unload to fail. For example:

update OH set OH_Name = ? where OH_Idnr = ?

Since we enabled the trace we can see the value for OH_Name and OH_Idnr. For example:
U00009909 TRACE: (BINDPAR:  OH_Name           )             00007FFA9AA14B4F 000014
                                00000000  31303030 3030316B 5C5F554E 4958      >1000001k\_UNIX<
U00009909 TRACE: (BINDPAR:  OH_Idnr           )             00007FFA9AA14C18 000004
                                00000000  48341200                             >H4..<
                                        >1193032<

The update would look like this (based on the information above):

update OH set OH_Name = '1000001k\_UNIX' where OH_Idnr = 1193032

The folder name '_UNIX' is preventing the DB Unload from finishing. To resolve this open the User Interface and locate the '_UNIX' folder and rename (do not delete). It is possible that multiple folders will have this problem. In that case repeat the steps above until the DB Unload runs without error.