Error Referencing PNDT_UK When Upgrading Databases/Schemas to Contract Management 13.0 Service Pack 5 or Higher (Doc ID 1330773.1)

Last updated on JANUARY 12, 2017

Applies to:

Primavera Contract Management - Version 13.0 SP5 and later
Information in this document applies to any platform.

Symptoms

Either of the following error messages is thrown, when upgrading a Contract Management 13.0.x project group database/schema to Contract Management 13.0 service pack 5 or higher.

Oracle:

Error in Run SQL Script...: DatabaseToolException (ORA-02299: cannot validate (...PNDT_UK) - duplicate keys found)


Microsoft SQL Server:

Error in Run SQL Script...: DatabaseToolException (The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.PNDT' and the index name 'pndt_uk'. The duplicate key value is.....)

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