Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

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

Tags

Classifications

Public