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

Oracle Community | 2931183 | 11 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Unable to test BPEL in SOA SUITE 12c

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

    Root Cause Analysis

    1. java.sql.SQLException

      Cannot call commit when using distributed transactions Error Code: 0

      at oracle.soa.tracking.fabric.persistence.InstanceTrackingPersistenceManagerImpl.performOperations()
    2. oracle.soa.tracking
      InstanceTrackingPersistenceManagerImpl.performOperations
      1. oracle.soa.tracking.fabric.persistence.InstanceTrackingPersistenceManagerImpl.performOperations(InstanceTrackingPersistenceManagerImpl.java:1521)
      1 frame
    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
      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
    5. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
      1 frame
    6. 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
    7. com.sun.proxy
      $Proxy327.performOperations
      1. com.sun.proxy.$Proxy327.performOperations(Unknown Source)
      1 frame
    8. oracle.soa.tracking
      CommonTxnSynchronizer.afterCompletion
      1. oracle.soa.tracking.fabric.service.internal.OperationsHolder.performPendingOperations(OperationsHolder.java:1348)
      2. oracle.soa.tracking.fabric.service.internal.OperationsHolder.flush(OperationsHolder.java:479)
      3. oracle.soa.tracking.fabric.service.internal.MGIContext.onRollback(MGIContext.java:817)
      4. oracle.soa.tracking.fabric.service.internal.InstanceTrackingTransactionSync.afterCompletion(InstanceTrackingTransactionSync.java:262)
      5. oracle.soa.tracking.fabric.transactions.CommonTxnSynchronizer.afterCompletion(CommonTxnSynchronizer.java:97)
      5 frames
    9. weblogic.transaction.internal
      ServerTransactionImpl.commit
      1. weblogic.transaction.internal.ServerSCInfo.doAfterCompletion(ServerSCInfo.java:1182)
      2. weblogic.transaction.internal.ServerSCInfo.callAfterCompletions(ServerSCInfo.java:1124)
      3. weblogic.transaction.internal.ServerTransactionImpl.callAfterCompletions(ServerTransactionImpl.java:3191)
      4. weblogic.transaction.internal.ServerTransactionImpl.afterRolledBackStateHousekeeping(ServerTransactionImpl.java:3070)
      5. weblogic.transaction.internal.ServerTransactionImpl.setRolledBack(ServerTransactionImpl.java:3046)
      6. weblogic.transaction.internal.ServerTransactionImpl.globalRetryRollback(ServerTransactionImpl.java:3289)
      7. weblogic.transaction.internal.ServerTransactionImpl.globalRollback(ServerTransactionImpl.java:3036)
      8. weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:367)
      9. weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:260)
      9 frames
    10. 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
    11. com.collaxa.cube
      BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.post
      1. com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.post(Unknown Source)
      1 frame
    12. oracle.fabric
      CubeServiceEngine.post
      1. oracle.fabric.CubeServiceEngine.post(CubeServiceEngine.java:614)
      1 frame
    13. 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
    14. 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
    15. 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
    16. oracle.integration.platform
      PhaseEventAspect.invoke
      1. oracle.integration.platform.metrics.PhaseEventAspect.invoke(PhaseEventAspect.java:59)
      1 frame
    17. 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
    18. com.sun.proxy
      $Proxy321.post
      1. com.sun.proxy.$Proxy321.post(Unknown Source)
      1 frame
    19. 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
    20. 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
    21. oracle.integration.platform
      FabricProviderServlet.doPost
      1. oracle.integration.platform.blocks.soap.FabricProviderServlet.doPost(FabricProviderServlet.java:755)
      1 frame
    22. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:751)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
      2 frames
    23. 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
    24. oracle.security.jps
      JpsAbsFilter$1.run
      1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)
      1 frame
    25. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    26. 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
    27. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    28. oracle.dms.servlet
      DMSServletFilter.doFilter
      1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:220)
      1 frame
    29. 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
    30. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    31. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    32. weblogic.servlet.provider
      WlsSubjectHandle.run
      1. weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
      1 frame
    33. 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
    34. weblogic.servlet.provider
      ContainerSupportProviderImpl$WlsRequestExecutor.run
      1. weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
      1 frame
    35. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
      2 frames