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

    Transaction Cannote be resume

    venquet

      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

        • 1. Re: Transaction Cannote be resume
          marklittle

          Try upgrading to the latest version of JBossAS and JBossTS. Failing that, if it's really urgent then we offer professional support.

          • 2. Re: Transaction Cannote be resume
            venquet

            hi...recently we promoted to 4.2.2 from 4.0.2 after this migration only we started to get this error, did 4.2.2 supports other than Arjun Transaction API ? please advise, already our setup was inspected the environment by JBoss Redhat Professional support provider and based on his advise only we moved to 4.2.2. Please advise can we switch to anyother Trasaction API ? ??

            Thanks

            Rgds
            Balaji

            • 3. Re: Transaction Cannote be resume
              marklittle

              If you are using JBossAS then you are using the right (and only) API: the JTA.