September 18, 2001 at 10:16 am
Q: Is there a maximum number of errors that DTC can handle before it throws the error: "Distributed transaction aborted by MSDTC"?
I have been given "rerunnable" code for a data migration by the developers and for the last 4 runs it has aborted at the same number of data errors being encountered. The abort is not being controlled by the code. Already checked that out.
Thanks -
Eric P. Melillo
Manager, Database Operations
Onvia
September 18, 2001 at 10:18 am
Sorry forgot to add the environment:
Controlling env for transaction:
SQL Server 7
Remote (insert) server
SQL Server 2000
September 18, 2001 at 3:39 pm
With a remote server you might be getting a timeout. I dont use DTC a lot, thought that most any error would cause the transaction to abort. You might try testing it without being in a transaction, see if you can see the error happen. What error message(s) are you getting?
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy