Deleting user results in ORA-20170: Can not delete  " User references exist"


Article ID: 220821


Updated On:


CA Automic Applications Manager (AM)


When attempting to delete a user the following error message is disabled.

java.sql.SQLException: ORA-20170: Can not delete  " User <username>. 1 references exist " 
ORA-06512: at "THK935.SO_USER_TABLE_DEL", line 54
ORA-04088: error during execution of trigger 'THK935.SO_USER_TABLE_DEL'
ORA-06512: at "THK935.AWAPI2", line 2204
ORA-06512: at "THK935.AWAPI", line 971
ORA-06512: at "THK935.AW_WEB_API", line 1626
ORA-06512: at "THK935.AW_WEB_API", line 1349
ORA-06512: at line 1


The message "cannot delete user references exist" indicates the user object is assigned to other Applications Manager objects. It is required to remove these references before the user can be deleted.


To verify the referenced objects from client gui navigate to Objects Admin>Administration>Users>highlight the user you wish to delete>Usage>this will show you the list of referenced objects that will need to be removed/reassigned prior to deleting the user.