Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Web Performance Monitor (WPM) > WPM - Knowledgebase Articles > Agents no longer work after migrating WPM to another polling engine

Agents no longer work after migrating WPM to another polling engine

Created by Harry Griffiths, last modified by Jonathon.Privett on Jun 05, 2018

Views: 724 Votes: 2 Revisions: 7

Overview

Agents are no longer responding after migrating WPM to another polling engine.

Environment

All WPM versions

Cause 

The agents are still pointed to the old engine.

To verify this issue matches this article, please run this query in Database Manager to verify the engine ID information.

  1. Go to Volume:\Program Files (x86)\SolarWinds\Orion\DatabaseManager.exe.
  2. Right Click and open it as administrator.
  3. Click Add Default Server.
  4. Expand your Orion Database.
  5. Right Click and Click New Query.
  6. Copy and Paste the Below Query:
SELECT TOP 1000 * FROM [dbo].[Engines]

To see what engineID was assigned before to those agents clear the query and copy and paste the below in:

SELECT TOP 1000 * FROM [dbo].[SEUM_Agents]

Resolution

  1. Verify the newly created and correct engine ID.
  2. Copy and paste the below query in Database Manager, replacing X with the old and new values.
  3. UPDATE [dbo].[SEUM_Agents]
    SET PollingEngineID = X
    WHERE PollingEngineID = X
    Notes:
    SET PollingEngineID = X, the NEW polling engine ID.
    WHERE PollingEngineID = X, the OLD polling engine ID.
    For example, 1 is  the old engine ID and 2 is the new poller that was migrated to:
    UPDATE [dbo].[SEUM_Agents]
    SET PollingEngineID = 1
    WHERE PollingEngineID = 2
    

 

 

Last modified

Tags

Classifications

Public