My Oracle Support Banner

Error "ORA-00001: unique constraint (T_<COMPANY>_PRIMEAPP_ADM.RM_PROJECT_WORK_RATE_U1) violated" When Synchronizing P6 Data to OPC Using Primavera Gateway (Doc ID 2882198.1)

Last updated on JULY 12, 2022

Applies to:

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


When attempting to move data from P6 to OPC using Primavera Gateway, the following error occurs.

{"errors":[{"message":"Exception while fetching data (/sync) : Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException\nInternal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (T_<COMPANY>_PRIMEAPP_ADM.RM_PROJECT_WORK_RATE_U1) violated\nORA-06512: at line 1\n\nError Code: 1\nCall: BEGIN INSERT INTO RM_PROJECT_WORK_RATE (PROJECT_WORK_RATE_ID, CREATE_ON_BEHALF_OF_USER, CREATE_USER, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, MAX_UPT, UPDATE_ON_BEHALF_OF_USER, UPDATE_USER, PROJECT_RESOURCE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING CREATE_TS, UPDATE_TS INTO ?, ?; END;\n\tbind => [11 parameters bound]\nQuery: InsertObjectQuery(","locations":[]}],"data":{"sync":null}}

The issue can be reproduced at will with the following steps:
1. Run the Send P6 project data to Primavera Cloud for Schedule business flow from Primavera Gateway




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

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