Submit a ticketCall us

AnnouncementsTHWACKcamp 2018 is here

2018 is the seventh year for THWACKcamp™, and once again we’ll be live October 17 – 18 with packed session tracks covering everything from network monitoring and management, to change control, application management, storage, cloud and DevOps, security, automation, virtualization, mapping, logging, and more.

Register for online sessions.

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