AWA: DB Load fails with 'U00021131 Access rights of object' errors

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When attempting to load a transport case, the DB Load fails with errors similar to:

U00021131 Access rights of object '<NAME>' type '<OBJECT>' refer to unknown object '<NAME>'.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

Object level permissions exist on the object that reference objects not present in the system.

In the Java UI, the authorizations could be seen by right-clicking an object and choosing Properties, then Authorizations.  In the ECC or AWI, the object Authorizations can be seen by opening an object in the Process Assembly perspective and then going to the General tab -> Object Authorizations. 

Resolution

The object Authorizations either need to be removed before unloading the transport case, or need to be ignored by running the transport case load again adding -MY to your DB Load parameters:

https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/21.0.3/Automic%20Automation%20Guides/Content/AWA/Admin/admin_StartParameters_Utilities.htm?Highlight=MAccess#link12

You can see if any other objects have authorizations on the object themselves by using a sql statement like the following:

select oh_client, oh_name, oh_idnr from oh where oh_idnr in (select oacl_oh_idnr from oacl)