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

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

book

Article ID: 97141

calendar_today

Updated On:

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.