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
