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

Document ID : KB000089327
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
U0037134 CAUTION: The object 'XXX' might have been moved to the recycle bin by accident. Processing
Resolution:
Detailed Description and Symptoms

U0037134 ACHTUNG: Das Objekt 'XXX' könnte unbeabsichtigt in den Papierkorb gelangt sein. Verarbeitung wird beendet. Bitte kontaktieren Sie den Automic Support.
U0037134 CAUTION: The object 'XXX' might have been moved to the recycle bin by accident. Processing will be abortet. Please Contact the Automic Support.

 

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


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