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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » The Microsoft Distributed Transaction...

14 posts, Page 1 of 2

1 2 »»

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

Rate Topic

Display Mode

Topic Options

Author

Message

Lavanyasri

Posted Tuesday, September 06, 2011 3:39 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:28 AM
Points: 200, Visits: 746

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

Post #1170215

Lavanyasri

Posted Wednesday, September 07, 2011 3:35 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:28 AM
Points: 200, Visits: 746

Hi ,

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

Post #1170926

Lavanyasri

Posted Thursday, December 08, 2011 5:18 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:28 AM
Points: 200, Visits: 746

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

Post #1218543

Dev

Posted Thursday, December 08, 2011 5:31 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:05 PM
Points: 2,013, Visits: 1,566

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

~Dev~

Post #1218547

Lavanyasri

Posted Thursday, December 08, 2011 5:49 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:28 AM
Points: 200, Visits: 746

HI dev,

which inputs you want from my side ??

Post #1218557

Dev

Posted Thursday, December 08, 2011 5:56 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:05 PM
Points: 2,013, Visits: 1,566

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?

~Dev~

Post #1218562

Lavanyasri

Posted Thursday, December 08, 2011 6:11 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:28 AM
Points: 200, Visits: 746

Dev (12/8/2011)

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

Post #1218571

Dev

Posted Thursday, December 08, 2011 6:20 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:05 PM
Points: 2,013, Visits: 1,566

Lavanyasri (12/8/2011)

Dev (12/8/2011)

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... Smile

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.

~Dev~

Post #1218576

Lavanyasri

Posted Thursday, December 08, 2011 6:33 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:28 AM
Points: 200, Visits: 746

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 .

.

Post #1218586

Dev

Posted Friday, December 09, 2011 2:47 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:05 PM
Points: 2,013, Visits: 1,566

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.

~Dev~

Post #1219171

« Prev Topic | Next Topic »

14 posts, Page 1 of 2

1 2 »»

Permissions