False error reporting when you execute the Test-SqlAvailabilityGroup cmdlet in SQL Server

Applies to: SQL Server 2017 DeveloperSQL Server 2017 EnterpriseSQL Server 2017 Enterprise Core

Symptoms


Assume that you use an AlwaysOn Availability Groups environment in Microsoft SQL Server 2016 or 2017. If you execute the Test-SqlAvailabilityGroup cmdlet (included in SQL Server) to monitor the health of the availability groups, you may receive false error reports in the XEvents that are generated by SQL Server. For example, you may see the following error reports:

XEvents error

Note This problem makes it difficult to find actual errors. This problem occurs most commonly when you use the System Center Operations Manager (SCOM) service to execute the Test-SqlAvailabilityGroup cmdlet.

Resolution


This problem is addressed in the following cumulative udpates for SQL Server:

Cumulative Update 6 for SQL Server 2017

Cumulative Update 5 for SQL Server 2016 SP2

After you apply this update, you can more easily find actual errors by executing the Test-SqlAvailabilityGroup cmdlet.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the standard terminology Microsoft uses to describe software updates.