Unable to Remove User Role

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

When trying to remove a user group, in this example PROGRAMMER, the client errors due to references. A review of the user group shows no references when looking at the assignments under User group for PROGRAMMER.

Error Output:

java.sql.SQLException: ORA-20089: Cannot delete Role PROGRAMMER , total of 5 users  as references exist 

ORA-06512: at "SQLOPER.SO_ROLE_MASTER_DEL_STMT", line 35
ORA-04088: error during execution of trigger 'SQLOPER.SO_ROLE_MASTER_DEL_STMT'
ORA-06512: at "SQLOPER.AWAPI", line 798
ORA-06512: at "SQLOPER.AW_WEB_API", line 1657
ORA-06512: at "SQLOPER.AW_WEB_API", line 1349
ORA-06512: at line 1

 

 

Environment

Release : 9.x

Component : APPLICATIONS MANAGER

Cause

This can be seen when orphaned records in the SO_ROLE_DETAIL for the user group referenced by SO_ROLE_SEQ.

This is most likely caused by manual deletes to the database

Resolution

Confirm no references can be found in the client GUI by navigating to Object Admin > Administration > User Groups > Highlight “PROGRAMMER” > Usage. Confirm no details are shown in the reference tab.

If no references can be seen in the client GUI, the following sql can be ran to check for database references.

SQL> select srm.so_role_name, srm.so_role_seq, srd.so_role_object from so_role_master srm, so_role_detail srd where so_role_name = '<usergroup>' and srm.so_role_seq = srd.so_role_seq;

*Replace <usergroup> with the specific user group name.

This sql will return the SO_ROLE_SEQ along with the referenced object seq. In the example the sql returned the following PROGRAMER.

SO_ROLE_NAME SO_ROLE_SEQ  SO_ROLE_OBJECT

PROGRAMMER  1928       2

Please contact support with the information above for further details.