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 MARCH 22, 2022
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document