Error: "ORA-00001: Unique Constraint (ADMUSER.PK_UDFVALUE) Violated" or "Violation of PRIMARY KEY Constraint 'Pk_udfvalue'. Cannot Insert Duplicate Key in Object 'dbo.UDFVALUE'" When Running a Copy/Paste Project Service

(Doc ID 2320634.1)

Last updated on JANUARY 19, 2018

Applies to:

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

Symptoms

After copy and paste of a project (or projects) with user defined fields, the job will complete successfully but the following error is generated in the log file:

ERROR:
SQL [insert  /*+ index(UDFVALUE,NDX_UDFVALUE_FK) */  into UDFVALUE...]; ORA-00001: unique constraint (ADMUSER.PK_UDFVALUE) violated ;
nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ADMUSER.PK_UDFVALUE) violated

OR

PreparedStatementCallback; SQL [insert /*+ index(UDFVALUE,NDX_UDFVALUE_FK) */ into UDFVALUE...]; Violation of PRIMARY KEY constraint 'pk_udfvalue'. Cannot insert duplicate key in object 'dbo.UDFVALUE'. The duplicate key value is (###,###).; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'pk_udfvalue'. Cannot insert duplicate key in object 'dbo.UDFVALUE'. The duplicate key value is (###,###).

STEPS TO REPRODUCE:

  1. Log-in to P6 Professional
  2. Copy/paste a project or project(s) with User Defined Fields
  3. Note the error which occurs once the copy/paste completes in the log

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