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

Document ID : KB000089236
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Recieving unique constraint violation when trying to change master or agent name.
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).