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