3 Replies Latest reply on Mar 6, 2009 5:14 AM by Mark Little

    Transaction Cannote be resume

    Venkatesh Balaji Newbie

      Dear All,

      We are getting this error frequently with JBoss 4.2.2 (Arjun Transaction API enabled) with MS-SQL Server 2005, no clue why this error coming
      frequently, anybody faced such issues? and any configuration or setup need to be done? please advise.

      2009-03-05 06:02:37,515 ERROR [STDERR] com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:56000001f0.
      2009-03-05 06:02:37,515 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
      2009-03-05 06:02:37,515 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
      2009-03-05 06:02:37,515 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
      2009-03-05 06:02:37,515 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source)
      2009-03-05 06:02:37,515 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown Source)
      2009-03-05 06:02:37,515 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
      2009-03-05 06:02:37,515 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
      2009-03-05 06:02:37,515 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(Unknown Source)
      2009-03-05 06:02:37,515 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getMaxFieldSize(Unknown Source)
      2009-03-05 06:02:37,515 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.(CachedPreparedStatement.java:71)
      2009-03-05 06:02:37,515 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:338)
      2009-03-05 06:02:37,515 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187)


      Thanks in advance..its very urgent guys!

      Rgds
      Balaji