Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Unexpected exception in beforeCompletion: sync=org.eclipse.persistence.transaction.JTASynchronizatio

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
Answers
-
Im facing this issue too, any refrences?