My Oracle Support Banner

When Running a Gateway Synchronization from P6 to Oracle Primavera Cloud Service (OPC) the OPC Update Fails with the Error "ORA-00001: unique constraint (T_SEED_PRIMEAPP_ADM.PS_RESOURCE_U1) violated" (Doc ID 2779717.1)

Last updated on MAY 28, 2021

Applies to:

Oracle Primavera Cloud Service - Version 21.4 to 21.5 [Release 21.4 to 21.5]
Primavera Gateway - Version 21.1 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 21.4 to 21.5 [Release 21.4 to 21.5]
Information in this document applies to any platform.

Symptoms

When attempting to run a P6 to OPC synchronization, the following errors occur on the UpdateDestination step.

ERROR
-----------------------
java.lang.NullPointerException

{"errors":[{"message":"Exception while fetching data (/sync) : Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception : org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (T_SEED_PRIMEAPP_ADM.PS_RESOURCE_U1) violated
ORA-06512: at line 1
Error Code: 1
Call: BEGIN INSERT INTO PS_RESOURCE (PS_RESOURCE_ID, ASSOCIATION_TYPE, CREATE_ON_BEHALF_OF_USER, CREATE_USER, IS_ROOT, SEQ_NUM, UPDATE_ON_BEHALF_OF_USER, UPDATE_USER, PROJ_ID, RESOURCE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING CREATE_TS, UPDATE_TS INTO ?, ?; END;
bind => [12 parameters bound]
Query: InsertObjectQuery(com.oracle.pgbu.model.entity.ProjectResourceEO)","locations":[]}],"data":{"sync":null}}

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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.