Submit a ticketCall us

AnnouncementUpgrading SolarWinds Orion Platform products has never been easier!

The SolarWinds Orion Installer is an all-in-one application for installations and upgrades. You use one installer to install or upgrade multiple Orion Platform products and install or upgrade Additional Polling Engines, Additional Web Servers, and High Availability Servers.

Learn more in the SolarWinds Orion Installer.

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