E-UPG: PeopleTools 8.55 Upgrade Causes Unique Constraint Errors on PSPSWDHISTORY when Building Index PS_PSPSWDHISTORY (Doc ID 2120396.1)

Last updated on MARCH 24, 2016

Applies to:

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

Symptoms

On : 8.55 version, Upgrade

When upgrading to PeopleTools 8.55 from PeopleTools 8.52 and below, the unique index fails to create for index PS_PSPSWDHISTORY on table PSPSWDHISTORY.  The following error occurs.

ERROR
-----------------------

12:07:18 SQL> CREATE UNIQUE iNDEX PS_PSPSWDHISTORY ON PSPSWDHISTORY (OPRID,
12:07:18 2 PTOPERPSWDV2,
12:07:18 3 OPERPSWDSALT) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000
12:07:18 4 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING
12:07:18 5 /
CREATE UNIQUE iNDEX PS_PSPSWDHISTORY ON PSPSWDHISTORY (OPRID,
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P004
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run script PPLTLS84CURTABLES.


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