ORA-00600 on TransactionScope.Dispose

ORA-00600 on TransactionScope.Dispose

Postby 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
jesuissur
 
Posts: 12
Joined: Wed 13 Oct 2010 14:28

Postby 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.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Postby 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
jesuissur
 
Posts: 12
Joined: Wed 13 Oct 2010 14:28

Postby 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
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Postby 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 .
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Postby jesuissur » Thu 19 May 2011 15:20

It works fine.

Thank you
jesuissur
 
Posts: 12
Joined: Wed 13 Oct 2010 14:28


Return to dotConnect for Oracle