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

Document ID : KB000089014
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:

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 aborted. Please Contact the Automic Support.
 

Cause

This error occurs when an object gets deleted but lacks the deleteflags '5' or '1' 
 
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
 
To find out which objects are causing the error
 
*)Reproduce the error with a database=4 trace 
*)Note the oh_idnr and oh_name
 

 


 

Resolution

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

Oracle:
​update <enter DB schema here>.oh set oh_deleteflag=0 where oh_deleteflag in (5,1) and oh_idnr=<type here the oh_idnr >

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

 
2. 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 (0,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 (0,1,5)