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

book

Article ID: 220821

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

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

Cause

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.

Resolution

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.