none
Communication with the underlying transaction manager has failed. RRS feed

  • Question

  • Message: HandlingInstanceID: bab4c129-7095-440a-b5db-bad4c5eebe0e

    An exception of type 'System.Transactions.TransactionManagerCommunicationException' occurred and was caught.

    ------------------------------------------------------------------------------------------------------------

    10/10/2017 07:11:15

    Type : System.Transactions.TransactionManagerCommunicationException, System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

    Message : Communication with the underlying transaction manager has failed.

    Source : System.Transactions

    Help link :

    Data : System.Collections.ListDictionaryInternal

    TargetSite : Void ProxyException(System.Runtime.InteropServices.COMException)

    HResult : -2146233087

    Stack Trace :    at System.Transactions.Oletx.OletxTransactionManager.ProxyException(COMException comException)

       at System.Transactions.Oletx.DtcTransactionManager.Initialize()

       at System.Transactions.Oletx.DtcTransactionManager.get_ProxyShimFactory()

       at System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropigationToken(Byte[] propagationToken)

       at System.Transactions.TransactionStatePSPEOperation.PSPEPromote(InternalTransaction tx)

       at System.Transactions.TransactionStateDelegatedBase.EnterState(InternalTransaction tx)

       at System.Transactions.EnlistableStates.Promote(InternalTransaction tx)

       at System.Transactions.Transaction.Promote()

       at System.Transactions.TransactionInterop.ConvertToOletxTransaction(Transaction transaction)

       at System.Transactions.TransactionInterop.GetExportCookie(Transaction transaction, Byte[] whereabouts)

       at System.Data.SqlClient.SqlInternalConnection.GetTransactionCookie(Transaction transaction, Byte[] whereAbouts)

       at System.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)

       at System.Data.SqlClient.SqlInternalConnection.Enlist(Transaction tx)

       at System.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction)

       at System.Data.ProviderBase.DbConnectionPool.PrepareConnection(DbConnection owningObject, DbConnectionInternal obj, Transaction transaction)

       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)

       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)

       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)

       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

       at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)

       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)

       at System.Data.SqlClient.SqlConnection.Open()

    Tuesday, October 10, 2017 8:42 AM

All replies

  • That can happen if the network loses connection with the database. Could be caused by any # of reasons including DTC not being properly configured, DTC failing the call, etc. This is most likely a configuration issue with DTC which should be posted in the SQL forums.

    This is all assuming that the connection string being used is correct of course.


    Michael Taylor http://www.michaeltaylorp3.net

    Tuesday, October 10, 2017 4:24 PM
    Moderator

  • Hi Jerald5588,

    thanks for posting here.

    According to the error you provided, We can not understand your problem clearly. Please include all necessary code snippets for anyone else to be able to reproduce your issue from scratch along with a detailed description about the results including any exception messages.

    Also, The Visual C# discuss and ask the C# programming language, IDE, libraries, samples and tools . If you have some issue with SQL Server. You can visit the SQL Server forum for getting suitable help.

     

    Your understanding and cooperation will be grateful.

    Best Regards,

    Yohann Lu


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, October 11, 2017 6:35 AM
    Moderator