E-UPG: Creating Integration Broker Objects: Duplicate Rows in PSPROJECTITEM (Doc ID 654826.1)

Last updated on AUGUST 04, 2013

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
***Checked for relevance on 05-Aug-2013***


Symptoms


When upgrading from PT 8.48 to PT 8.49, step "Creating Integration Broker Objects" fails with duplicate row violations on insert to table PSPROJECTITEM.

PeopleTools 8.49.01 - Application Engine
Copyright (c) 1988-2007 PeopleSoft, Inc.
All Rights Reserved


Process 2 resumed after step PTUPGCONVERT.MAIN.Check (108,538)
 Message Set Number: 108
 Message Number: 538
 Message Reason: Process 2 resumed after step PTUPGCONVERT.MAIN.Check (108,538)

Beginning IB metadata migration at 2007-05-06-11.53.12.000000 : N. (158,15400)
 Message Set Number: 158
 Message Number: 15400
 Message Reason: Beginning IB metadata migration at 2007-05-06-11.53.12.000000 : N. (158,15400)

Loading connector information. (158,15401)
 Message Set Number: 158
 Message Number: 15401
 Message Reason: Loading connector information. (158,15401)

Migrating channels. (158,15406)

Migrating Message PeopleCode. (158,15404)

Creating services. (158,15412)

Creating service operations. (158,15408)

File: e:\pt849-903-R1-retail\peopletools\SRC\pssys\pjmupd.cppSQL error. Stmt #: 730  Error Position: 0  Return: 805 - [IBM][CLI Driver][DB2/AIX64] SQL0803N  One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains
Failed SQL stmt:INSERT INTO PSPROJECTITEM (PROJECTNAME, OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, NODETYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION, COPYDONE) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16)
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:\pt849-903-R1-retail\peopletools\SRC\pssys\pjmupd.cppSQL error. Stmt #: 730  Error Position: 0  Return: 805 - [IBM][CLI Driver][DB2/AIX64] SQL0803N  One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains

 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:\pt849-903-R1-retail\peopletools\SRC\pssys\genmsg.cppSQL error. Stmt #: 1029  Error Position: 0  Return: 8055 - Cursor entry has not been initialized (SQLSTATE PS055)
Failed SQL stmt:SELECT MESSAGE_SEQ FROM PS_MESSAGE_LOG WHERE PROCESS_INSTANCE =:1 AND MESSAGE_SEQ = :2 FOR UPDATE OF PROCESS_INSTANCE (200,0)

Process 2 ABENDED at Step UPGPT848IBUG.MAIN.Step08 (PeopleCode) -- RC = ? (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 2 ABENDED at Step UPGPT848IBUG.MAIN.Step08 (PeopleCode) -- RC = ? (108,524)

Cause

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