ORA-00001: unique constraint violated error on PK_USERS_LOG

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

After a Job finishes, the below RmiServer popup error is seen:

ErrorMsg: AwE-5001 Database Query Error
Details: ORA-00001: unique constraint (AM.PK_USERS_LOG) violated
ORA-06512: at "APPWORX.APPPRC", line 287
ORA-06512: at "APPWORX.APPPRC", line 843
ORA-06512: at line 1

Environment

Applications Manager 9.4 and above

Cause

Primary Key in PK_USERS_LOG was removed since Applications Manager version 7.x or 8.x, but may still exist in the current AM environment and data originated from version 7x or below.

Resolution

Check to see if the Primary Key in the SO_USERS_LOG table exist:

SELECT constraint_name
FROM   user_constraints
WHERE  constraint_type = 'P'
AND    table_name = UPPER('SO_USERS_LOG');

This should return

CONSTRAINT_NAME
--------------------------------------------------------------------------------
PK_USERS_LOG

If the above value is returned, the primary key can be dropped by running the below sql:

ALTER TABLE SO_USERS_LOG DROP PRIMARY KEY;
commit;