My Oracle Support Banner

When Running Gateway Synchronization "Send P6 Project Data to Prime for Schedule" The Error "Internal Exception: java.sql.SQLIntegrity ConstraintViolationException: ORA-00001:unique constraint (GATEWAYADMIN.FLOWSTEPINSTMSG_UK) Violated " Occurs (Doc ID 2435321.1)

Last updated on AUGUST 14, 2018

Applies to:

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

Symptoms

When attempting to synchronize P6 to Prime, the following error occurs.

ERROR
-----------------------
Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exce....'

Failure Details:
com.oracle.pgbu.pdi.provider.ProviderException: Could not commit JPA transaction, nested exception is javax.persistence.RollbackException: Exception [ExclipseLink:4002] {Eclipse Persistence Services -  2.5.2.v20140319-9ad6abd):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrity ConstraintViolationException: ORA-00001:unique constraint (GATEWAYADMIN.FLOWSTEPINSTMSG_UK) violated

Error Code 1:
Call: INSERT INTO FLOWSTEPINSTMSG (FLOWSTEPINSTMSG_ID, CREATE_DATE, CREATE_USER, FLOWSTEPINSTMSG_DATA, MSG_NAME, FLOWSTEPINSTMSG_SEQNO, UPDATE_DATE, UPDATE_USER, FLOWSTEPINST_ID) VALUES (?,?,?,?,?,?,?,?,?)
BIND => [9 parameters bound]
  at
com.oracle.pgbu.service.context.FlowStepContextImpl.writeMessage(FlowStepContextImpl.java 154)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run a P6 to Prime synchronization for creating a project using Gateway
2. Notice the error in the UpdateDestination step.


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.