Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Network Performance Monitor (NPM) > Clear Information Service Subscriptions

Clear Information Service Subscriptions

Updated September 27, 2017


Information Service uses Subscriptions for Push notifications between SolarWinds servers. As a result, you may experience failures, overall performance impact in the environment or unexpected behavior of applications and their features.


  • Orion Platform
  • Main Polling Engine
  • Additional Polling Engine
  • MSMQ

    Starting with Orion Platform 2016.1 (for example NPM 12.0 and later), most Pub/Sub messages are handled by RabbitMQ instead of MSMQ.

  • Information Service


The following situations can be causing your issues:

Module earlier than Orion Platform 2016.1

You are on a module that ships with the Orion Platform 2015.1.3 and earlier, such as NPM 11.5.3, SAM 6.2.3, or NCM 7.4.1.

In Orion Platform 2016.1 and later (for example, NPM 12.0 and later), communication between polling engines and webservers was improved. Clearing subscriptions should not be necessary except for edge cases, such as when old stale records to an old polling engine were carried over during an upgrade.

If delivery attempts fail repeatedly, contact SolarWinds support.

Before opening a support case, make sure the issues are not caused by the following:

  • Unstable network connections between the polling engines. If the connection is solid, deliveries should work.
  • DNS issues. SWIS running into issues resolving the hostnames used in the endpoint address.
  • An overloaded machine that doesn’t have the ability to consume any more connections.

Do not use Alert Central

Alert Central (free tool) creates related subscriptions. Do not clear the subscriptions table without confirmation from SolarWinds Alert Central developers on the Alert Central THWACK forum.  All support is done through THWACK.

Subscription error

You are getting a Subscription error in InformationService v3 logs:

WARN  SolarWinds.InformationService.ChangeBroker.NotificationManager - (null)     
The INSERT statement conflicted with the FOREIGN KEY constraint 
"FK_SubscriptionPendingNotification". The conflict occurred in database "NetPerfMon", 
table "dbo.Subscriptions", column 'Id'.
The statement has been terminated.

You see Failed Delivery Attempts in the dbo.Subscriptions table:

SELECT * FROM Subscriptions WHERE FailedDeliveryAttempts>0

The following is an example failed attempt entry in the table:

Id EndpointAddress FailedDeliveryAttempts
c4f476f5-77ef-41f7-a828-001de8d790c9 net.tcp://HOSTNAME:17777/SolarWinds/Orion/v3/OrionDataProvider/SchemaChange 126

Before you clear the subscriptions, SolarWinds recommends you attempt to understand why it is failing.

  1. Access the EndPointAddress.
  2. Log in to this server.
  3. Check what SolarWinds software is installed and why it is connecting in the first place.


To clear subscriptions and recreate them use the following steps:

  1. Stop all Orion Services on all Orion servers including Additional Polling Engines and Additional Web Server.
  2. Open the SolarWinds Orion Database Manager.
  3. Click "Add default Server".
  4. Right-click the Orion Database, and select New Query.
  5. Enter the following queries:



    Delete From [dbo].[PendingNotifications]
    Delete From [dbo].[SubscriptionTags]
    Delete From [dbo].[Subscriptions]
    Delete From [dbo].[ContainerMemberSnapshots]
    Delete From [dbo].[LimitationSnapshots]


    6. Click Execute query.    

    7. Start all Orion services for all Orion Servers.


Check these tables once more over the next few days. If something keeps failing, create a ticket with our support team for investigation.


Related Issue: APE - Subscription failures after re-installation of Additional polling engine


Last modified