Stack Overflow
Stack Overflow

Questions tagged [msdtc]

MSDTC is an acronym for Microsoft Distributed Transaction Coordinator.

MSDTC is an acronym for Microsoft Distributed Transaction Coordinator. As its name implies, MSDTC provides transaction coordination between multiple resources. e.g. databases, message queues, etc.

Frequent issues are around network configuration (e.g. firewall ports and RPC ports) as well as DTC failures around unwanted transaction promotion.

Resources

Distributed Transaction Coordinator(MSDTC) and Transaction FAQ

405 questions
9
votes
1 answer

NServiceBus and NHibernate - Message Handler and Transactions

From my understanding NServiceBus executes the Handle method of an IMessageHandler within a transaction, if an exception propagates out of this method, then NServiceBus will ensure the message is put back on the message queue (up X amount of times…
user53791
9
votes
3 answers

confusion about transactions and msdtc

I have some basic confusion about how transactions and msdtc work together. I have a basic server/client winforms app. The app uses transactionscope to encapsulate several sql commands that are executed on the sql server. The app seemed to work fine…
muhan
  • 2,537
  • 3
  • 29
  • 33
8
votes
2 answers

Dtcping test passes but still have a Communication with the underlying transaction manager has failed

DTCPing tool says everything should be fine. The actual exception is: System.Transactions.TransactionManagerCommunicationException: Communication with the underlying transaction manager has failed. ---> …
Kimi
  • 13,621
  • 9
  • 55
  • 84
8
votes
1 answer

How to detect that rollback has occurred?

I'm hunting down a bug in a large business application, where business processes are failing but partially persisted to the database. To make things harder to figure out, the process fails only once every few weeks, with hundreds of thousands…
stalskal
  • 1,181
  • 1
  • 8
  • 16
8
votes
3 answers

Msg 7391: linked server unable to begin a distributed transaction (both svrs running locally)

I setup a LinkedServer from SqlServer 2014 to MySQL 5.7.3 running on my Win 10 PC. Both select & insert queries work fine alone via openquery, but the insert query won't function in a trigger. Please don't mark this as a duplicate unless you find…
DeannaD
  • 1,469
  • 2
  • 16
  • 27
8
votes
3 answers

How to determine why a distributed transaction is timing out

I am using LINQ to SQL and a third party SDK that supports distributed transactions. When I realize that a pending update will be updating both SQL records and records in the third party SDK, I am creating a TransactionScope with a 0 (presumably…
BlueMonkMN
  • 25,079
  • 9
  • 80
  • 146
8
votes
3 answers

.NET: how to disable promotion in System.Transactions?

Is it possible to use the System.Transactions programming model without support for distributed transactions? something like TransactionConfig.DisablePromotion = true;
andreas
  • 888
  • 1
  • 10
  • 17
7
votes
4 answers

MSDTC: Communication with the underlying transaction manager has failed

I have a WinForms / WCF / SQLServer app where I am trying to use MSDTC transactions like this: using System.Transactions; // ... var transOptions = new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted, …
JoelFan
  • 37,465
  • 35
  • 132
  • 205
7
votes
1 answer

Azure failed to marshal transaction into propagation token for elastic transaction (Works for MSDTC)

In windows azure we have hosted two asp.net webapi project as app service. We need to enable distributed transaction here. We initiate transaction inside one api. Then inside that transaction scope we fetch propagation token of that transaction and…
Anup
  • 1,502
  • 2
  • 15
  • 31
7
votes
3 answers

MSMQ messages bound for clustered MSMQ instance get stuck in outgoing queues

We have clustered MSMQ for a set of NServiceBus services, and everything runs great until it doesn't. Outgoing queues on one server start filling up, and pretty soon the whole system is hung. More details: We have a clustered MSMQ between servers…
David Boike
  • 18,545
  • 7
  • 59
  • 94
7
votes
1 answer

How do distributed transactions behave with multiple connections to the same DB in a threaded environment?

I’m trying to determine the behaviour of multiple database connection in a distributed transaction. I’ve got a long running process which spawns a series of threads and each thread is then responsible for managing its’ DB connections and such. All…
Middletone
  • 4,190
  • 12
  • 53
  • 74
7
votes
1 answer

Determine whether the transaction is DTC transaction or not when debugging

In .Net, is there any way to determine whether the ambient transaction is DTC transaction or not when debugging. I investigated SqlConnection class members but I found nothing. thanks.
mkus
  • 3,357
  • 6
  • 37
  • 45
7
votes
2 answers

SQL Server and WCF Transactions across Linked Oracle Servers

Note Please see Update 6. It has a simple app that demonstrates how to recreate the problem. I'm living a DTC nightmare... Our setup is that we have two databases; a SQL Server 2008 database and an Oracle database (11g, I believe). I've got the…
Pete
  • 6,585
  • 5
  • 43
  • 69
7
votes
2 answers

What's the difference between DTCPing and DTCTester?

I've used DTCTester before to diagnose MSDTC problems. However, I just noticed DTCPing seems to do about the same thing. What's the difference between these two? From what I can tell so far, DTCPing needs to run on both client and server machines,…
Esteban Araya
  • 29,284
  • 24
  • 107
  • 141
7
votes
1 answer

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…
arun.v1
  • 462
  • 1
  • 4
  • 12
1 2
3
…
26 27