Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

Home > Success Center > Netflow Traffic Analyzer (NTA) > MACRO SQL ERROR due to incorrect syntax in alert configuration

MACRO SQL ERROR due to incorrect syntax in alert configuration

Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 1,326 Votes: 0 Revisions: 9

Overview

The following errors appear in Netflow Traffic Analyzer: 

  • MACRO SQL ERROR - Incorrect syntax near 'InInterfaceDetailsLink' when High Receive Utilization with Top Talkers alert triggers
  • MACRO SQL ERROR - Incorrect syntax near 'OutInterfaceDetailsLink' when High Transmit Utilization with Top Talkers alert triggers

Environment

All NTA versions

 

Cause

The errors occur if incorrect SQL syntax is used while assigning values to the Macro IDs. For example, using double quotes instead of single quotes to enclose the Macro ID values might cause this error.

 

Resolution

  1. Go to Start > All Programs > SolarWinds Orion > Alerting, Reporting, and Mapping > Advanced Alert Manager
  2. Disable the alert that is shown in the error message.
  3. Edit the alert and click Trigger Actions tab.
  4. Edit the end of the SQL statement and use single quotes instead of double quotes, as shown in the example given below.
  5. Repeat Step 4 in Reset Actions tab.
  6. Re-enable the alert and check if the alert works.

 

Examples:

  • ${SQL:SELECT Macro FROM NetFlowAlertMacros WHERE ID='InInterfaceDetailsLink'}
  • ${SQL:SELECT Macro FROM NetFlowAlertMacros WHERE ID='OutInterfaceDetailsLink'}
Last modified
20:34, 22 Jun 2016

Tags

Classifications

Public