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:
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 16.2.0.0 and laterPrimavera 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:
- Log-in to P6 Professional
- Copy/paste a project or project(s) with User Defined Fields
- Note the error which occurs once the copy/paste completes in the log
Changes
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