Hide this message
Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at email@example.com
In order to determine multicast routing, NPM must determine the status of all multicast devices in a defined group. These devices may be spread across multiple pollers, and group members may change regularly as device use and stop using multicast channels. The database
Delete operations that are required to update the database may cause database deadlocks. Due to their lower assigned priority, when deadlocks occur, operations required for multicast status calculations are dropped as the corresponding processes are canceled.
This issue can express itself via MSMQ backups and MSMQ freezing as its .mq files cannot add more info.
There are three possible solutions to address this issue:
DELETE FROM Pollers WHERE PollerType LIKE '%Multicast%'
ALTER PROCEDURE [dbo].[NPM_Multicast_CountingGroupStatus]
INSERT INTO dbo.[NodeSettings] (NodeID, SettingName, SettingValue)
SELECT n.NodeID, 'NeedsInventory', 'MulticastRouting'
FROM Nodes n
WHERE n.ObjectSubType = 'SNMP' AND n.NodeID NOT IN (SELECT NodeID FROM dbo.[NodeSettings] WHERE SettingName = 'NeedsInventory' AND SettingValue = 'MulticastRouting')