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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 2931183, 1 year ago
Cannot call commit when using distributed transactions Error Code: 0
java.sql.SQLException: Cannot call commit when using distributed transactions Error Code: 0
at oracle.soa.tracking.fabric.persistence.InstanceTrackingPersistenceManagerImpl.allocateKeyRange(InstanceTrackingPersistenceManagerImpl.java:1306)
at oracle.soa.tracking.fabric.persistence.KeyRangeAllocatorImpl.allocateNewRange(KeyRangeAllocatorImpl.java:136)
at oracle.soa.tracking.fabric.persistence.KeyRangeAllocatorImpl.getKeyRange(KeyRangeAllocatorImpl.java:87)
at oracle.soa.tracking.fabric.persistence.KeyRangeAllocatorImpl.getNextId(KeyRangeAllocatorImpl.java:106)
at oracle.soa.tracking.fabric.persistence.InstanceTrackingPersistenceManagerImpl.getNextAuditTrailCountId(InstanceTrackingPersistenceManagerImpl.java:1560)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
at com.sun.proxy.$Proxy327.getNextAuditTrailCountId(Unknown Source)
at oracle.soa.tracking.fabric.audit.entity.JpaAuditTrailDaoImpl.getNextCount(JpaAuditTrailDaoImpl.java:146)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
at com.sun.proxy.$Proxy344.getNextCount(Unknown Source)
at oracle.soa.tracking.fabric.audit.AuditTrailPersistenceMgr.serializeEvents(AuditTrailPersistenceMgr.java:154)
at oracle.soa.tracking.fabric.audit.AuditTrailPersistenceMgr.serialize(AuditTrailPersistenceMgr.java:106)
at oracle.soa.tracking.fabric.audit.AuditTrailPersistenceMgr.store(AuditTrailPersistenceMgr.java:73)
at oracle.soa.tracking.fabric.audit.AuditTrailBeanImpl.storeBatchAuditEvents(AuditTrailBeanImpl.java:74)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.sun.proxy.$Proxy326.storeBatchAuditEvents(Unknown Source)
at oracle.soa.tracking.fabric.persistence.InstanceTrackingPersistenceManagerImpl.writeBatchAuditEvents(InstanceTrackingPersistenceManagerImpl.java:1534)
at oracle.soa.tracking.fabric.persistence.InstanceTrackingPersistenceManagerImpl.performOperations(InstanceTrackingPersistenceManagerImpl.java:1517)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.sun.proxy.$Proxy327.performOperations(Unknown Source)
at oracle.soa.tracking.fabric.service.internal.OperationsHolder.performPendingOperations(OperationsHolder.java:1348)
at oracle.soa.tracking.fabric.service.internal.OperationsHolder.onPreCommit(OperationsHolder.java:396)
at oracle.soa.tracking.fabric.service.internal.MGIContext.onPreCommit(MGIContext.java:782)
at oracle.soa.tracking.fabric.service.internal.MultipleGlobalInstanceTrackingPersistencePolicy.onPreCommit(MultipleGlobalInstanceTrackingPersistencePolicy.java:325)
at oracle.soa.tracking.fabric.service.internal.AuditServiceImpl.onPreCommit(AuditServiceImpl.java:3830)
at oracle.soa.tracking.fabric.service.internal.TopLinkEventListener.preCommitUnitOfWork(TopLinkEventListener.java:48)
at org.eclipse.persistence.sessions.SessionEventManager.preCommitUnitOfWork(SessionEventManager.java:583)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3165)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3149)
at org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:158)
at weblogic.transaction.internal.ServerSCInfo.doBeforeCompletion(ServerSCInfo.java:1390)
at weblogic.transaction.internal.ServerSCInfo.callBeforeCompletions(ServerSCInfo.java:1363)
at weblogic.transaction.internal.ServerSCInfo.startPrePrepareAndChain(ServerSCInfo.java:127)
at weblogic.transaction.internal.ServerTransactionImpl.localPrePrepareAndChain(ServerTransactionImpl.java:1409)
at weblogic.transaction.internal.ServerTransactionImpl.globalPrePrepare(ServerTransactionImpl.java:2226)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:293)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:260)
at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:338)
at weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:207)
at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:46)
at com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.post(Unknown Source)
at oracle.fabric.CubeServiceEngine.post(CubeServiceEngine.java:614)
at oracle.integration.platform.blocks.mesh.AsynchronousMessageHandler.doPost(AsynchronousMessageHandler.java:144)
at oracle.integration.platform.blocks.mesh.MessageRouter.post(MessageRouter.java:231)
at oracle.integration.platform.blocks.mesh.MeshImpl.post(MeshImpl.java:421)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at oracle.integration.platform.metrics.PhaseEventAspect.invoke(PhaseEventAspect.java:59)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.sun.proxy.$Proxy321.post(Unknown Source)
at oracle.integration.platform.blocks.soap.WebServiceEntryBindingComponent.doMessageProcessing(WebServiceEntryBindingComponent.java:2312)
at oracle.integration.platform.blocks.soap.WebServiceEntryBindingComponent.processIncomingMessage(WebServiceEntryBindingComponent.java:1373)
at oracle.integration.platform.blocks.soap.FabricProvider.processMessage(FabricProvider.java:113)
at oracle.j2ee.ws.server.provider.ProviderProcessor.doEndpointProcessing(ProviderProcessor.java:1319)
at oracle.j2ee.ws.server.WebServiceProcessor.invokeEndpointImplementation(WebServiceProcessor.java:1380)
at oracle.j2ee.ws.server.provider.ProviderProcessor.doRequestProcessingPhaseTwo(ProviderProcessor.java:705)
at oracle.j2ee.ws.server.WebServiceProcessor.doRequestProcessing(WebServiceProcessor.java:693)
at oracle.j2ee.ws.server.WebServiceProcessor.processRequest(WebServiceProcessor.java:251)
at oracle.j2ee.ws.server.WebServiceProcessor.doService(WebServiceProcessor.java:215)
at oracle.j2ee.ws.server.WebServiceServlet.doService(WebServiceServlet.java:687)
at oracle.j2ee.ws.server.WebServiceServlet.doPost(WebServiceServlet.java:525)
at oracle.integration.platform.blocks.soap.FabricProviderServlet.doPost(FabricProviderServlet.java:755)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:751)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:120)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:217)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:81)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:220)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.