Submit a ticketCall us

AnnouncementsTHWACKcamp 2018 is here

2018 is the seventh year for THWACKcamp™, and once again we’ll be live October 17 – 18 with packed session tracks covering everything from network monitoring and management, to change control, application management, storage, cloud and DevOps, security, automation, virtualization, mapping, logging, and more.

Register for online sessions.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Change nodes polling engine ID

Change nodes polling engine ID

Table of contents
Created by Ian Rossiter, last modified by Marc.Fobair on Jul 23, 2018

Views: 3,673 Votes: 3 Revisions: 7

Overview

This article describes how you can change the nodes polling engine ID when you are prompted with the following warning message during the Configuration Wizard:

Multiple polling engines detected. The database you have selected is currently being used by another SolarWinds application at (Our Live server) Do you still want to use the selected database?

Environment

All versions of  NPM

Steps

1. Stop all orion services using orion service manager.

2. Go to Database Manager by going to All Programs > SolarWinds Orion > Advanced Features.

3. Run the following query:

Prior to Orion 2017      SELECT TOP 1000 * FROM [dbo].[AllEngines] 

Orion 2017 or later      SELECT TOP 1000 * FROM [dbo].[Engines] 

4. Pull the Engine ID and run the final query adding the correct engine ID to update all nodes.

5. Run this query:

Prior to Orion 2017.x

Update [dbo].[AllEngines] set EngineId = 'NumberGoesHere'

Where EngineId =  'NumberGoesHere'

 

Orion 2017. or later

Update [dbo].[Engines] set EngineId = 'NumberGoesHere'

Where EngineId =  'NumberGoesHere'

6. Start all services using Orion service manager.

 

Example:

Old EngineId = 1       New EngineId = 2

 

Script: Prior Orion 2017 

Update [dbo].[AllEngines] set EngineId = '2'

Where EngineId = '1'

 

Script: Orion 2017 or later

Update [dbo].[Engines] set EngineId = '2'

Where EngineId = '1'

 

Last modified

Tags

Classifications

Public