Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MSDTC exception

I got the following exception in my application once,

Unable to get the address of the distributed transaction coordinator for the server, from the server. Is DTC enabled on the server?

Now I need to catch and handle the exception, but not able to reproduce the exception. could any one provide me inputs on how to reproduce the exception or provide the exception type/error code.

Since I didn't get the exception log, I was not able to get the exception type/error code.

EDIT

I tried the following scenarios,

  1. Scenario - when the DTC service is stopped Error Message

    "MSDTC on server 'MyServ\SQL2005' is unavailable." -

  2. Scenario - When the network access is disabled for the DTC in DATABASE SERVER Error Message

    "The partner transaction manager has disabled its support for remote/network transactions."

  3. Scenario - When the network access is disabled for the DTC in the application server Error Message

    "The transaction manager has disabled its support for remote/network transactions."

  4. Also tried by stopping the netbios in app server/webserver, then i get the following error,

    The MSDTC transaction manager was unable to pull the transaction from the source transaction manager due to communication problems. Possible causes are: a firewall is present and it doesn't have an exception for the MSDTC process, the two machines cannot find each other by their NetBIOS names, or the support for network transactions is not enabled for one of the two transaction managers.

Also tried by Stoppin the SQL server and MSDTC services. And then started the SQL server before starting the MSDTC. But couldn't reproduce the error message I required.

like image 567
arun.v1 Avatar asked Mar 14 '13 13:03

arun.v1


1 Answers

This can happen if the IP address of the server gets renewed during the processing of a transaction.

It can also happen if the DTC service is started after the SQL service but you have tried that so i am assuming this is not the case.

Source: http://social.msdn.microsoft.com/Forums/en-US/windowstransactionsprogramming/thread/c13d076d-e20c-421c-821f-a26bbae97a6a/

like image 161
Yussuf Burke Avatar answered Sep 28 '22 06:09

Yussuf Burke