Transaction problems

  • Thread starter Thread starter 4nd3r5
  • Start date Start date
4

4nd3r5

Hi All

I've got a problem with some transactionhandling. I have a dual server
setup: one webserver and one databaseserver. Because of the dual
server setup i have configured MSDTC (distributed transaction
coordinator) for the transactions. I have tested the setup with
DTCPing successfully:
http://www.microsoft.com/downloads/...d549ac17644&DisplayLang=en#QuickInfoContainer

But i keep getting this error: "The transaction has already been
implicitly or explicitly committed or aborted."
I have tried googling it, but most solutions were about firewall
issues which i do not use here.

Any clues
/Anders, Denmark
 
Sounds like your code using a transaction after Dispose() or Complete()
called.
Be care of nested TransactionScope,:

using (TransactionScope txOuter = new TransactionScope()) {
using (TransactionScope txFirst = new TransactionScope()) {
//exit without call txFirst.Complete();
}

using (TransactionScope txSecond = new TransactionScope()) { //you
got exception here, as txOuter will be rollback.
}
}
 
I am using AutoComplete on my methods and TransactionOption.Required.
I don't think that is the problem.
Btw similar code is running on another server setup but this database
is 5 times bigger, and i may expect it is a timeout problem.
 
Back
Top