ORA-00600 on TransactionScope.Dispose
Posted: 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:
As soon as we're calling the Dispose method of this transaction (without previously completing it), we got this exception
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
We got the same error even if we try to start another TransactionScope before our database request.
Thank you very much
Phil
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})
The stack trace looks like thatORA-00600: internal error code, arguments : [kpotxsking: branch], [0xC000000068672E60], [0xC000000067274BD0], [], [], [], [], []
Does anyone have an idea about this problem?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()
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
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.Transaction Scope Local=True
We got the same error even if we try to start another TransactionScope before our database request.
END EDITat 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)
Thank you very much
Phil