Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

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
18:48, 28 Sep 2016

Tags

Classifications

Public