My Oracle Support Banner

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 APRIL 27, 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

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.