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
      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
    23. 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
    24. 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
    25. com.collaxa.cube
      BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.post
      1. com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.post(Unknown Source)
      1 frame
    26. oracle.fabric
      CubeServiceEngine.post
      1. oracle.fabric.CubeServiceEngine.post(CubeServiceEngine.java:614)
      1 frame
    27. 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
    28. 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
    29. 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
    30. oracle.integration.platform
      PhaseEventAspect.invoke
      1. oracle.integration.platform.metrics.PhaseEventAspect.invoke(PhaseEventAspect.java:59)
      1 frame
    31. 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
    32. com.sun.proxy
      $Proxy321.post
      1. com.sun.proxy.$Proxy321.post(Unknown Source)
      1 frame
    33. 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
    34. 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
    35. oracle.integration.platform
      FabricProviderServlet.doPost
      1. oracle.integration.platform.blocks.soap.FabricProviderServlet.doPost(FabricProviderServlet.java:755)
      1 frame
    36. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:751)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
      2 frames
    37. 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
    38. oracle.security.jps
      JpsAbsFilter$1.run
      1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)
      1 frame
    39. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    40. 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
    41. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    42. oracle.dms.servlet
      DMSServletFilter.doFilter
      1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:220)
      1 frame
    43. 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
    44. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    45. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    46. weblogic.servlet.provider
      WlsSubjectHandle.run
      1. weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
      1 frame
    47. 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
    48. weblogic.servlet.provider
      ContainerSupportProviderImpl$WlsRequestExecutor.run
      1. weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
      1 frame
    49. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
      2 frames