I'm having problems with EnterpriseServices transactions running
against Oracle 9iR2.
I am inconsistently getting Oracle ORA-24761: Transaction Rolled Back
results mid-transaction. If I start the transaction and run it against
an object it might fail. If I rerun the same transaction again it
might work. But on trying again it might fail.
If I disable transactions <Transaction(TransactionOption.Disabled)>
the app runs and all the data is processed correctly. I have confirmed
that the basic selects, inserts and updates all run successfully
without transactions.
I have a small test app I used to confirm that all the components are
setup to run transactions; I can test failure and commit on success
and that works. But when running the full application I am developing
it is just plain inconsistent.
Environment:
WinXPPro
VS.Net 2003
Oracle 9iR2 patched to 9.2.0.4 plus OraMTS configured.
Oracle version of the DAAB patched to fix output parameter problems
Questions:
1. Is anyone else out there running this configuration successfully?
2. Is anyone else running a configuration near to this?
3. Any suggestions on where to look within the oracle world to
determine the root cause of the transaction rollback that Oracle is
issuing?
4. Anyone experiencing problems running transactions in Debug mode vs
Release?
Thanks for the help
Rick
