Root transaction wanted to commit, but transaction aborted

[Vijay Anand Kannan]

I am getting error Root transaction wanted to commit, but transaction
aborted.

This error mostly occurs only when Client,COM+,SQL Server is in the
same system.

Otherwise it seems working fine.

We tried all possibilities of Increasing the timeout ....

We have Transaction Required and use Autocomplte for each functions.

We call the DataAccess Class from this Transaction Class. There do we
perform Insert, update ...

If there is any error we throw the error back to the Transaction Class
where we catch.

Nothing more we do, still we get this error.

When SQL Server is in other system I don't have any problem

Our Architecture is Windows 2000 with SP4, .Net 2003, VB.Net with SQL
Server

I looked into lot of articles for the solution but nothing worked

Can someone please help us.

This is needed to be tested with this configuration of having the
Client,COM+,SQL Server in a same system.


I appreciate your help. Thanks in Advance


Thanks & Regards

Vijay Anand Kannan

 

[Dmytro Lapshyn [MVP]]

Hi,

This message usually indicates that a nested transaction voted for abortion
and you've attempted to commit the root transaction after that.
You might have connectivity problems to the SQL Server instance (which
network library you use BTW?), or the DB transaction might fail due to the
lack of resources. As you say the error goes away when you move the SQL
server to another machine, this is a very likely reason.

You can attach the SQL trace utility and see what happens on the DB level -
what you should be looking for is the real error failing the DB transaction.