search cancel

Logins cannot be deleted because they reference modules which

book

Article ID: 88479

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Logins cannot be deleted because they reference modules which

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Symptoms

When trying to delete old logins that show no references in Usage window, you get the following error message:

'AwE-5001

Database Query Error

ORA-20076: Cannot delete db login for Master as references exist'

 


 

Cause

Although there is no reference shown in the Usage window, there are still references in place. They can not be seen under the current user but should be visible when logged in as sqloper.

 


 

Resolution

You can try to log in with the SQLOPER user and delete the references shown in the Usage window, or delete it in sqlplus. Please contact Automic support for the statements.