question

snivas avatar image
0 Votes"
snivas asked AlexZhu-MSFT commented

An error occurred during discovery

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

msc-essentials
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlexZhu-MSFT avatar image
0 Votes"
AlexZhu-MSFT answered AlexZhu-MSFT commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

How's everything going? May we know the current status of the problem? Is there any other assistance we can provide?

Regards,

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

0 Votes 0 ·