The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction

Question

Post reply

The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction

Lavanyasri

SSCarpal Tunnel

Points: 4907
More actions
September 6, 2011 at 3:39 am

#244268

HI All,
I am getting the below error when i am running one application ,
The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.
I Checked the follwoing services :
services.msc -- distributed transaction coordinator is running
exec sp_configure : remote rpc transaction is configured to 1
componenet services : locat dtc --> trsaction time out is 120 [seconds]
Now the i have a question :::
1. componenet services : locat dtc -->security --> network DTC access is disabled
2. transaction manager -->inbound and out bound is disabled .
As per the below technet article , it advising to enable 1 and 2 points .
http://technet.microsoft.com/en-us/library/cc753510%28WS.10%29.aspx
Can you please advise me , is it compulsory to enable those two .if i enabled it will cause any issues .
Q2: local dtc-->transaction statistics -->active :6
max active :130
aggregated :
committed : 29839015
total :29860582
response time :
avg: 40 [milli sec]
maximum : 300016[milli sec]
I am not understanding about the above figures : what is it mean by ?
Thanks
Lavanya

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Lavanyasri SSCarpal Tunnel Points: 4907 More actions · Answer 1

Hi ,

Any one reply to my issue. its very urgent for me .

Lavanyasri SSCarpal Tunnel Points: 4907 More actions · Answer 2

HI Team ,

From the error log found the below ::

1.Distributed Transaction Coordinator service terminated unexpectedly

2.Enlist operation failed: 0x8004d01c(error not found). SQL Server could not register with Microsoft Distributed Transaction Coordinator (MS DTC) as a resource manager for this transaction. The transaction may have been stopped by the client or the resource manager.

3.The maximum number of active transactions that the MS DTC log file can accomodate has been exceeded. You must increase the size of the MS DTC log file if you wish to initiate more concurrent transactions.

Any suggestions on the above issues .

Thanks,

Lavanya

Devendra Shirbad SSC-Forever Points: 42493 More actions · Answer 3

Please follow the articles. (You didn't provide much information so I am putting all Articles that might be useful to you.)

Troubleshooting Problems with MSDTC

http://msdn.microsoft.com/en-us/library/aa561924(v=BTS.20).aspx

How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 cluster

http://support.microsoft.com/kb/301600

MS DTC Distributed Transactions

http://msdn.microsoft.com/en-us/library/ms191440.aspx

Recommended MSDTC settings for using Distributed Transactions in SQL Server

http://support.microsoft.com/kb/2027550

Lavanyasri SSCarpal Tunnel Points: 4907 More actions · Answer 4

Lavanyasri

SSCarpal Tunnel

Points: 4907

December 8, 2011 at 5:49 am

#1418623

HI dev,

which inputs you want from my side ??

Devendra Shirbad SSC-Forever Points: 42493 More actions · Answer 5

Before I ask anything related to issue, one general question...

You started this thread in 'Tuesday, September 06, 2011 4:09 PM'. Your issue is still unresolved? I believe it's not a priority issue. Or you resolved it & it reappeared?

Lavanyasri SSCarpal Tunnel Points: 4907 More actions · Answer 6

Dev (12/8/2011)
Before I ask anything related to issue, one general question...
You started this thread in 'Tuesday, September 06, 2011 4:09 PM'. Your issue is still unresolved? I believe it's not a priority issue. Or you resolved it & it reappeared?

HI Dev,

Thanks for the update .

In the month of sept the issue was resolved by restarting the SQL server .

The issue is happened again few days back .

Thanks

Lavanya

Devendra Shirbad SSC-Forever Points: 42493 More actions · Answer 7

Lavanyasri (12/8/2011)
Dev (12/8/2011)
Before I ask anything related to issue, one general question...
You started this thread in 'Tuesday, September 06, 2011 4:09 PM'. Your issue is still unresolved? I believe it's not a priority issue. Or you resolved it & it reappeared?
HI Dev,
Thanks for the update .
In the month of sept the issue was resolved by restarting the SQL server .
The issue is happened again few days back .
Thanks
Lavanya

So you know one solution at least... 🙂

OR work on following... That's precisely you need to do.

The maximum number of active transactions that the MS DTC log file can accomodate has been exceeded. You must increase the size of the MS DTC log file if you wish to initiate more concurrent transactions.

Lavanyasri SSCarpal Tunnel Points: 4907 More actions · Answer 8

HI dev,

The first solution is we changed to transaction timeout to '0'.

Recently i changed the log file size to 150 MB from default size .

Again we are seeing the same issue.

I want to know what are the possible reasons for this problem .

.

Devendra Shirbad SSC-Forever Points: 42493 More actions · Answer 9

Lavanyasri,

I am very much confused. In such a case I can’t debug the issue. Also, I am not sure if you have missed on any misc. setting that might be necessary for your case.

This is my best bet.

Event ID 4166 — Microsoft Distributed Transaction Coordinator Service Log Availability

http://technet.microsoft.com/en-us/library/dd300264(WS.10).aspx

If it doesn’t work, I suggest you to verify your MSDTC configuration with following very carefully...

•Enable Network Access Securely for MS DTC http://technet.microsoft.com/en-us/library/cc753620(WS.10).aspx

•Crosscheck Enable Network DTC Access http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx

•Restart the Server

And if you face same issue after restart please report it with error number.

Lavanyasri SSCarpal Tunnel Points: 4907 More actions · Answer 10

HI Dev,

I am providing the error no :

Error no : Message

Error: 8510, Severity: 20, State: 3.

Message

Enlist operation failed: 0x8004d01c(error not found). SQL Server could not register with Microsoft Distributed Transaction Coordinator (MS DTC) as a resource manager for this transaction. The transaction may have been stopped by the client or the resource manager.

Thanks ,

Lavanyasri SSCarpal Tunnel Points: 4907 More actions · Answer 11

HI ,

I found the below error from Windows lOg

The maximum number of active transactions that the MS DTC log file can accomodate has been exceeded. You must increase the size of the MS DTC log file if you wish to initiate more concurrrent transactions.

Devendra Shirbad SSC-Forever Points: 42493 More actions · Answer 12

Lavanyasri (12/12/2011)
HI ,
I found the below error from Windows lOg
The maximum number of active transactions that the MS DTC log file can accomodate has been exceeded. You must increase the size of the MS DTC log file if you wish to initiate more concurrrent transactions.

Have you gone through the first link I have provided to you? I guess NO.

If you by chance clicked it, Did you follow the steps? I guess NO.

Your Server is loaded (needs analysis) and to fix the issue you just follow what is suggested in the article and error message.

http://technet.microsoft.com/en-us/library/dd300264(WS.10).aspx

Lavanyasri SSCarpal Tunnel Points: 4907 More actions · Answer 13

HI Dev,

Is there any possibility to find the size of the MSDTC log file , how much free space is available ??

Can you please confirm once we restart the MSDTC ,the log file will be cleared ? The total free space is available ???

correct me if i am wrong ...

Thanks