Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Netflow Traffic Analyzer (NTA) > div class nsrow style img datakey error when viewing the Manage Netflow Sources and CBQoS Polling page

div class nsrow style img datakey error when viewing the Manage Netflow Sources and CBQoS Polling page

Updated: August 1,2017

Overview

When viewing the "Manage NetFlow Sources and CBQoS Polling" page, some of the Netflow Sources may be inaccessible. The following error occurs:

 

Environment

  • All Orion NTA environments

 

Cause 

There are too many Netflow sources with a NULL value in the NodesData table or a NULL value in the NodeID column of that table.

 

This can also result in the inability to add Netflow sources.

Resolution

To resolve the issue, remove all interfaces in NetFlow Sources that are not collecting any data to bring down the size of the query.

  1. Back up the database or at least the dbo.NetflowSources table. To do so, run the Database Manager, and execute the following query:

    SELECT * INTO NetflowSources_Backup FROM NetflowSources

  2. Stop the Netflow service via the Orion Service Manager
  3. In the Database Manager, run the following database query to delete sources with no data ever collected: 
    DELETE FROM NetFlowSourcesWhere LastTime IS NULL 
  4. Restart the NetFlow service via the Orion Service Manager.

 

The error message does not display on Manage Netflow Sources and CBQoS Polling anymore. If the issue persists, contact support for more troubleshooting.

 

 

 

Last modified

Tags

Classifications

Public