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
Last updated on FEBRUARY 07, 2018
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
When attempting to upgrade EPPM database from version 16.2.x to 17.x the following error occurs.
Error in SQL Script ORPM_P16210.sql: DatabaseToolException (ORA-00001: unique constraint (ADMUSER.PK_PROFPRIV) violated)
Update profpriv SET priv_num=60 WHERE priv_num=58.
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
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