Graphs missing on interfaces that are Enabled and Licensed

Products

• Network Flow Analysis

Issue/Introduction

Client is seeing graphing missing for routers/interfaces but is seeing updated flow times on the 'Enable Interfaces' page. The interfaces in question are enabled and licensed.
 

Environment

Release : 10.0

Component : NQRPTA - REPORTERANALYZER

Cause

When you have a scenario where an interface is enabled and licensed but data is not reaching the 'Interfaces' page, it means there may be a synchronization issue between the console and the harvester.

In one particular case you may see this in the collector sync logs on the NFA console:

0:43:03 3 - HarvesterInterfaceSync - :

An entity could not be initialized because exactly one row was not returned from the underlying query.

NetQoS.Business.i18nEntityInitializationException: An entity could not be initialized because exactly one row was not returned from the underlying query.

   at NetQoS.Business.DatabaseEntity.InitializeFromQueryResults(DatabaseEntity databaseEntity, DataTable table)

   at NetQoS.ReporterAnalyzer.Business.Interface.GetByRouterAddressAndPersistentIfIndex(IPAddress routerAddress, IPAddress harvesterAddress, UInt32 persistentIfIndex)

   at NetQoS.ReporterAnalyzer.Services.CollectorSyncService.UpdateHarvesterEnabled(CollectedInterface[] collectedInterfaces, String routerAddress, Harvester harvester, IFileLog log)

   at NetQoS.ReporterAnalyzer.Services.CollectorSyncService.SyncInterfaces(Harvester harvester, Int64 lastSyncTime, IFileLog l

Resolution

If you see this particular error in the logs, and the above symptoms, please open a ticket with Broadcom support and we will provide the fix for you.