Unexpected exception in beforeCompletion: sync=org.eclipse.persistence.transaction.JTASynchronizatio

Srinanda Das

I am getting this error from soa logs but dont understand why its giving. Can you please suggest/help on this with any solutions?

Error trace:

<Aug 22, 2019 11:01:40 AM MDT> <Error> <oracle.soa.bpel.system> <BEA-000000> <Unhandled BPELFault:faultName: {{http://schemas.oracle.com/bpel/extension}remoteFault}

messageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage}

parts: {{

summary=<summary>oracle.fabric.common.FabricInvocationException: org.springframework.transaction.UnexpectedRollbackException: JTA transaction unexpectedly rolled back (maybe due to a timeout); nested exception is weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync[email protected]96453033

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ENTPROD_SOAINFRA.SCA_FLOW_INSTANCE_PK) violated

Error Code: 1

Call: INSERT INTO SCA_FLOW_INSTANCE (FLOW_ID, ACTIVE_COMPONENT_INSTANCES, ADMIN_STATE, COMPOSITE_SCA_ENTITY_ID, CONVERSATION_ID, FLOW_CORRELATION_ID, CREATED_BY, CREATED_TIME, ECID, PROPERTIES, PURGEABLE, RECOVERABLE_FAULTS, RESEQUENCER, SCA_PARTITION_ID, TENANT_ID, TEST_CASE, TEST_RUN_ID, TEST_RUN_NAME, TEST_SUITE, TITLE, UNHANDLED_FAULTS, UPDATED_BY, UPDATED_TIME, VERSION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

        bind => [2835015, 0, -1, 250001, 6200881%2B998%401566493298, 0000MmuHhD65UcG5qz^AyY1TNbnC00005R, anonymous, 2019-08-22 11:01:39.526, f4838447-0527-420b-99ed-ad39a139c080-000a9cce, null, null, 0, false, 20001, -1, null, null, null, null, null, 0, anonymous, 2019-08-22 11:01:39.98, 1]</summary>

,code=<code>null</code>

,detail=<detail>ORA-00001: unique constraint (ENTPROD_SOAINFRA.SCA_FLOW_INSTANCE_PK) violated

</detail>}

** Cikey: 89871147

** FlowId: 2835015

** Current Activity Key: 89871147-BpRTh0-BpSeq1.9-2

** Current Activity Label: bpel:rethrow (0)

** InvokeMessageGuid: 824e084d-c4fe-11e9-a995-06e1c8deeb0a

** ComponentDN: abc/pollempdatatest_Integration!1.3*soa_783573b5-7361-4341-9def-0974a52e4d0e/PollEmployeesProcess

** Properties for component PollEmployeesProcess:

   ** bpel.config.transaction: notSupported

   ** bpel.config.oneWayDeliveryPolicy: async.persist

** MaxThreadsConstraints: 60

** Total dispatcher messages scheduled for processing: 4

** Total number of threads processing dispatcher messages: 3

** Max Heap size: 10737418240

** Free Heap size: 3554826848>

<Aug 22, 2019 11:01:40 AM MDT> <Error> <oracle.soa.bpel.engine.dispatch> <BEA-000000> <

** ComponentDN: abc/pollempdatatest_Integration!1.3*soa_783573b5-7361-4341-9def-0974a52e4d0e/PollEmployeesProcess

** Properties for component PollEmployeesProcess:

   ** bpel.config.transaction: notSupported

   ** bpel.config.oneWayDeliveryPolicy: async.persist

** MaxThreadsConstraints: 60

** Total dispatcher messages scheduled for processing: 4

** Total number of threads processing dispatcher messages: 3

** Max Heap size: 10737418240

** Free Heap size: 3554302312

com.oracle.bpel.client.BPELFault: faultName: {{http://schemas.oracle.com/bpel/extension}remoteFault}

messageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage}

parts: {{

summary=<summary>oracle.fabric.common.FabricInvocationException: org.springframework.transaction.UnexpectedRollbackException: JTA transaction unexpectedly rolled back (maybe due to a timeout); nested exception is weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync[email protected]96453033

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ENTPROD_SOAINFRA.SCA_FLOW_INSTANCE_PK) violated

Error Code: 1

Call: INSERT INTO SCA_FLOW_INSTANCE (FLOW_ID, ACTIVE_COMPONENT_INSTANCES, ADMIN_STATE, COMPOSITE_SCA_ENTITY_ID, CONVERSATION_ID, FLOW_CORRELATION_ID, CREATED_BY, CREATED_TIME, ECID, PROPERTIES, PURGEABLE, RECOVERABLE_FAULTS, RESEQUENCER, SCA_PARTITION_ID, TENANT_ID, TEST_CASE, TEST_RUN_ID, TEST_RUN_NAME, TEST_SUITE, TITLE, UNHANDLED_FAULTS, UPDATED_BY, UPDATED_TIME, VERSION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

        bind => [2835015, 0, -1, 250001, 6200881%2B998%401566493298, 0000MmuHhD65UcG5qz^AyY1TNbnC00005R, anonymous, 2019-08-22 11:01:39.526, f4838447-0527-420b-99ed-ad39a139c080-000a9cce, null, null, 0, false, 20001, -1, null, null, null, null, null, 0, anonymous, 2019-08-22 11:01:39.98, 1]</summary>

,code=<code>null</code>

,detail=<detail>ORA-00001: unique constraint (ENTPROD_SOAINFRA.SCA_FLOW_INSTANCE_PK) violated

</detail>}

Thanks in advance

Lior Asras -Oracle

Im facing this issue too, any refrences?