java.sql.SQLException: Cannot call commit when using distributed transactions Error Code: 0

Oracle Community | 2931183 | 1 year ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Unable to test BPEL in SOA SUITE 12c

    Oracle Community | 1 year ago | 2931183
    java.sql.SQLException: Cannot call commit when using distributed transactions Error Code: 0
  2. 0

    Planning 9.2 to 9.3.1 migration issues

    Oracle Community | 8 years ago | 698244
    java.sql.SQLException: [Hyperion][SQLServer JDBC Driver][SQLServer]'FK_HSP_FCALC _FID' is not a constraint.

    Root Cause Analysis

    1. java.sql.SQLException

      Cannot call commit when using distributed transactions Error Code: 0

      at oracle.soa.tracking.fabric.persistence.InstanceTrackingPersistenceManagerImpl.allocateKeyRange()
    2. oracle.soa.tracking
      InstanceTrackingPersistenceManagerImpl.getNextAuditTrailCountId
      1. oracle.soa.tracking.fabric.persistence.InstanceTrackingPersistenceManagerImpl.allocateKeyRange(InstanceTrackingPersistenceManagerImpl.java:1306)
      2. oracle.soa.tracking.fabric.persistence.KeyRangeAllocatorImpl.allocateNewRange(KeyRangeAllocatorImpl.java:136)
      3. oracle.soa.tracking.fabric.persistence.KeyRangeAllocatorImpl.getKeyRange(KeyRangeAllocatorImpl.java:87)
      4. oracle.soa.tracking.fabric.persistence.KeyRangeAllocatorImpl.getNextId(KeyRangeAllocatorImpl.java:106)
      5. oracle.soa.tracking.fabric.persistence.InstanceTrackingPersistenceManagerImpl.getNextAuditTrailCountId(InstanceTrackingPersistenceManagerImpl.java:1560)
      5 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    4. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
      2 frames
    5. com.sun.proxy
      $Proxy327.getNextAuditTrailCountId
      1. com.sun.proxy.$Proxy327.getNextAuditTrailCountId(Unknown Source)
      1 frame
    6. oracle.soa.tracking
      JpaAuditTrailDaoImpl.getNextCount
      1. oracle.soa.tracking.fabric.audit.entity.JpaAuditTrailDaoImpl.getNextCount(JpaAuditTrailDaoImpl.java:146)
      1 frame
    7. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    8. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
      2 frames
    9. com.sun.proxy
      $Proxy344.getNextCount
      1. com.sun.proxy.$Proxy344.getNextCount(Unknown Source)
      1 frame
    10. oracle.soa.tracking
      AuditTrailBeanImpl.storeBatchAuditEvents
      1. oracle.soa.tracking.fabric.audit.AuditTrailPersistenceMgr.serializeEvents(AuditTrailPersistenceMgr.java:154)
      2. oracle.soa.tracking.fabric.audit.AuditTrailPersistenceMgr.serialize(AuditTrailPersistenceMgr.java:106)
      3. oracle.soa.tracking.fabric.audit.AuditTrailPersistenceMgr.store(AuditTrailPersistenceMgr.java:73)
      4. oracle.soa.tracking.fabric.audit.AuditTrailBeanImpl.storeBatchAuditEvents(AuditTrailBeanImpl.java:74)
      4 frames
    11. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    12. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      3 frames
    13. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
      1 frame
    14. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      2 frames
    15. com.sun.proxy
      $Proxy326.storeBatchAuditEvents
      1. com.sun.proxy.$Proxy326.storeBatchAuditEvents(Unknown Source)
      1 frame
    16. oracle.soa.tracking
      InstanceTrackingPersistenceManagerImpl.performOperations
      1. oracle.soa.tracking.fabric.persistence.InstanceTrackingPersistenceManagerImpl.writeBatchAuditEvents(InstanceTrackingPersistenceManagerImpl.java:1534)
      2. oracle.soa.tracking.fabric.persistence.InstanceTrackingPersistenceManagerImpl.performOperations(InstanceTrackingPersistenceManagerImpl.java:1517)
      2 frames
    17. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    18. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      3 frames
    19. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
      1 frame
    20. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      2 frames
    21. com.sun.proxy
      $Proxy327.performOperations
      1. com.sun.proxy.$Proxy327.performOperations(Unknown Source)
      1 frame
    22. oracle.soa.tracking
      TopLinkEventListener.preCommitUnitOfWork
      1. oracle.soa.tracking.fabric.service.internal.OperationsHolder.performPendingOperations(OperationsHolder.java:1348)
      2. oracle.soa.tracking.fabric.service.internal.OperationsHolder.onPreCommit(OperationsHolder.java:396)
      3. oracle.soa.tracking.fabric.service.internal.MGIContext.onPreCommit(MGIContext.java:782)
      4. oracle.soa.tracking.fabric.service.internal.MultipleGlobalInstanceTrackingPersistencePolicy.onPreCommit(MultipleGlobalInstanceTrackingPersistencePolicy.java:325)
      5. oracle.soa.tracking.fabric.service.internal.AuditServiceImpl.onPreCommit(AuditServiceImpl.java:3830)
      6. oracle.soa.tracking.fabric.service.internal.TopLinkEventListener.preCommitUnitOfWork(TopLinkEventListener.java:48)
      6 frames
    23. EclipseLink (non-OSGi)
      JTASynchronizationListener.beforeCompletion
      1. org.eclipse.persistence.sessions.SessionEventManager.preCommitUnitOfWork(SessionEventManager.java:583)
      2. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3165)
      3. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3149)
      4. org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:158)
      5. org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68)
      5 frames
    24. weblogic.transaction.internal
      ServerTransactionImpl.commit
      1. weblogic.transaction.internal.ServerSCInfo.doBeforeCompletion(ServerSCInfo.java:1390)
      2. weblogic.transaction.internal.ServerSCInfo.callBeforeCompletions(ServerSCInfo.java:1363)
      3. weblogic.transaction.internal.ServerSCInfo.startPrePrepareAndChain(ServerSCInfo.java:127)
      4. weblogic.transaction.internal.ServerTransactionImpl.localPrePrepareAndChain(ServerTransactionImpl.java:1409)
      5. weblogic.transaction.internal.ServerTransactionImpl.globalPrePrepare(ServerTransactionImpl.java:2226)
      6. weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:293)
      7. weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:260)
      7 frames
    25. weblogic.ejb.container
      SessionLocalMethodInvoker.invoke
      1. weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:338)
      2. weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:207)
      3. weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:46)
      3 frames
    26. com.collaxa.cube
      BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.post
      1. com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.post(Unknown Source)
      1 frame
    27. oracle.fabric
      CubeServiceEngine.post
      1. oracle.fabric.CubeServiceEngine.post(CubeServiceEngine.java:614)
      1 frame
    28. oracle.integration.platform
      MeshImpl.post
      1. oracle.integration.platform.blocks.mesh.AsynchronousMessageHandler.doPost(AsynchronousMessageHandler.java:144)
      2. oracle.integration.platform.blocks.mesh.MessageRouter.post(MessageRouter.java:231)
      3. oracle.integration.platform.blocks.mesh.MeshImpl.post(MeshImpl.java:421)
      3 frames
    29. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    30. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      3 frames
    31. oracle.integration.platform
      PhaseEventAspect.invoke
      1. oracle.integration.platform.metrics.PhaseEventAspect.invoke(PhaseEventAspect.java:59)
      1 frame
    32. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      2 frames
    33. com.sun.proxy
      $Proxy321.post
      1. com.sun.proxy.$Proxy321.post(Unknown Source)
      1 frame
    34. oracle.integration.platform
      FabricProvider.processMessage
      1. oracle.integration.platform.blocks.soap.WebServiceEntryBindingComponent.doMessageProcessing(WebServiceEntryBindingComponent.java:2312)
      2. oracle.integration.platform.blocks.soap.WebServiceEntryBindingComponent.processIncomingMessage(WebServiceEntryBindingComponent.java:1373)
      3. oracle.integration.platform.blocks.soap.FabricProvider.processMessage(FabricProvider.java:113)
      3 frames
    35. oracle.j2ee.ws
      WebServiceServlet.doPost
      1. oracle.j2ee.ws.server.provider.ProviderProcessor.doEndpointProcessing(ProviderProcessor.java:1319)
      2. oracle.j2ee.ws.server.WebServiceProcessor.invokeEndpointImplementation(WebServiceProcessor.java:1380)
      3. oracle.j2ee.ws.server.provider.ProviderProcessor.doRequestProcessingPhaseTwo(ProviderProcessor.java:705)
      4. oracle.j2ee.ws.server.WebServiceProcessor.doRequestProcessing(WebServiceProcessor.java:693)
      5. oracle.j2ee.ws.server.WebServiceProcessor.processRequest(WebServiceProcessor.java:251)
      6. oracle.j2ee.ws.server.WebServiceProcessor.doService(WebServiceProcessor.java:215)
      7. oracle.j2ee.ws.server.WebServiceServlet.doService(WebServiceServlet.java:687)
      8. oracle.j2ee.ws.server.WebServiceServlet.doPost(WebServiceServlet.java:525)
      8 frames
    36. oracle.integration.platform
      FabricProviderServlet.doPost
      1. oracle.integration.platform.blocks.soap.FabricProviderServlet.doPost(FabricProviderServlet.java:755)
      1 frame
    37. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:751)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
      2 frames
    38. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
      2. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
      3. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)
      4. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)
      5. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
      6. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      6 frames
    39. oracle.security.jps
      JpsAbsFilter$1.run
      1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)
      1 frame
    40. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    41. oracle.security.jps
      JpsFilter.doFilter
      1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
      2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
      3. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:120)
      4. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:217)
      5. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:81)
      5 frames
    42. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    43. oracle.dms.servlet
      DMSServletFilter.doFilter
      1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:220)
      1 frame
    44. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)
      3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)
      3 frames
    45. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    46. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    47. weblogic.servlet.provider
      WlsSubjectHandle.run
      1. weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
      1 frame
    48. Atmosphere weblogic
      ServletRequestImpl.run
      1. weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)
      2. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)
      3. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
      4. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)
      4 frames
    49. weblogic.servlet.provider
      ContainerSupportProviderImpl$WlsRequestExecutor.run
      1. weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
      1 frame
    50. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
      2 frames