Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > SQL error in Basic Alerts Manager, Syslog Viewer and Trap Viewer

SQL error in Basic Alerts Manager, Syslog Viewer and Trap Viewer

Table of contents
No headers
Created by Interspire Import, last modified by carolyn.mazenko on Jul 10, 2018

Views: 1,032 Votes: 0 Revisions: 10

 

ISSUE
1. Advanced Alert Manager Hangs or does not show anything for alerts.
2. Basic Alert Manager shows a sql error when opening it. (Only applies to NPM 11.x and NPM 12.x)
3. Syslog Viewer shows a SQL error when trying to open it.
4. Traps Viewer shows a SQL error when trying to open it.

 

 

The Advanced Alert Manager was discontinued and functionality was rolled into the Orion Platform. For the latest information about alerts, see Alerting resources for Orion Platform products.


CAUSE:
An extra space may exist at the end of the SQL Server name.

SOLUTION

  1. Navigate to C:\Program Files (x86)\SolarWinds\Orion
  2. Locate the file named "SWNetPerfMon.DB"  and open it in Notepad 
  3. Remove the space after DOH-SQL-CS0801 . (See screen shot example.)
  4. Verify there is no space after the SQL server name . 
  5. Restart all Orion services 

 

Last modified

Tags

Classifications

Public