This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I consistently get this alert on many, but not all of my SQL Servers. I cannot figure out why this is happening. Please Assist. This rule is from the "Microsoft SQL Server on Windows (Discovery)" v 7.0.20.0 MP.
Alert Description
Management Group: "xxxxxxx"
Module: Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride
Version: 7.0.20.0
Error(s) was(were) occurred:
Message:
----------
Exception: ----------
Exception Type: Microsoft.EnterpriseManagement.ContainerException
Message: The container could not find a component with name 'ExtensionManagement' compatible with type 'Microsoft.EnterpriseManagement.Configuration.IExtensionManagement, Microsoft.EnterpriseManagement.Core, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.
Source: Microsoft.EnterpriseManagement.Core
Stack Trace:
at Microsoft.EnterpriseManagement.Container.GetServiceT
at Microsoft.EnterpriseManagement.Configuration.Verification.VerifyManagementPackElementName.GetExtensions()
at Microsoft.EnterpriseManagement.Configuration.Verification.VerifyManagementPackElementName.Verify(ManagementPack mp)
at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.CheckPrerequisite(Boolean verifyFragment)
at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.Verify(Boolean isUpdate, Boolean throwError)
at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.VerifyMP(ManagementPack mp, Boolean isUpdate, Boolean throwError)
at Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride.ModifyOrCreateOverride(OverrideSettings settings)
at Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride.<GetModuleDataAsync>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.SQLServer.Module.Helper.Base.ModuleBasePropertyHelper`1.<GetOutputDataAsync>d__13.MoveNext()
State:
The configuration properties are:
ManagementGroupName = ACSCOM-TEST
Publisher = SQLDiscoveryWindows
Enforced = null
ManagementServerName = null
OverrideCategory = Configuration
OverrideDisplayName = Disable discovery of selected DB Engines
OverrideManagementPackDisplayName = null
OverrideManagementPackName = null
OverrideName = Microsoft.SQLServer.Windows.DiscoveryOverride.LocalDBEngineDiscovery
OverrideValue = $Data//Property[@DeezNutz ='VersionList']$
TargetElementId = {BB187D3C-1218-6F43-B6F6-0A0695B96BD7}
TargetModuleName = DS
TargetParameterName = ExcludedVersions
TimeoutSeconds = 300
Error(s):
----------
Exception: ----------
Exception Type: Microsoft.EnterpriseManagement.ContainerException
Message: The container could not find a component with name 'ExtensionManagement' compatible with type 'Microsoft.EnterpriseManagement.Configuration.IExtensionManagement, Microsoft.EnterpriseManagement.Core, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.
Source: Microsoft.EnterpriseManagement.Core
Stack Trace:
at Microsoft.EnterpriseManagement.Container.GetServiceT
at Microsoft.EnterpriseManagement.Configuration.Verification.VerifyManagementPackElementName.GetExtensions()
at Microsoft.EnterpriseManagement.Configuration.Verification.VerifyManagementPackElementName.Verify(ManagementPack mp)
at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.CheckPrerequisite(Boolean verifyFragment)
at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.Verify(Boolean isUpdate, Boolean throwError)
at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.VerifyMP(ManagementPack mp, Boolean isUpdate, Boolean throwError)
at Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride.ModifyOrCreateOverride(OverrideSettings settings)
at Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride.<GetModuleDataAsync>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.SQLServer.Module.Helper.Base.ModuleBasePropertyHelper`1.<GetOutputDataAsync>d__13.MoveNext()
I know it's ugly, but here is the alert context for more detail:
Date and Time: 9/15/2020 8:36:49 AM
Log Name: Operations Manager
Source: SQL Server Discovery MP Windows
Event Number: 4221
Level: 1
Logging Computer: T000000SCOM0T02.TAMCENTRAL.ASP
User: N/A
Description:
Management Group: "ACSCOM-TEST" Module: Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride Version: 7.0.20.0 Error(s) was(were) occurred: Message: ---------- Exception: ---------- Exception Type: Microsoft.EnterpriseManagement.ContainerException Message: The container could not find a component with name 'ExtensionManagement' compatible with type 'Microsoft.EnterpriseManagement.Configuration.IExtensionManagement, Microsoft.EnterpriseManagement.Core, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. Source: Microsoft.EnterpriseManagement.Core Stack Trace: at Microsoft.EnterpriseManagement.Container.GetServiceT at Microsoft.EnterpriseManagement.Configuration.Verification.VerifyManagementPackElementName.GetExtensions() at Microsoft.EnterpriseManagement.Configuration.Verification.VerifyManagementPackElementName.Verify(ManagementPack mp) at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.CheckPrerequisite(Boolean verifyFragment) at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.Verify(Boolean isUpdate, Boolean throwError) at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.VerifyMP(ManagementPack mp, Boolean isUpdate, Boolean throwError) at Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride.ModifyOrCreateOverride(OverrideSettings settings) at Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride.<GetModuleDataAsync>d__15.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.SQLServer.Module.Helper.Base.ModuleBasePropertyHelper1.<GetOutputDataAsync>d__13.MoveNext() State: The configuration properties are: ManagementGroupName = ACSCOM-TEST Publisher = SQLDiscoveryWindows Enforced = null ManagementServerName = null OverrideCategory = Configuration OverrideDisplayName = Disable discovery of selected DB Engines OverrideManagementPackDisplayName = null OverrideManagementPackName = null OverrideName = Microsoft.SQLServer.Windows.DiscoveryOverride.LocalDBEngineDiscovery OverrideValue = $Data//Property[@Name='VersionList']$ TargetElementId = {BB187D3C-1218-6F43-B6F6-0A0695B96BD7} TargetModuleName = DS TargetParameterName = ExcludedVersions TimeoutSeconds = 300 Error(s): ---------- Exception: ---------- Exception Type: Microsoft.EnterpriseManagement.ContainerException Message: The container could not find a component with name 'ExtensionManagement' compatible with type 'Microsoft.EnterpriseManagement.Configuration.IExtensionManagement, Microsoft.EnterpriseManagement.Core, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. Source: Microsoft.EnterpriseManagement.Core Stack Trace: at Microsoft.EnterpriseManagement.Container.GetService[T](String name) at Microsoft.EnterpriseManagement.Configuration.Verification.VerifyManagementPackElementName.GetExtensions() at Microsoft.EnterpriseManagement.Configuration.Verification.VerifyManagementPackElementName.Verify(ManagementPack mp) at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.CheckPrerequisite(Boolean verifyFragment) at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.Verify(Boolean isUpdate, Boolean throwError) at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.VerifyMP(ManagementPack mp, Boolean isUpdate, Boolean throwError) at Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride.ModifyOrCreateOverride(OverrideSettings settings) at Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride.<GetModuleDataAsync>d__15.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.SQLServer.Module.Helper.Base.ModuleBasePropertyHelper1.<GetOutputDataAsync>d__13.MoveNext()
Event Data:
< DataItem type =" System.XmlData " time =" 2020-09-15T08:36:49.1991622-04:00 " sourceHealthServiceId =" 20F6CC9C-7640-0833-3F24-69F9EA4EBF60 " >
< EventData >
< Data > Management Group: "ACSCOM-TEST" Module: Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride Version: 7.0.20.0 Error(s) was(were) occurred: Message: ---------- Exception: ---------- Exception Type: Microsoft.EnterpriseManagement.ContainerException Message: The container could not find a component with name 'ExtensionManagement' compatible with type 'Microsoft.EnterpriseManagement.Configuration.IExtensionManagement, Microsoft.EnterpriseManagement.Core, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. Source: Microsoft.EnterpriseManagement.Core Stack Trace: at Microsoft.EnterpriseManagement.Container.GetServiceT at Microsoft.EnterpriseManagement.Configuration.Verification.VerifyManagementPackElementName.GetExtensions() at Microsoft.EnterpriseManagement.Configuration.Verification.VerifyManagementPackElementName.Verify(ManagementPack mp) at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.CheckPrerequisite(Boolean verifyFragment) at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.Verify(Boolean isUpdate, Boolean throwError) at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.VerifyMP(ManagementPack mp, Boolean isUpdate, Boolean throwError) at Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride.ModifyOrCreateOverride(OverrideSettings settings) at Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride.<GetModuleDataAsync>d__15.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.SQLServer.Module.Helper.Base.ModuleBasePropertyHelper1.<GetOutputDataAsync>d__13.MoveNext() State: The configuration properties are: ManagementGroupName = ACSCOM-TEST Publisher = SQLDiscoveryWindows Enforced = null ManagementServerName = null OverrideCategory = Configuration OverrideDisplayName = Disable discovery of selected DB Engines OverrideManagementPackDisplayName = null OverrideManagementPackName = null OverrideName = Microsoft.SQLServer.Windows.DiscoveryOverride.LocalDBEngineDiscovery OverrideValue = $Data//Property[@Name='VersionList']$ TargetElementId = {BB187D3C-1218-6F43-B6F6-0A0695B96BD7} TargetModuleName = DS TargetParameterName = ExcludedVersions TimeoutSeconds = 300 Error(s): ---------- Exception: ---------- Exception Type: Microsoft.EnterpriseManagement.ContainerException Message: The container could not find a component with name 'ExtensionManagement' compatible with type 'Microsoft.EnterpriseManagement.Configuration.IExtensionManagement, Microsoft.EnterpriseManagement.Core, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. Source: Microsoft.EnterpriseManagement.Core Stack Trace: at Microsoft.EnterpriseManagement.Container.GetService[T](String name) at Microsoft.EnterpriseManagement.Configuration.Verification.VerifyManagementPackElementName.GetExtensions() at Microsoft.EnterpriseManagement.Configuration.Verification.VerifyManagementPackElementName.Verify(ManagementPack mp) at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.CheckPrerequisite(Boolean verifyFragment) at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.Verify(Boolean isUpdate, Boolean throwError) at Microsoft.EnterpriseManagement.Configuration.Verification.VerificationEngine.VerifyMP(ManagementPack mp, Boolean isUpdate, Boolean throwError) at Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride.ModifyOrCreateOverride(OverrideSettings settings) at Microsoft.SQLServer.Core.Module.Helper.Tasks.WriteOverride.<GetModuleDataAsync>d__15.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.SQLServer.Module.Helper.Base.ModuleBasePropertyHelper1.<GetOutputDataAsync>d__13.MoveNext() </ Data >
</ EventData >
</ DataItem >
Hi @Brian W ,
I now remembered where I have seen this. Here it is:
How to exclude SQL Express Edition from SCOM Monitoring
https://kevinholman.com/2020/01/31/how-to-exclude-sql-express-edition-from-scom-monitoring/
This generally happens when you place the override in the wrong place. Did you put something else in the “versions to be excluded” ?
Kevin Holman
and also
Thats because that’s NOT where the override goes, and will break discovery. Look at the article in detail for the correct override location.
Kevin Holman
Can you please check this!
Please read the whole comment section in the article. This has been reported by other users, so there are many references to what needs to be checked.
----------
(If the reply was helpful please don't forget to upvote or accept as answer, thank you)
Best regards,
Stoyan