SQL Server idle connection resiliency

  • Description

    The issue is applicable to solutions with AlwayOn configured for ProcessingEngine.Storage database.

    If manual failover (via SQL Management Studio) is performed during the time when the generating of small blobs is in process, the blobs might not be put to the database after the failover. In addition, the following exception might be thrown:

    System.Data.SqlClient.SqlException
    The connection was recovered and rowcount in the first query is not available. Please execute another query to get a valid rowcount.

    Refer to this article from Microsoft where this behavior is stated as expected and other error messages are described: Idle Connection Resiliency.

    The connection resiliency feature is supported on Microsoft Azure SQL Databases and SQL Server 2014 (and later versions).

Applies to:

CMS 9.1 Update-1+

May 29, 2019
May 29, 2019