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

Oracle Community | 2931183 | 8 months ago
  1. 0

    Unable to test BPEL in SOA SUITE 12c

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

    Weblogic Eclipselink Sequence Table Connection Pool Sequence Separate transaction while JTA on main transaction

    Oracle Community | 2 years ago | sono99
    java.sql.SQLException: Cannot call commit when using distributed transactions Error Code: 0
  3. 0

    Unable to test BPEL in SOA SUITE 12c

    Oracle Community | 8 months ago | 2931183
    java.sql.SQLException: Cannot call commit when using distributed transactions Error Code: 0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    setting up external transaction controller on Weblogic 9/Toplink 11

    Oracle Community | 7 years ago | 598409
    java.sql.SQLException: Cannot call commit when using distributed transactions Error Code: 0
  6. 0

    FMW 11G commit error and OJMS with WLS foreign server

    Oracle Community | 7 years ago | biemond
    oracle.tip.b2b.transport.TransportException: [IPT_MsgCannotBeSent] JMS message cannot be sent.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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