PC Review


Reply
Thread Tools Rate Thread

Transaction problems

 
 
4nd3r5@gmail.com
Guest
Posts: n/a
 
      29th May 2007
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/d...kInfoContainer

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

 
Reply With Quote
 
 
 
 
Smartkid
Guest
Posts: n/a
 
      30th May 2007
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.
}
}



<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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/d...kInfoContainer
>
> 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
>
>


 
Reply With Quote
 
 
 
 
4nd3r5@gmail.com
Guest
Posts: n/a
 
      31st May 2007
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.

On 30 Maj, 09:23, "Smartkid" <s...@hotmail.com> wrote:
> 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.
> }
>
> }
> <4nd...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
> > 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/d...D=5e325025-4dc...

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




 
Reply With Quote
 
4nd3r5@gmail.com
Guest
Posts: n/a
 
      31st May 2007
This seemed to be a timeout problem. That was wrongly reported by the
system.

On May 31, 9:48 am, "4nd...@gmail.com" <4nd...@gmail.com> wrote:
> 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.
>
> On 30 Maj, 09:23, "Smartkid" <s...@hotmail.com> wrote:
>
> > 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.
> > }

>
> > }
> > <4nd...@gmail.com> wrote in message

>
> >news:(E-Mail Removed)...

>
> > > 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/d...D=5e325025-4dc...

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



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Root transaction wanted to commit, but transaction aborted Vijay Anand Kannan Microsoft Dot NET Framework 1 12th Apr 2005 11:15 AM
"Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction." Ollie Riches Microsoft C# .NET 3 11th Mar 2005 06:23 PM
"Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction." Ollie Riches Microsoft ADO .NET 3 11th Mar 2005 06:23 PM
Root transaction wanted to commit, but transaction aborted =?Utf-8?B?S2FydW4gS2FydW5ha2FyYW4=?= Microsoft Dot NET Framework 2 23rd Jul 2004 07:33 PM
The root transaction wanted to commit, but transaction aborted Grober Microsoft ADO .NET 1 24th Nov 2003 03:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:00 AM.