Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

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