On dashboard Infrastructure Overview under Top IP Interface Utilization(Flow) - Out it shows: "Query failed. See the logs for details."

Document ID : KB000020307
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Issue is caused by interface speeds of NULL\UNKNOWN were set on interfaces

Solution:

To update speeds in NFA go to admin -> data source settings -> Netflow Analysis@<system_name>. Then when the Netflow Analysis page comes up go to Interfaces -> Physical and Virtual and find the interfaces with 0 as the speed and set the speed accordingly.

The on the on the reporter database on the NFA server run the following SQL

statements

update interfaceflows ib join agents_all_view aav on ib.agentid=aav.id set ib.interfaceoutspeed=aav.outspeed where ib.interfaceoutspeed=0 and aav.outspeed>0;
update interfaceflows ib join agents_all_view aav on ib.agentid=aav.id set ib.interfaceinspeed=aav.inspeed where ib.interfaceinspeed=0 and aav.inspeed>0;