Error: Error in SQL Script ORPM_P16210.sql: DatabaseToolException (ORA-00001: unique constraint (ADMUSER.PK_PROFPRIV) violated) When Upgrading From Version 16.2.x to 17.x

(Doc ID 2356243.1)

Last updated on FEBRUARY 07, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to upgrade EPPM database from version 16.2.x to 17.x the following error occurs.

ERROR
-----------------------
Error in SQL Script ORPM_P16210.sql: DatabaseToolException (ORA-00001: unique constraint (ADMUSER.PK_PROFPRIV) violated)

SQL Query:
Update profpriv SET priv_num=60 WHERE priv_num=58.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
    1. Follow steps from P6 EPPM patchset for 17.x
    2. Run manual_script_before_upgrade.sql --> Oracle Database only
    3. Run dbsetup.bat to upgrade database
    4. Upgrade fails at 'Perform core upgrade steps' step in the Primavera Database Setup wizard

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