SQL server MP Bug

Jan Pettersson 26 Reputation points
2022-01-13T09:09:44.157+00:00

After installing the latest SQL MP i started getting these alerts from all my SQL servers.

I guess the main error is this:
Exception Type: System.FormatException
Message: Input string was not in a correct format.

Management Group: -
Module: Microsoft.SQLServer.Core.Module.Helper.ScomModules.Monitoring.MultiValueSpaceHealthCalculator
Version: 7.0.34.0

Error(s) was(were) occurred:
Exception Type: Microsoft.EnterpriseManagement.HealthService.MalformedDataItemException
Message: Exception has been thrown by the target of an invocation.
Source: Microsoft.Mom.Modules.DataTypes

Exception Type: System.Reflection.TargetInvocationException
Message: Exception has been thrown by the target of an invocation.
Source: mscorlib
Stack Trace:
Exception Type: System.FormatException
Message: Input string was not in a correct format.
Source: mscorlib

State:
The configuration properties are:
ManagementGroupName = -
Publisher = SQLMonitoringWindows
HealthCalcMode = 1
StateType = TwoState
Threshold11 = 10
Threshold12 = 0
Threshold21 = 5000
Threshold22 = 0
TimeoutSeconds = 300
Value1Name = DBLogFreeSpacePercent
Value1StateDirection = BadLessT1
Value2Name = DBLogFreeSpaceMB
Value2StateDirection = BadLessT1

---------- Exception: ----------
Exception Type: Microsoft.EnterpriseManagement.HealthService.MalformedDataItemException
Message: Exception has been thrown by the target of an invocation.
Source: Microsoft.Mom.Modules.DataTypes
Stack Trace:

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,417 questions
0 comments No comments
{count} vote

Accepted answer
  1. Dmitry Kalashnikov 86 Reputation points
    2022-02-22T11:50:52.13+00:00

    Hi everyone!

    We've released a production-ready version of the SQL Server MP with the mentioned bug fix. You can read about this release in the blog post here, and download the release here.
    Thank you for your feedback, we always appreciate it!

    1 person found this answer helpful.
    0 comments No comments

6 additional answers

Sort by: Most helpful
  1. 2022-01-25T06:49:20.37+00:00

    Такая же ошибка: SCOM 1801, SQL Server 2012

    0 comments No comments

  2. 2022-01-25T06:53:54.227+00:00

    168169-image.png

    0 comments No comments