Reporter error "unique constraint UNI_EVT_LOG_PK or UNI_EVT_REPORTS_PK violation"

Products

• CA Automic Dollar Universe

Issue/Introduction

You have upgraded the DU reporter to 6.10.103 and applied the oracle\alter_db_oracle_v61051_to_v610103 as per Release Notes - Hotfix 6.10.103, but you get the below errors. Why are these thrown?

ORA-00001: unique constraint (REPORTER_DB_SCHEMA.UNI_EVT_LOG_PK) violated
ORA-00001: unique constraint (REPORTER_DB_SCHEMA.UNI_EVT_REPORTS_PK) violated

 

 

Environment

Release : 6.10.102 or superior

Component: Dollar Universe Reporter

Cause

There seems to be some data corruption resulting in violation of unique key constraint and hence will require truncation of below tables .

• UNI_EVT_LOG
• UNI_EVT_EXTRACTIONS
• UNI_EVT_REPORTS

Resolution

 Follow step below to resolve issue.

1. Stop the reporter services and ask your DBA to take backup of Reporter DB
2. Once the backup of DB is made, go ahead and truncate below tables
   • UNI_EVT_LOG
   • UNI_EVT_EXTRACTIONS
   • UNI_EVT_REPORTS
3. Start the reporter service to check if it start up fine
4. Perform a new extraction

Additional Information

Reporter Oracle 6.10.103 or superior fails with could not extract ResultSet ORA-02289: sequence does not exist