Unable to reconnect to disconnected sessions when using SQL Server 2016 SP2 or SQL Server 2017 in a in a SQL Server Availability Group

Unable to reconnect to disconnected sessions when using SQL Server 2016 SP2 or SQL Server 2017 in a in a SQL Server Availability Group

book

Article ID: CTX263433

calendar_today

Updated On:

Description

Unable to reconnect to a disconnected sessions

Environment

Citrix is not responsible for and does not endorse or accept any responsibility for the contents or your use of these third party Web sites. Citrix is providing these links to you only as a convenience, and the inclusion of any link does not imply endorsement by Citrix of the linked Web site. It is your responsibility to take precautions to ensure that whatever Web site you use is free of viruses or other harmful items.

Resolution

Applying the corresponding Microsoft Cumulative Update that includes the KB fix.
See the following MS Article: https://support.microsoft.com/en-us/help/4092554/errors-627-or-12324-occur-when-cross-database-transactions-are-promote
 

Problem Cause

To determine the issue Collect CDF traces from the Deliver Controller and you will find that the following happens. The VDA prepares a session in the Deliver Controller. But the prepared session fails with the following error “Cannot use SAVE TRANSACTION within a distributed transaction”. We will use the procedure BrokerSessionToSharedWorker2() to select a machine.