ORA-00600 on TransactionScope.Dispose

jesuissur · Post by **jesuissur** » Wed 11 May 2011 16:13

Hi,

We got a problem when using dotConnect with a connection string containing "Enlist=True" within a TransactionScope created like this:

Code: Select all

' VB.NET code
New TransactionScope(TransactionScopeOption.RequiresNew, New TransactionOptions With {.IsolationLevel = IsolationLevel.ReadCommitted})

As soon as we're calling the Dispose method of this transaction (without previously completing it), we got this exception

ORA-00600: internal error code, arguments : [kpotxsking: branch], [0xC000000068672E60], [0xC000000067274BD0], [], [], [], [], []

The stack trace looks like that

at Devart.Data.Oracle.a0.b(Int32 A_0)
at Devart.Data.Oracle.a5.d(Int32 A_0)
at Devart.Data.Oracle.a5.b(Boolean A_0)
at Devart.Data.Oracle.OracleInternalConnection.Rollback()
at Devart.Common.w.a(Enlistment A_0)
at System.Transactions.VolatileEnlistmentAborting.EnterState(InternalEnlistment enlistment)
at System.Transactions.VolatileEnlistmentActive.InternalAborted(InternalEnlistment enlistment)
at System.Transactions.TransactionStateAborted.EnterState(InternalTransaction tx)
at System.Transactions.TransactionStateActive.Rollback(InternalTransaction tx, Exception e)
at System.Transactions.Transaction.Rollback()
at System.Transactions.TransactionScope.InternalDispose()
at System.Transactions.TransactionScope.Dispose()

Does anyone have an idea about this problem?

We are using the realease "6.10.126 23-Mar-11" of dotConnect.

******** EDIT *******
We've been able to make it work by setting this in the connection string

Transaction Scope Local=True

But, as soon as we try to use our connection after the commit or rollback of a previous TransactionScope, we got the following error ORA-24324.
We got the same error even if we try to start another TransactionScope before our database request.

at Devart.Data.Oracle.a0.b(Int32 A_0)
at Devart.Data.Oracle.a2.d(Int32 A_0)
at Devart.Data.Oracle.a2.a(Int32 A_0, bk A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Devart.Data.Oracle.Entity.e.a(CommandBehavior A_0)
at Devart.Common.Entity.bb.b(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.e.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at HibernatingRhinos.Profiler.Appender.ProfiledDataAccess.ProfiledCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

END EDIT
Thank you very much
Phil

Shalex · Post by **Shalex** » Thu 12 May 2011 13:01

Please try using the latest (6.10.141 or 6.30.145 Beta) version of dotConnect for Oracle. If the problem persists, send us a small test project with the corresponding DDL/DML script to reproduce the issue in our environment. Notify us about the results.

jesuissur · Post by **jesuissur** » Thu 12 May 2011 13:07

Before upgrading, we'd like to know if you have any idea about when the 6.30 version will be officialy release?

Days, weeks, months?

We will try the latest and give you feedback on this.

Thank you

Shalex · Post by **Shalex** » Fri 13 May 2011 07:20

We are going to release dotConnect for Oracle v 6.30 next week. I will post here when the new version is available for download.

Shalex · Post by **Shalex** » Thu 19 May 2011 10:47

New version of dotConnect for Oracle v 6.30 is released!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .

For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=21027 .

jesuissur · Post by **jesuissur** » Thu 19 May 2011 15:20

It works fine.

Thank you