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 laterPrimavera Gateway - Version 21.1 and later
Oracle Primavera Cloud Service - Version 21.1 and later
Information in this document applies to any platform.
Symptoms
When attempting to move data from P6 to OPC using Primavera Gateway, the following error occurs.
ERROR
-----------------------
{"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(com.oracle.pgbu.model.entity.ProjectResourceWorkRateEO@5c9b59a0)","locations":[]}],"data":{"sync":null}}
STEPS
-----------------------
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
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |