dotConnect Transaction problem with Oracle RAC

[kellyjcook]

We are getting an error running against an Oracle 11g RAC environment when NOT using direct mode.

Our environment is a 64-bit windows machine running a DotNet 2.0 console app. The oracle client is 11g (latest download) and the Devart version of dotConnect is also the latest release.

If I use direct mode with the following connection string it works perfectly:



This is basically doing direct mode to one node of the RAC cluster.

If I try and go through the Oracle client with this connection string:



I get the following error:

"The underlying provider failed on Commit." at System.Data.EntityClient.EntityTransaction.Commit()

[kellyjcook]

To update this with a further (and more troubling note) it appears that the records are being created on Oracle, so from the oracle driver/db side the transaction does not fail.

[Shalex]

Could you please post here innerException of the error you have mentioned? It should contain the details of the error.

[kellyjcook]

Message: Devart.Data.Oracle.OracleException - ORA-24776: cannot start a new transaction
Stack Trace: at Devart.Data.Oracle.an.b(Int32 A_0)
at Devart.Data.Oracle.at.a(Boolean A_0)
at Devart.Data.Oracle.OracleInternalConnection.Commit()
at Devart.Data.Oracle.OracleTransaction.Commit()
at System.Data.EntityClient.EntityTransaction.Commit(),

[Shalex]

Do you use TransactionScope when this error occurs?

[kellyjcook]

Yes.

using (TransactionScope _wellScope_ = new TransactionScope(TransactionScopeOption.Required, TimeSpan.MaxValue))
{

[Shalex]

The reason of the error can be the following: several transactions are opened for the same connection in several threads. Is it possible in your code?

[johoya]

I have the same problem. My web service may has several transactions are opened for the same connection in several threads.

dotConnect for Oracle version: 5.60.124

[Shalex]

Please avoid the situation when the same connection is used in several transactions.