New Posts New Posts RSS Feed: TransactionInDoubtException
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

TransactionInDoubtException
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
mikke63 View Drop Down
Newbie
Newbie
Avatar

Joined: 01-Sep-2011
Location: Norway
Posts: 19 		Post Options Post Options   Quote mikke63 Quote  Post ReplyReply Direct Link To This Post Topic: TransactionInDoubtException
    Posted: 19-Oct-2012 at 4:22am
Platform: Win7, SL5, NET4.5, DF2012, Oracle
 
Simple case; one table, single column primary key. Execute entity query to select one record by PK. Then mark entity for deletion and call SaveChangesAsync. Failes with TransactionInDoubtException. Full exception dump below.
What I see from the exception dump is that System.Transactions.CommittableTransaction.Commit() has been called. The record is however not deleted in the database, bringing me to believe that the exception results from DF (EF) detecting that no record was removed and hence becomming in doubt.
 
With other entities in the same database I can delete records without problem.
 
Can this be the result of a failing concurrency detection? The entity record in question is not modified by others, so there is no actual concurrency problem.
 
Any ideas that can point me in the right direction?
 
Thanks, Mikael
 
 
IdeaBlade.EntityModel.EntityManagerSaveException was unhandled by user code
  Message=The transaction is in doubt.
  Cancelled=false
  RemoteExceptionDetails=System.Transactions.TransactionInDoubtException: The transaction is in doubt.
   at System.Transactions.TransactionStatePromotedIndoubt.PromotedTransactionOutcome(InternalTransaction tx)
   at System.Transactions.TransactionStatePromotedEnded.EndCommit(InternalTransaction tx)
   at System.Transactions.CommittableTransaction.Commit()
   at System.Transactions.TransactionScope.InternalDispose()
   at System.Transactions.TransactionScope.Dispose()
   at IdeaBlade.EntityModel.Server.EntitySaveTransactionManager.SaveWithTransaction(IEntityServer entityServer, SaveWorkState workState)
   at IdeaBlade.EntityModel.Server.EntitySaveTransactionManager.Save(IEntityServer entityServer, SaveWorkState workState)
   at IdeaBlade.EntityModel.Server.EntityServerSaveInterceptor.ExecuteSave()
   at IdeaBlade.EntityModel.Server.EntityServerSaveInterceptor.OnExecuteSave()
  RemoteExceptionName=System.Transactions.TransactionInDoubtException, System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
  RemoteSource=System.Transactions
  RemoteStackTrace=   at System.Transactions.TransactionStatePromotedIndoubt.PromotedTransactionOutcome(InternalTransaction tx)
   at System.Transactions.TransactionStatePromotedEnded.EndCommit(InternalTransaction tx)
   at System.Transactions.CommittableTransaction.Commit()
   at System.Transactions.TransactionScope.InternalDispose()
   at System.Transactions.TransactionScope.Dispose()
   at IdeaBlade.EntityModel.Server.EntitySaveTransactionManager.SaveWithTransaction(IEntityServer entityServer, SaveWorkState workState)
   at IdeaBlade.EntityModel.Server.EntitySaveTransactionManager.Save(IEntityServer entityServer, SaveWorkState workState)
   at IdeaBlade.EntityModel.Server.EntityServerSaveInterceptor.ExecuteSave()
   at IdeaBlade.EntityModel.Server.EntityServerSaveInterceptor.OnExecuteSave()
  StackTrace:
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccess(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
       at Parka.Controls.Customer.vmSelectedCustomer.<<get_CommandDeleteData>b__13>d__15.MoveNext()
  InnerException:
Back to Top
mgood View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 18-Nov-2010
Location: Emeryville, CA
Posts: 583 		Post Options Post Options   Quote mgood Quote  Post ReplyReply Direct Link To This Post Posted: 19-Oct-2012 at 10:47am
Mikael,
This exception comes from your Oracle database. There's something not quite right with your database. See the following link that explains when a transaction can come in doubt.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down