Share via

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,421 questions
0 comments
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

6 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. SChalakov 10,271 Reputation points MVP
    2022-01-14T08:51:41.687+00:00

    Hi Jan,

    I am also seen the same behaviour and I am not quite sure what it actually means. Will try to find some more information and post back here.

    If my reply was helpful please don't forget to upvote and/or accept as answer, thank you!
    Regards,
    Stoyan

    1 person found this answer helpful.
  2. Johan 6 Reputation points
    2022-01-18T09:35:21.603+00:00

    Got it to, but only on my SQL 2019 servers.

    I wonder if it because the new function 'Health Calculation Mode' override for space monitoring?

    1 person found this answer helpful.
  3. CyrAz 5,181 Reputation points
    2022-01-18T11:57:21.55+00:00

    That error comes from the following ConditionDetection module : https://systemcenter.wiki/?GetElement=Microsoft.SQLServer.Windows.ConditionDetection.MultiValueSpaceHealthCalculator&Type=ConditionDetectionModuleType&ManagementPack=Microsoft.SQLServer.Windows.Monitoring&Version=7.0.34.0
    It's used in two monitor types :
    https://systemcenter.wiki/?GetElement=Microsoft.SQLServer.Windows.MonitorType.Database.DBSize&Type=UnitMonitorType&ManagementPack=Microsoft.SQLServer.Windows.Monitoring&Version=7.0.34.0
    https://systemcenter.wiki/?GetElement=Microsoft.SQLServer.Windows.MonitorType.Database.TransactionLogSpaceFreePercent&Type=UnitMonitorType&ManagementPack=Microsoft.SQLServer.Windows.Monitoring&Version=7.0.34.0

    Basically, these monitor types are fetching the DB Size using this datasource : https://systemcenter.wiki/?GetElement=Microsoft.SQLServer.Windows.ProbeAction.DBSize&Type=ProbeActionModuleType&ManagementPack=Microsoft.SQLServer.Windows.Monitoring&Version=7.0.34.0
    And they output the result in a propertybag that is later interpretated by the ConditionDetection.

    In the error, we can see that the ConditionDetection has an issue because "MalformedDataItemException". Said otherwise, the Property Bag it receives from the datasource is somehow incorrect.
    You may have other errors showing that the datasource is failing, otherwise what you can do to get a better understanding of is going on is running a workflow trace : https://monitoringguys.com/2020/12/15/tracing-scom-workflows-with-powershell/

  4. Александр Гладченко 1 Reputation point
    2022-01-25T06:49:20.37+00:00

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

    0 comments