After upgrading to NFA 9.5, I no longer see NFA data in CAPC past 1 hour.

Document ID : KB000117638
Last Modified Date : 16/10/2018
Show Technical Document Details
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.