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 > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > List of alert variables for nodes is missing

List of alert variables for nodes is missing

Updated June 19, 2017

Overview

A variety of alerts trigger emails based on its criteria. For many of these emails, the NODE VARIABLES option is used in the Alert Manager to fill out pertinent details on the email that is sent. This was working fine until some alerts no longer include any of the variable data, and instead displays the raw variable code. When the alerts are inspected, all the preset variables are missing under the Variable under the Nodes drop-down. As a result, the emails that are generated have nothing in reference and just includes raw variables.

 

The actual alert includes correct details and only the email that gets sent information is missing.

 

Environment

NPM 11.5

Cause 

The Alerthistory table is too large and needs to be truncated.

Resolution

  1. Open Database Manager.
  2. Run the following query:
    truncate table alerthistory
  3. Stop and restart all services using the Orion Services Manager.

 

SolarWinds strongly recommends upgrading to NPM 12.0.1 to resolve the issue.

 

Last modified

Tags

Classifications

Public