E-COMP: Upgrade Compare for Fields Fails with Unique Constraint on SYSADM.PS_PSPROJECTWORK (Doc ID 654387.1)

Last updated on APRIL 04, 2025

Applies to:

Goal

A Compare Report on Fields objects fails with error:


Fields Application Upgrade Compare started: 2007-04-10-09.36.41 (62,6)
System Error : SQL error. Stmt #: 3692 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSPROJECTWORK) violated (62,16)


System Error : INSERT INTO PSPROJECTWORK (PROJECTNAME, DBINDICATOR, OBJECTVALUE1, OBJECTVALUE2, OBJECTVALUE3, OBJECTVALUE4) SELECT PROJECTNAME, 2, OBJEC (62,16)
System Error : TVALUE1, OBJECTVALUE2, OBJECTVALUE3, OBJECTVALUE4 FROM PSPROJECTITEM WHERE PSPROJECTITEM.PROJECTNAME = 'SU_SC_MERGED_881SP1_MP7_TO_MP9' AND PSPROJEC (62,16)
System Error : TITEM.OBJECTTYPE = 2 AND PSPROJECTITEM.OBJECTID1 = 6 AND PSPROJECTITEM.OBJECTID2 = 0 (62,16)
Fields Compare Report Created : C:\ps\fs881\su_logs\current\SU_SC_MERGED_881SP1_MP7_TO_MP9\Upg02Fields.prt (75,9)



 

 

 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.