"No data to display" in SQL PI for time ranges over five hours but visible in long term data (4375309)

"No data to display" in SQL PI for time ranges over five hours but visible in long term data

SQL PI does not show any historical measures past ~5 hours. If the user chooses 4 hours, it will show all the statements. Somewhere around after 5-6 hours, it shows no dimension activity ("no data to display").  When the time range is set to a longer term such as past three months or past six months there are not gaps and the past day's data can be viewed.

Only 1 MINUTE raw data is being presented in UI and hence only the last 5-6 hours data is seen from FMS UI. This problem can arise if the data roll-up does not happen and 1 MINUTE data cannot be Rolled Up to 15 Minute granularity.

 

When the SQL PI repository has been disconnected from an agent's collections and the rollups did not complete (e,g, the repository database was out of space) the data for some time ranges may not be available.
 

Time Resolution	Retention Period
1 minute	6 hours
15 minutes	3 days
1 hour	2 weeks
6 hours	30 days
1 day	90 days
1 week	2 years

When the underlying PI issue has been addressed, and the rollups have completed the data can once again be written to the PI repository the instance view should be visible for time spans more than 5-6 hours.