Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Network Performance Monitor (NPM) > Alert for Top Talkers: MACRO SQL ERROR - Incorrect syntax near 'InterfaceName'.

Alert for Top Talkers: MACRO SQL ERROR - Incorrect syntax near 'InterfaceName'.

Updated September 29, 2016

Overview

Customer is receiving an email alert for NTA Top Talkers alert:

Interface: InterfaceAAA 'outside' interface · outside for node 701-ASA-01
Transmit Utilization: 13 
Receive Utilization: 97

Click here for Top Talkers: MACRO SQL ERROR - Incorrect syntax near 'outside'.

Environment

  • All NTA versions
  • All NPM versions

Cause 

A single quote (') character is included in the Interface Name causing the SQL query to not be parsed.

Resolution

  1. Login to Orion Web Console as admin.
  2. Go to the affected Interface and on the Interface Details page, click Edit Interface.
  3. Change the name of the interface and remove the (') characters.
  4. Click Submit.

 

Last modified

Tags

Classifications

Public