Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction Expand / Collapse
Author
Message
Posted Tuesday, September 6, 2011 3:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 30, 2013 6:11 AM
Points: 204, Visits: 762
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
Posted Wednesday, September 7, 2011 3:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 30, 2013 6:11 AM
Points: 204, Visits: 762
Hi ,


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



Post #1170926
Posted Thursday, December 8, 2011 5:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 30, 2013 6:11 AM
Points: 204, Visits: 762
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
Posted Thursday, December 8, 2011 5:31 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 5:56 AM
Points: 2,013, Visits: 1,584
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

Devendra Shirbad | BIG Data Architect / DBA | Ex-Microsoft CSS (SQL 3T) | Open Network for Data Professionals...
LinkedIn: http://www.linkedin.com/in/devendrashirbad
Post #1218547
Posted Thursday, December 8, 2011 5:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 30, 2013 6:11 AM
Points: 204, Visits: 762
HI dev,

which inputs you want from my side ??


Post #1218557
Posted Thursday, December 8, 2011 5:56 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 5:56 AM
Points: 2,013, Visits: 1,584
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

Devendra Shirbad | BIG Data Architect / DBA | Ex-Microsoft CSS (SQL 3T) | Open Network for Data Professionals...
LinkedIn: http://www.linkedin.com/in/devendrashirbad
Post #1218562
Posted Thursday, December 8, 2011 6:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 30, 2013 6:11 AM
Points: 204, Visits: 762
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
Post #1218571
Posted Thursday, December 8, 2011 6:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 5:56 AM
Points: 2,013, Visits: 1,584
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.


Dev

Devendra Shirbad | BIG Data Architect / DBA | Ex-Microsoft CSS (SQL 3T) | Open Network for Data Professionals...
LinkedIn: http://www.linkedin.com/in/devendrashirbad
Post #1218576
Posted Thursday, December 8, 2011 6:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 30, 2013 6:11 AM
Points: 204, Visits: 762
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
Posted Friday, December 9, 2011 2:47 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 5:56 AM
Points: 2,013, Visits: 1,584
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

Devendra Shirbad | BIG Data Architect / DBA | Ex-Microsoft CSS (SQL 3T) | Open Network for Data Professionals...
LinkedIn: http://www.linkedin.com/in/devendrashirbad
Post #1219171
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse