search cancel

U0037134 CAUTION: The object 'XXX' might have been moved to the recycle bin by accident. Processing

book

Article ID: 89327

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

The following error may occur in the log file of the DB Unload Utility (ucybdbun) during the reorganization:

In German:
U0037134 ACHTUNG: Das Objekt 'XXX' könnte unbeabsichtigt in den Papierkorb gelangt sein. Verarbeitung wird beendet. Bitte kontaktieren Sie den Automic Support.

In English:
U0037134 CAUTION: The object 'XXX' might have been moved to the recycle bin by accident. Processing will be abortet. Please Contact the Automic Support.

Cause

When an object in the database has an oh_deleteflag of '5' or '1', this means the object has been marked for deletion from the system (ex.: moved to the Recycle Bin or marked for deletion during the Reorg).

Usually, objects marked for deletion are stored in the Automic Recycle Bin with an extended name (the name is extended with the "system-internal number" for the object). This object (U0037134 CAUTION: The object 'XXX'…) does not have an extended name with a "system-internal number".

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Investigation

Reproduce the error with a database=4 trace and find out which object the problem has.

Note the oh_idnr and oh_name.

Solution

*) SQL statement to put the object to the <No Folder> and can then be moved to another folder location:


update oh set oh_deleteflag=0 where oh_deleteflag in (5,1) and oh_idnr=<type here the oh_idnr >


*) SQL statement to add the oh_idnr to the oh_name, so the unload process will successfully finish:


Oracle:
update oh set oh_name=concat(concat( concat(OH_Name , '_') , ( SUBSTR( '0000000000', 1,(10-length(OH_IDNR) ) ) )) , TO_CHAR(OH_IDNR)) where oh_idnr=<type here the oh_idnr >, oh_deleteflag in (1,5);
commit;


MSSQL:

Update oh set oh_name=(OH_Name + '_' + ( SUBSTRING( '0000000000', 1,(10-len(OH_Idnr) ) ) ) + convert(varchar(10),OH_IDNR)) where oh_idnr=<type here the oh_idnr > and oh_deleteflag in (1,5)