Clarity upgrade Fails PRJ_OBS_ASSOCIATIONS_PK

Products

• Clarity PPM On Premise

Issue/Introduction

The following error is seen during upgrade:

 

(ExecTask) com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (NIKU.PRJ_OBS_ASSOCIATIONS_PK) violated

 

 

 

Environment

Release : 15.X

Component : CA PPM APPLICATION

Cause

There is a duplicate entry in the PRJ_OBS_ASSOCIATIONS database table

Resolution

We identified the duplicate entry in the database table by finding the rows that had a matching "UNIT_ID", "TABLE_NAME" and "RECORD_ID", all three fields have to match another record. We than manually removed the item that was invalid.

In this specific use case, there were matching entries that the three fields all matched, but one had a TABLE_NAME all lower case, and one was upper case.