Transaction problems

[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

 

[Smartkid]

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.
}
}

 

[4nd3r5]

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.

 

[4nd3r5]

This seemed to be a timeout problem. That was wrongly reported by the
system.