14 Replies Latest reply on Oct 18, 2013 9:11 AM by Steven Hawkins

    No transaction found for client exception

    kchen007 Apprentice

      I am calling a stored procedure and from time to time I got the following exception, If I reissue the same call, it works fine, it is hard to tell when it work and when it quits.

      Any help would be appreciated.

       

       

      Internal Exception: org.teiid.jdbc.TeiidSQLException: org.teiid.client.xa.XATransactionException: TEIID30526 javax.transaction.InvalidTransactionException: No transaction found for client O/UWhntc4uA9.

      Error Code: 30526

      at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1501) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicCommitTransaction(DatabaseAccessor.java:426) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.commitTransaction(DatasourceAccessor.java:389) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.commitTransaction(DatabaseAccessor.java:411) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at org.eclipse.persistence.internal.sessions.AbstractSession.basicCommitTransaction(AbstractSession.java:603) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at org.eclipse.persistence.sessions.server.ClientSession.basicCommitTransaction(ClientSession.java:164) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at org.eclipse.persistence.internal.sessions.AbstractSession.commitTransaction(AbstractSession.java:798) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitTransaction(UnitOfWorkImpl.java:1578) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitTransaction(RepeatableWriteUnitOfWork.java:647) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitTransactionAfterWriteChanges(UnitOfWorkImpl.java:1593) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:274) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1147) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:84) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      at com.lgc.dsl.producer.jpa.commands.jpa.CommitTransactionCommand.execute(CommitTransactionCommand.java:23) [com_lgc_dsdataserver.jar:]

      at com.lgc.dsl.producer.jpa.commandchain.CommandChain.execute(CommandChain.java:54) [com_lgc_dsdataserver.jar:]

      at com.lgc.dsl.producer.jpa.DsdsCommonJPAProducer.callFunction(DsdsCommonJPAProducer.java:397) [com_lgc_dsdataserver.jar:]

      at org.odata4j.producer.resources.FunctionResource.callFunction(FunctionResource.java:295) [odata4j-bundle-0.7-lgc.jar:]

      at org.odata4j.producer.resources.FunctionResource.callFunction(FunctionResource.java:224) [odata4j-bundle-0.7-lgc.jar:]

      at org.odata4j.producer.resources.EntitiesRequestResource.getEntitiesImpl(EntitiesRequestResource.java:354) [odata4j-bundle-0.7-lgc.jar:]

      at org.odata4j.producer.resources.EntitiesRequestResource.getEntities(EntitiesRequestResource.java:253) [odata4j-bundle-0.7-lgc.jar:]

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_27]

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_27]

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_27]

      at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_27]

      at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:168) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:67) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:259) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:118) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:133) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:118) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:133) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:118) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:133) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:118) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:133) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:83) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:133) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:71) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:990) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:941) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:932) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:384) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:451) [jersey-server-1.1.5.jar:1.1.5]

      at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:632) [jersey-server-1.1.5.jar:1.1.5]

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

      at org.apache.catalina.core.StandardContextValve.__invoke(StandardContextValve.java:149) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

      at org.jboss.as.web.session.ClusteredSessionValve.handleRequest(ClusteredSessionValve.java:134) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]

      at org.jboss.as.web.session.ClusteredSessionValve.invoke(ClusteredSessionValve.java:99) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]

      at org.jboss.as.web.session.JvmRouteValve.invoke(JvmRouteValve.java:92) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]

      at org.jboss.as.web.session.LockingValve.invoke(LockingValve.java:64) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]

      at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]

      at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]

      at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]

      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

      at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:880) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

      at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:607) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

      at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:2036) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

      at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_27]

      Caused by: org.teiid.jdbc.TeiidSQLException: org.teiid.client.xa.XATransactionException: TEIID30526 javax.transaction.InvalidTransactionException: No transaction found for client O/UWhntc4uA9.

      at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) [teiid-client-8.4.0.Final.jar:8.4.0.Final]

      at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) [teiid-client-8.4.0.Final.jar:8.4.0.Final]

      at org.teiid.jdbc.ConnectionImpl.directCommit(ConnectionImpl.java:351) [teiid-client-8.4.0.Final.jar:8.4.0.Final]

      at org.teiid.jdbc.ConnectionImpl.commit(ConnectionImpl.java:338) [teiid-client-8.4.0.Final.jar:8.4.0.Final]

      at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicCommitTransaction(DatabaseAccessor.java:420) [eclipselink-2.4.1.jar:2.4.1.v20121003-ad44345]

      ... 65 more

      Caused by: java.util.concurrent.ExecutionException: org.teiid.client.xa.XATransactionException: TEIID30526 javax.transaction.InvalidTransactionException: No transaction found for client O/UWhntc4uA9.

      at org.teiid.client.util.ResultsFuture.convertResult(ResultsFuture.java:100) [teiid-client-8.4.0.Final.jar:8.4.0.Final]

      at org.teiid.client.util.ResultsFuture.get(ResultsFuture.java:95) [teiid-client-8.4.0.Final.jar:8.4.0.Final]

      at org.teiid.jdbc.ConnectionImpl.directCommit(ConnectionImpl.java:349) [teiid-client-8.4.0.Final.jar:8.4.0.Final]

      ... 67 more

      Caused by: org.teiid.client.xa.XATransactionException: TEIID30526 javax.transaction.InvalidTransactionException: No transaction found for client O/UWhntc4uA9.

      at org.teiid.dqp.internal.process.TransactionServerImpl.checkLocalTransactionState(TransactionServerImpl.java:388) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]

      at org.teiid.dqp.internal.process.TransactionServerImpl.commit(TransactionServerImpl.java:481) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_27]

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_27]

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_27]

      at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_27]

      at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.4.0.Final.jar:8.4.0.Final]

      at $Proxy18.commit(Unknown Source) at org.teiid.dqp.internal.process.DQPCore$3.call(DQPCore.java:695) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]

      at org.teiid.dqp.internal.process.DQPCore$3.call(DQPCore.java:692) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]

      at org.teiid.dqp.internal.process.DQPCore$7.run(DQPCore.java:760) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]

      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_27]

      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_27]

      at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_27]

      at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]

      at org.teiid.dqp.internal.process.DQPCore.addWork(DQPCore.java:768) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]

      at org.teiid.dqp.internal.process.DQPCore.commit(DQPCore.java:699) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_27]

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_27]

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_27]

      at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_27]

      at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.4.0.Final.jar:8.4.0.Final]

      at org.teiid.jboss.TransportService$3.invoke(TransportService.java:254) [teiid-jboss-integration-8.4.0.Final.jar:8.4.0.Final]

      at $Proxy19.commit(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_27]

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_27]

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_27]

      at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_27]

      at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:135) [teiid-runtime-8.4.0.Final.jar:8.4.0.Final]

      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_27]

      at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_27]

      at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]

      at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]

      at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:133) [teiid-runtime-8.4.0.Final.jar:8.4.0.Final]

      at $Proxy19.commit(Unknown Source) at org.teiid.jdbc.ConnectionImpl.directCommit(ConnectionImpl.java:348) [teiid-client-8.4.0.Final.jar:8.4.0.Final]

      ... 67 more

      Caused by: javax.transaction.InvalidTransactionException: No transaction found for client O/UWhntc4uA9.

      at org.teiid.dqp.internal.process.TransactionServerImpl.checkLocalTransactionState(TransactionServerImpl.java:385) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]

      ... 102 more