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

Last updated on APRIL 16, 2018

Applies to:

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

Changes

Cause