Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Netflow Traffic Analyzer (NTA) > NTA - Knowledgebase Articles > 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

Tags

Classifications

Public