After upgrading NFA to 9.5, I am no longer seeing data in reports past 1 hour in CAPC. However, I am able to see all data directly in NFA fine. Upgraded to 9.5 of NFA and since then in CA PC I can no longer see data flow data in if I select out more than 1 hour. I get an error of not data to Display and also that the Query failed. See the logs for details
1. Login to CAPC
2. Go to the Admin->Data Sources page
3. Go to the NFA Data source and select "Resync" then check the box for "Full Resynchronization".
4. Wait for the resync to complete, after which a Global Resync will be triggered. Once those are complete try to access the data again in NFA.