SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Lavanyasri
Lavanyasri
SSC-Addicted
SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)

Group: General Forum Members
Points: 423 Visits: 943
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
Lavanyasri
Lavanyasri
SSC-Addicted
SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)

Group: General Forum Members
Points: 423 Visits: 943
Hi ,


Any one reply to my issue. its very urgent for me .
Lavanyasri
Lavanyasri
SSC-Addicted
SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)

Group: General Forum Members
Points: 423 Visits: 943
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
Dev
Dev
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3486 Visits: 1602
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
Lavanyasri
SSC-Addicted
SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)

Group: General Forum Members
Points: 423 Visits: 943
HI dev,

which inputs you want from my side ??
Dev
Dev
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3486 Visits: 1602
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
Lavanyasri
SSC-Addicted
SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)

Group: General Forum Members
Points: 423 Visits: 943
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
Dev
Dev
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3486 Visits: 1602
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
Lavanyasri
SSC-Addicted
SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)

Group: General Forum Members
Points: 423 Visits: 943
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 .

.
Dev
Dev
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3486 Visits: 1602
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search