Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Distributed transactions - Recovery related error

Author  Topic 

neville.sequeira
Starting Member

1 Post

Posted - 2013-07-29 : 22:43:40
First time trying out distributed transactions.
Any ideas about what might be causing this when I run a Java test case to test distributed transactions…

Caused by: javax.transaction.xa.XAException: The function RECOVER: failed. The status is: -3. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_recover, state=1, StatusCode:-3 (0xFFFFFFFD) ***"
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:550)
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.recover(SQLServerXAResource.java:728)
at bitronix.tm.recovery.RecoveryHelper.recover(RecoveryHelper.java:103)
at bitronix.tm.recovery.RecoveryHelper.recover(RecoveryHelper.java:61)
at bitronix.tm.recovery.IncrementalRecoverer.recover(IncrementalRecoverer.java:63)


I have followed the installations and configuration steps to the letter – to enable distributed transactions.

I do not see any transactions logged in the DTC in the control panel. Also do not see anything logged in the SQL Server log.

Thanks in advance.
-Neville
   

- Advertisement -