Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > 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