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 > 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: 84 Votes: 1 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