java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Unable to test BPEL in SOA SUITE 12c
    via by 2931183,
    • 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 org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) 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 org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) 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:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) 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:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) 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.flush(OperationsHolder.java:479) at oracle.soa.tracking.fabric.service.internal.MGIContext.onRollback(MGIContext.java:817) at oracle.soa.tracking.fabric.service.internal.InstanceTrackingTransactionSync.afterCompletion(InstanceTrackingTransactionSync.java:262) at oracle.soa.tracking.fabric.transactions.CommonTxnSynchronizer.afterCompletion(CommonTxnSynchronizer.java:97) at weblogic.transaction.internal.ServerSCInfo.doAfterCompletion(ServerSCInfo.java:1182) at weblogic.transaction.internal.ServerSCInfo.callAfterCompletions(ServerSCInfo.java:1124) at weblogic.transaction.internal.ServerTransactionImpl.callAfterCompletions(ServerTransactionImpl.java:3191) at weblogic.transaction.internal.ServerTransactionImpl.afterRolledBackStateHousekeeping(ServerTransactionImpl.java:3070) at weblogic.transaction.internal.ServerTransactionImpl.setRolledBack(ServerTransactionImpl.java:3046) at weblogic.transaction.internal.ServerTransactionImpl.globalRetryRollback(ServerTransactionImpl.java:3289) at weblogic.transaction.internal.ServerTransactionImpl.globalRollback(ServerTransactionImpl.java:3036) at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:367) 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 org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at oracle.integration.platform.metrics.PhaseEventAspect.invoke(PhaseEventAspect.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) 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 weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137) at java.security.AccessController.doPrivileged(Native Method) 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 weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) 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.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402) 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)
    No Bugmate found.