search cancel

Recieving unique constraint violation when trying to change master or agent name.

book

Article ID: 89236

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Recieving unique constraint violation when trying to change master or agent name.

Environment

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

Resolution

Symptoms

When running awinstall or via sql you try to change the name of the Master or agent you receive the following error:



Cause

ORA-00001 is common when: a program tries to insert a "duplicate" row in a table," and that, "when a unique constraint is violated the row is not added to the table."


Resolution

Please log into sqlplus as the Oracle Applications Manager user and run the following sql:

select * from so_operators;

Please just make sure your not trying to update any value to that which is all ready there(ie renaming the master to the name of an existing agent).