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