locked
The operation is not valid for the state of the transaction. RRS feed

  • Question

  • I am getting this error very often in my production environment.

    .Net 3.5,SQL server 2012, MSDTC is turned on.

    Type : System.Transactions.TransactionException, System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
    Message : The operation is not valid for the state of the transaction.
    Source : System.Transactions
    Help link : 
    Data : System.Collections.ListDictionaryInternal
    TargetSite : Boolean EnlistPromotableSinglePhase(System.Transactions.InternalTransaction, System.Transactions.IPromotableSinglePhaseNotification, System.Transactions.Transaction)
    Stack Trace :    at System.Transactions.TransactionState.EnlistPromotableSinglePhase(InternalTransaction tx, IPromotableSinglePhaseNotification promotableSinglePhaseNotification, Transaction atomicTransaction)
       at System.Transactions.Transaction.EnlistPromotableSinglePhase(IPromotableSinglePhaseNotification promotableSinglePhaseNotification)
       at System.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)
       at System.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction)
       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open() at Dataacceslayer.executestoredProcudure


    Tuesday, June 9, 2015 1:39 AM

Answers