An error occurred during discovery

Sreenivasarao Ponguru 21 Reputation points
2021-09-30T14:11:45.75+00:00

Hi All,

We have SQL Server and we added to SCOM and it is showing below Error showing up in Active critical Alerts , What could be the Reason ? is there any thing we are missing here ?

Management Group: "MyGroup"
Module: Microsoft.SQLServer.Windows.Module.Discovery.Discoveries.LocalDBEngineDiscovery
Version: 7.0.32.0

Error(s) was(were) occurred:
Message: An error occurred during discovery.

---------- Exception: ----------
Exception Type: System.Exception
Message: Unable to execute query 'SELECT ServiceName, PropertyName, PropertyNumValue, PropertyStrValue FROM SqlServiceAdvancedProperty WHERE (PropertyName = 'ISWOW64' OR PropertyName = 'LANGUAGE' OR PropertyName = 'INSTANCEID' OR PropertyName = 'SPLEVEL' OR PropertyName = 'INSTALLPATH' OR PropertyName = 'ERRORREPORTING') AND SqlServiceType = 1' for the path '\MyServer123.group.com\root\Microsoft\SqlServer\ComputerManagement13'. 32 bit: False. Error code: -2147217392. Error message: Invalid class
Source: Microsoft.SQLServer.Module4.Helper

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
841 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AlexZhu-MSFT 5,551 Reputation points Microsoft Vendor
    2021-10-01T00:57:24.307+00:00

    Hi,

    From the desciption, it seems the target class doesn't exist in the server, try to reimport the SQL .mof files to see if it helps.
    mofcomp "%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof"

    I would also strongly advise you to take a backup or a snapshot before re-importing the .mof file.

    Alex
    If the response is helpful, please click "Accept Answer" and upvote it.