0 Replies Latest reply on Feb 26, 2009 8:12 AM by ganapathi sundaram

    The server failed to resume the transaction

    ganapathi sundaram Newbie

      Hi All,

      We did not have any Transaction Failure Exception when we used JBoss 4.0.2 AS before.It was working fine.

      We have upgraded the JBoss server from 4.0.2 to 4.2.2.

      Now, I am getting Transaction Failure Error often in my JBoss 4.2.2 AS.

      Could you please anyone help me out from the below Transation Error , as well tell me reason why this is happening often ..?

      Expecting reply soon.

      Thanks in Advance.

      2009-02-24 17:46:59,836 INFO [STDOUT] --@I-- location=T0141
      2009-02-24 17:46:59,883 INFO [STDOUT]
      --@I-- Exception when saveInvoiceByCustomer method called
      2009-02-24 17:46:59,883 ERROR [STDERR] com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:930000018e.
      2009-02-24 17:46:59,883 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
      2009-02-24 17:46:59,883 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
      2009-02-24 17:46:59,883 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
      2009-02-24 17:46:59,883 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source)
      2009-02-24 17:46:59,883 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown Source)
      2009-02-24 17:46:59,883 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
      2009-02-24 17:46:59,883 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
      2009-02-24 17:46:59,883 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(Unknown Source)
      2009-02-24 17:46:59,883 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getMaxFieldSize(Unknown Source)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.<init>(CachedPreparedStatement.java:71)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:338)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187)
      2009-02-24 17:46:59,883 ERROR [STDERR] at lrp.arp.exportinvoice.bean.ExpInvBean.saveInvoiceByCustomer(ExpInvBean.java:1242)
      2009-02-24 17:46:59,883 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2009-02-24 17:46:59,883 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      2009-02-24 17:46:59,883 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2009-02-24 17:46:59,883 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:960)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
      2009-02-24 17:46:59,883 ERROR [STDERR] at $Proxy1944.saveInvoiceByCustomer(Unknown Source)
      2009-02-24 17:46:59,883 ERROR [STDERR] at lrp.arp.exportinvoice.ExpInvServlet.saveByCustomerServlet(ExpInvServlet.java:156)
      2009-02-24 17:46:59,883 ERROR [STDERR] at lrp.arp.exportinvoice.ExpInvServlet.processRequest(ExpInvServlet.java:61)
      2009-02-24 17:46:59,883 ERROR [STDERR] at lrp.arp.exportinvoice.ExpInvServlet.doPost(ExpInvServlet.java:333)
      2009-02-24 17:46:59,883 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      2009-02-24 17:46:59,883 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:437)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:381)
      2009-02-24 17:46:59,883 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      2009-02-24 17:46:59,883 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
      2009-02-24 17:46:59,883 INFO [STDOUT] After the bean method
      2009-02-24 17:46:59,883 INFO [STDOUT] Successfully Sent
      2009-02-24 17:46:59,883 INFO [STDOUT] --@I-- output Object = [[B@430266c9, 190]
      2009-02-24 17:47:00,539 INFO [STDOUT] Type is getSettingsValue
      2009-02-24 17:47:00,539 INFO [STDOUT] getSettingsValue method called.....
      2009-02-24 17:47:00,539 INFO [STDOUT] Exception raised in getAllSupportedVersions() :com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:930000018e.
      2009-02-24 17:47:00,539 ERROR [STDERR] com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:930000018e.
      2009-02-24 17:47:00,539 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
      2009-02-24 17:47:00,539 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
      2009-02-24 17:47:00,539 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source)
      2009-02-24 17:47:00,539 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
      2009-02-24 17:47:00,539 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source)
      2009-02-24 17:47:00,539 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
      2009-02-24 17:47:00,539 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
      2009-02-24 17:47:00,539 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:90)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
      2009-02-24 17:47:00,539 ERROR [STDERR] at main.bean.MenuBean.getSettingsValue(MenuBean.java:1115)
      2009-02-24 17:47:00,539 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor294.invoke(Unknown Source)
      2009-02-24 17:47:00,539 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2009-02-24 17:47:00,539 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
      2009-02-24 17:47:00,539 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:960)
      2009-02-24 17:47:00,555 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source)
      2009-02-24 17:47:00,555 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2009-02-24 17:47:00,555 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
      2009-02-24 17:47:00,555 ERROR [STDERR] at $Proxy2494.getSettingsValue(Unknown Source)
      2009-02-24 17:47:00,555 ERROR [STDERR] at main.web.MenuServlet.getSettingsValue(MenuServlet.java:134)
      2009-02-24 17:47:00,555 ERROR [STDERR] at main.web.MenuServlet.processRequest(MenuServlet.java:55)
      2009-02-24 17:47:00,555 ERROR [STDERR] at main.web.MenuServlet.doPost(MenuServlet.java:306)
      2009-02-24 17:47:00,555 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      2009-02-24 17:47:00,555 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2009-02-24 17:47:00,555 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      


      Regards,
      Ganapathi sundaram.G