Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

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

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
10:09, 21 Sep 2017

Tags

Classifications

Public