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

Last updated on JUNE 07, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201040427



"""""reviewed for currency Sept 2012"""""
*** currency checked Aug 2014 ***


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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms