none
Intermittent MSDTC (ENTSSO) issues RRS feed

  • Question

  • Hi All,

    we are running into the following issues intermittently, we have validated that both the BTS and SQL server msdtc setting are correct based on the documentation from MS. these happen on the cold nodes, once we refresh the admin console continuously for 2 to 3 times, the issues go away.

    Environment , 

    1) BTS 2016 

    2) SQL 2016 SP2 Availability group

    1) An error occurred while attempting to access the SSO database. Function: LookupXp File: lookupserver.cpp:296 System.Transactions : Communication with the underlying transaction manager has failed.. SQL Error code: 0xE2E2E2E2 Error code: 0xC0002A21, An error occurred while attempting to access the SSO database.

    2) Could not import a DTC transaction. Please check that MSDTC is configured correctly for remote operation. See documentation for details. Error Code: 0x8004D00E, The transaction has already been implicitly or explicitly committed or aborted

    3) Error Code: 0xC0002A24, Could not import a DTC transaction. Please check that MSDTC is configured correctly for remote operation. See documentation for details.

    Thanks 

    Madhu


    • Edited by MadhukarG Thursday, August 8, 2019 1:44 PM
    Thursday, August 8, 2019 1:34 PM

All replies

  • Can you restart the Enterprise Single Sign-On Service and see if it fix the issue ?

    It looks like a SQL database issue. Please check the SQL utilization on the server where the SSO DB is located?

    Monday, August 19, 2019 4:51 AM