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

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

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.