ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

No role access error when importing notifications


Article ID: 211840


Updated On:


CA Automic Applications Manager (AM)


A Notification will generally include 3 Objects that are tied together. This includes:

1) A Notification Object 
2) A User Group Object (Notifiation is assigned to this User Group)
3) A Message Template Object (Message Template is assigned to Notification and also assigned to this User Group)

When importing a Notification, a User Group (ie USER_GROUP_TEST), and a Message Template (ie TEMPLATE1-TEST) that does NOT exist, the below error occurs

ORA-20025: No role access to " role USER_GROUP_TEST in get_role_seq_aw when
add_obj_roles "
ORA-06512: at "APPMGR.AWAPI2", line 487
ORA-06512: at "APPMGR.AWAPI2", line 1000

If User Group USER_GROUP_TEST is created manually and then Import re-attempt is made, the following error is seen.

ERROR at line 1:
ORA-20024: No such (get_object_seq_aw)Message Template as "TEMPLATE1-TEST"
rtype=m edit=N my_dba=Y my useq=1*-5-7-9-10
ORA-06512: at "APPMGR.AWAPI2", line 487

If an empty message template TEMPLATE1-TEST is created manually, then Import re-attempt is made, the IMPORT is successful. 


The import process imports objects types in the wrong order.


Release : 9.3



This is fixed in Applications Manager 9.3.5.