AE DB Unload failed with an error message U00037134

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The database reorganization, as well as the unload, fails with the following error. 
 

U00037134 CAUTION: The object 'AE10DEV#WP001' might have been moved to the Recycle Bin by accident. Processing will be aborted. Please contact Automic Support.
U00037134 CAUTION: The object 'AE10DEV#CP002' might have been moved to the Recycle Bin by accident. Processing will be aborted. Please contact Automic Support.
U00037134 CAUTION: The object 'AE10DEV#CP001' might have been moved to the Recycle Bin by accident. Processing will be aborted. Please contact Automic Support.
U00037134 CAUTION: The object 'AE10DEV#WP002' might have been moved to the Recycle Bin by accident. Processing will be aborted. Please contact Automic Support.
U00037134 CAUTION: The object 'AE10DEV#WP003' might have been moved to the Recycle Bin by accident. Processing will be aborted. Please contact Automic Support.
U00037134 CAUTION: The object 'AE10DEV#CP004' might have been moved to the Recycle Bin by accident. Processing will be aborted. Please contact Automic Support.
U00037134 CAUTION: The object 'AE10DEV#CP003' might have been moved to the Recycle Bin by accident. Processing will be aborted. Please contact Automic Support.
U00037134 CAUTION: The object 'AE10DEV#WP004' might have been moved to the Recycle Bin by accident. Processing will be aborted. Please contact Automic Support.
.....
...
U00037022 ABORTING due to error. 
Restart the program when the error cause has been removed.
U00037055 Error occurred when reorganizing database. 
Please check your Log/Trace file for more details.

Environment

CA Automic Workload Automation version supported environments

Cause

The problem seemed to happen after the upgrade due to SERV objects left behind in the recycle bin.

Resolution

• Verify if the same object(s) listed in the Process Assembly > Recycle bin.
• Right click on the object(s) that are in the error and "Restore" to reattempt delete.

After the restore and successful deletion, the unload/reorganisation should complete successfully.

• In case of the following error, during the restore: 

"Unable to restore object 'XXXXXX#XX'. This object has probably been deleted manually. Please contact Automic Support"

 

• Run the SQL statements on the Automic database: 

The following query lists the problematic serv objects which are in the error (oh_name string resolves the problematic object name).

select oh_name, oh_otype, oh_deleteflag from oh where (OH_deleteflag = 5 or OH_deleteflag = 1) and oh_name like 'AE10DEV#%';

To remove the listed objects from the Recycle Bin:

update oh set oh_deleteflag =0 where (OH_deleteflag = 5 or OH_deleteflag = 1) and oh_name like 'AE10DEV#%';
commit;

The database reorganization should successfully complete afterwards.

Additional Information

AE DB Unload (ucybdbun)
AE DB Reorg