Top Flows by interface shows no data and "Query failed" in CAPC

Document ID : KB000097141
Last Modified Date : 22/05/2018
Show Technical Document Details
Issue:
The Top Flows by interface view in CAPC shows no data and "Query failed. See the logs for details. (Query ID: b90c5322-7aaf-439b-9163-50ff42f2945e)"
Environment:
CAPC
NFA
Cause:
This can occur if there is too much data in the reporter.interfaceflows table on the NFA console server.  
By default NFA keeps 1 month's worth of data, but this is often too much in high volume environments.
Resolution:
You can reduce the amount of data retained to 1 week, following the steps below:

1. Log in the NFA Console Server, open a command prompt and run:
mysql reporter 

2. Then run the following 
update parameter_descriptions set defaultvalue='1w' where parameter='FlowInfoLimit'; 
 
3. Then recycle the CA Mysql service on the NFA Console server and wait a few minutes then try the same view again.