"No transaction is active" error
bikhod
I am getting the above error in the following scenario: my
COM+ queued component is writing a large number of records
(5000 rows) to around 10 tables. Some times my
transaction aborts with the "No transaction is active"
error.
We initially thought this may be due to Oracle rollback
segment sizes but increasing those did not have any
effect - we still get the occassional failure.
Any other ideas / suggestions would be greatly appreciated.
Thanks
Bikhod
Ryan Lu [MSFT]
The error -2147168242 is 0x8004D00E (XACT_E_NOTRANSACTION, or the
transaction already completed or aborted). This will most likely happen
because the transaction timed out or completed/aborted, but the
application was still trying to enlist some database connections in that
transaction. Below are several methods which may help to solve the problem:
1. Increasing the DTC timeout. This will not help if your problem was due
to hang/deadlocks in your database.
2. Apply the latest version of Oracle patch and MDAC.
3. Perform the instructions in Q193893 step by step.
4. Try using OLEDB instead of ODBC
5. Check your application code and find out possible places which may cause
the problem. If your code path never hit BEGINTRAN but hit the COMMIT TRAN,
that would cause this problem.
6. Make sure both the client side and the server side DTC services are
running
7. If you are using a transactional component but the DTC transaction is
not necessary for your business, please diable the transaction settings of
your component and have another try.
8. Try to find possible clues in the event logs.
9. Following Q301293 and Q246006 to capture the trace/log files.
If you have reproduction code available, please post it here and I will
help to find out the root cause. If it is a production machine and it is
urgent, please contact your local PSS and open an incident to solve the
problem.
Additional Reference
===============
INFO: Using Oracle with Microsoft Transaction Server and COM+
http://support.microsoft.com/?id=193893
HOWTO: Enable MTXOCI.dll Tracing in Windows NT and Windows 2000
http://support.microsoft.com/?id=301293
INFO: Oracle TRC Files and MTS
http://support.microsoft.com/?id=246006
Best regards,
Ryan Lu
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.