MSSQL 2008 Replication: An Error occurred during execution of the SQL Server 2008 Replication Management Pack managed module

Alvaro Sanchez 1 Reputation point
2020-10-27T07:04:00.81+00:00

Hi All,

I am receiving an error in SCOM related to Replication Discover Package. Could you have a look? Thank you so much.

Below is the complete message --->

Module: Microsoft.SQLServer2008.Replication.Module.Discovery.Discoveries.SubscriptionDiscovery

Version: 6.7.31.0

---------- Exception: ----------

Task finished with exception

at Microsoft.SQLServer.Replication.Module.Helper.Threading.WorkItem`1.GetResult(Int32 timeout, T& result)

at Microsoft.SQLServer.Replication.Module.Helper.Base.ModuleBasePropertyHelper`1.GetOutputData(DataItemBase[] inputDataItems)

at Microsoft.SQLServer.Replication.Module.Helper.ModuleBaseHelper`1.OnNewDataItems(DataItemBase[] dataItems, Boolean logicallyGrouped, DataItemAcknowledgementCallback acknowledgeCallback, Object acknowledgedState, DataItemProcessingCompleteCallback completionCallback, Object completionState)

in Microsoft.SQLServer.2008.Replication.Module.Helper

---------- Inner Exception: ----------

Got no valid result while trying to run WMI query 'SELECT Name, State, StartMode,PathName FROM Win32_Service WHERE Name like 'MSSQLSERVER'' for the path '\SERVER01\Root\Cimv2'. Error persisted after 3 tries.

at Microsoft.SQLServer.Replication.Module.Helper.WMI.RetryPolicyWmiHelper.Query(String queryString)

at Microsoft.SQLServer.Replication.Module.Helper.WMI.CachedWmiHelper.Query(String queryString)

at Microsoft.SQLServer.Replication.Module.Helper.ModuleBaseHelper`1.IsAvaliableSqlEngine(String dataSource)

at Microsoft.SQLServer.Replication.Module.Helper.Base.ModuleBasePropertyHelper1.SafelyOpenSqlConnection(String dataSource, SqlConnection& sqlConnection, Int32 timeout, Boolean rethrowNetworkRelatedExceptions, IEnumerable1 filteredSqlErrorCodes)

at Microsoft.SQLServer2008.Replication.Module.Discovery.Discoveries.SubscriptionDiscovery.GetDistributorName(String publisherServerName)

at Microsoft.SQLServer2008.Replication.Module.Discovery.Discoveries.SubscriptionDiscovery.FillListsOfClassesAndRelations(SqlDataReader mReader)

at Microsoft.SQLServer.Replication.Module.Helper.ModuleBaseDiscoveryHelper.GetModuleData(DataItemBase[] inputDataItems)

at Microsoft.SQLServer.Replication.Module.Helper.Threading.WorkItem`1.<>c__DisplayClass6.<.ctor>b__4()

at Microsoft.SQLServer.Replication.Module.Helper.Threading.WorkItem.<>c__DisplayClass2.<Execute>b__0(Object state)

in Microsoft.SQLServer.2008.Replication.Module.Helper

The configuration properties are :

PrincipalName = SERVER02

InstanceName = MSSQLSERVER

ClassId = 6a25d707-81c5-3355-abd3-cd20351c63a4

SubscriptionDatabaseRelationshipId = d1316e8b-2198-8db4-d8bd-a5f346b833b4

SqlDatabaseClassId = 10c1c7f7-ba0f-5f9b-c74a-79a891170934

DiscoverySourceObjectId = 8e2c0338-cc02-3f9d-87eb-d46e4e436eda

DiscoverySourceManagedEntityId = 382a4e18-ea22-a6db-f9c9-4edfa00d66b9

SqlTimeout = 15

ConnectionString = SERVER02

TimeoutSeconds = 300

Publisher = Replication2008

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Leon Laude 85,666 Reputation points
    2020-10-27T07:55:38.707+00:00

    Hi @Alvaro Sanchez ,

    Is this alert happening often? Is it happening to many servers? If it's only on one (1) server, I would try flushing the agent's cache.

    Also are you able to run the WMI query directly on the targeted server?

    This is the WMI query it's trying to run: 

    SELECT Name, State, StartMode,PathName FROM Win32_Service WHERE Name like 'MSSQLSERVER'

    There's been many people with this similar error in many SQL Server management packs, not sure if its a bug or not, here's a different forum thread with the same issue:

    ----------

    (If the reply was helpful please don't forget to upvote or accept as answer, thank you)

    Best regards,
    Leon