We are using the Flow Statistics page in the NFA Administration GUI. Verified that port 8067 is open in both directions between the NFA Console machine and the Harvesters.
The graphs at the top of the page are showing data. When a Harvester is selected, a “Loading” indicator appears for over a minute, then a “No Matching records found” message appears.
The current Reporter\Logs\WebServicesQueryLog*.log shows the following timeout error:
11:13:57 -1 - Query:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
select id, min(flowRate) as minIFFlows, max(flowRate) as maxIFFlows, avg(flowRate) as avgIFFlows, percentile(flowRate, 95) as pct95IFFlows, name, ip, interfaces from ( select (select count(interfaces.id) from interfaces where interfaces.routerid = routers.id ) as interfaces, routers.ID as id, (sum(interfaceflows.InFlows + interfaceflows.OutFlows)/15) as flowRate, routers.sysName as name, INET_NTOA(routers.routerAddress) as ip from interfaceflows, routers where interfaceflows.endtime >= 1453219500 and interfaceflows.endtime <= 1453305900 and routers.harvesterID = 4 and interfaceflows.AgentID in (select agents_all_view.ID from agents_all_view where agents_all_view.routerid = routers.id) group by routers.id, interfaceflows.endtime ) x group by id
(1 min 30 sec)
By default, the Time Period for data in the Flow Statistics page is set to “Daily”. By shortening this Time Period, we can reduce the amount of data returned by the MySQL queries and reduce the possibility of Timeout errors.
-By default, the Time Period for data in the Flow Statistics page is set to “Daily”. By shortening this Time Period, we can reduce the amount of data returned by the MySQL queries and reduce the possibility of Timeout errors.
-We can also reduce the likelyhood of a timeout by reducing the amount of data stored in the interfaceflows table in the Reporter database. By default, Enterprise Overview data is stored in the interfaceflows table for 30 days. However, NFA itself has no way of accessing EOV data older than 24 hours. EOV data older than 24 hours can only be accessed via the CAPC. But the amount of data stored in this table can slow down the Flow Statistics page.
To correct this you can delete rows from the database to cut this data down to the last weeks worth of data by following the steps below.