The root transaction wanted to commit, but transaction aborted

[DaisyUSer]

In our application we are getting an error as
described below:

Error No: 8004e002
Error Message: "The root transaction wanted to commit, but transaction aborted"

This error comes randomly and is not logged in either
the database or the application error logs.

Our system architecture is a windows 2000.. ASP as
the front end , business logic in VB COM and Oracle 9i
as the database. ASP and VB COM are on IIS and
the database is on a separate physical box.

We are using ADO and OLEDB provider for
Oracle.(MSDAORA.1). There are some SP's and also DB
triggers for added functionality.

Now the VB Code is as follows:

We have a common component for data access (Say
Component B)
Also, For all other business logic there are several
components for different modules.(say component A).

Component A "Requires new Tx" while Component B "Uses
Tx". They run under COM+.

Component B (common data access component) does the
select, insert, update, delete and is called by
Component A to do all the data access. In some cases compinent A calls component B multiple time in the same transaction.

The "setAbort" and "setcomplete" are in component
A (calling component) only.

I have no clue why this error comes because if the same transaction with the same data is tried again. It works !!!

I truely appreciate any help anyone can provide in this case.

Regards
Santosh

[DaisyUSer]

okay ...

now it seems we have found a solution. The problem does not seem to be with the the VB COm code ... there need to be some settings done on ORACLE database for setting up MTS/COM+. Please refer to the article

http://support.microsoft.com/support/complus/mtsandoracle.asp?&SD=GN&LN=EN-US&gssnb=1

to setup the ORACLE changes. Specifically, the OARCLE variable settings and the two views v$xatransa$ and dba_pending_transaction need to be present/created and select grants for public should be granted on them.

We havent seen the error for the past 4 days !!! Hope this must have fixed it.


However, I truely appreciate the time and effort you have spent to help me resolve the issue.

Thanks and Regards
Santosh.:)