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

Question

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

Answer 1

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:

• SSRS 2014: An error occurred during execution of a SSRS 2014 MP managed module
• SCOM MSSQL 2008 Replication: An Error occurred during execution of the SQL Server 2008 Replication Management Pack managed module.

----------

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

Best regards,
Leon