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
There is a duplicate entry in the PRJ_OBS_ASSOCIATIONS database table
Release : 15.X
Component : CA PPM APPLICATION
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.