Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction
-
Hi, I am getting this error. Please help me to find a resolution for this. This error has raised only once but again I am not able to reproduce it.
Any help well be really appreciated.
Server Error:
The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException: The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.]
Thanks,
Yashwanth
-
This was removed by the editor as SPAM
-
Hi
try to increase the transaction time out that you can find at component services
Steps
Go to Control Panel ->Administrative tool->Component Services
Expland Component Services
Again click on component services
you will see Computers Folder
expand that folder
Right click on "My Computer" ->Properties->Options Tab->Change the transaction time out
Thanks
/Satya
-
HI,
I am using the SQL server 2005. i am also getting the same error message while running the windows application. And i am the server part of the application.
I hope this will raise only if we are client users which may point out one common server.... and the solution that mentioned whether applicable for the windows application or not?
Please anyone help me out this and let me the know the reason for this because this is not happeing in the server machinmes ...
-
Dear all
Am also getting the same error and i even increased the timeout for the transaction. Still am stuck on this. Can any one provide me a solution on this.
-
Hi All,
Iam also getting the same error. But the strange thing is that for only one particular employeeid we are getting the error.
For all employeeid's(while generating the report) we are able to generate with out any constraints.
Is there anything need to be done so that the particular employeeid report could be generated.
Regards,
Sandhya
-
Below configuration changes on the SQL Server may fix the issue.
1.Execute the below
a.EXEC Sp_Configure
-In the result set, check for the config_value where name = remote proc trans, if this value is 0 then execute the below query(b.)
-Note: Remote proc trans option is to protect the actions of a server-to-server procedure through a Microsoft Distributed Transaction Coordinator (MS DTC) transaction. Set remote proc trans to 1 to provide a MS DTC-coordinated distributed transaction that protects the ACID (atomic, consistent, isolated, and durable) properties of transactions.
b.exec sp_configure 'remote proc trans','1'
reconfigure with override
2.Goto Windows Run->Services.msc and make sure that the service “Microsoft Distributed Transaction Coordinator” is started.
-
Hi all,
I have the same problem. I tried the sp_configure, but it didn’t work.
I have a SSIS package with IsolationLevel set to “ReadCommited” on all items. TransactionOption is always “Supported” unless on the package level itself where it is configured as “required”.
This works fine on all items except 3 very simple “Execute SQL Task” items. They only contain a simple delete statement:
Options TimeOut: 0
ResultSet: none
ConnectionType:OLE DB
SQLSourceType:Direct input
SQLStatement:DELETE FROM Prod.TypeProduit
IsQueryStoredProcedure:false
BypassPrepare:True
When I execute this, I alwas get the following errors:
Error: “DELETE FROM Prod.Tva” failed with the following error: “Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.” Possible failure reasons: Problems with the query, “ResultSet property not set correctly, parameters not set correctly, or connection not established correctly.
Followed by another but similar error:
Error: Executing the suery “DELETE FROM Prod.TypeProduit” failed with the following error: “The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction”. Possible reasons: Problems with the query, “ResultSet” property not set correctly, parameters not set correctly, or connection not established correctly.
I should also mention that when I execute the package in Visual Studio, everything works just fine. I only have this problem using DTEXEC or DTEXECUI.
Any ideas?
Thanks,
Jan
-
This works fine on all items except 3 very simple “Execute SQL Task” items. They only contain a simple delete statement:
The above may be the reason for your problem because Execute SQL Task is T-SQL code so an atomic unit of work Transaction which is different from SSIS transaction which are loosely coupled transactions that requires a resource manager which is MSDTC. You could resolve this by passing all transactions to the Execute SQL Task for resolution, however SSIS 2008 comes with better tools to resolve this nesting at the point of connection and related issues.
Read the first part of your error it explains all the valid reasons your code is failing.
Kind regards,
Gift Peddie
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply