Description of problem:

After fixing an issue with data aggregation related to a timezone misconfiguration (check bz 1323783 for more information), report BR7 (Cluster Host Uptime) doesn't show old information, others like BR46 does show information


Version-Release number of selected component (if applicable):
rhevm-3.6.8.1-0.1.el6.noarch
rhevm-dwh-3.6.8-1.el6ev.noarch
rhevm-dwh-setup-3.6.8-1.el6ev.noarch
rhevm-reports-3.6.5.1-1.el6ev.noarch
rhevm-reports-setup-3.6.5.1-1.el6ev.noarch

How reproducible:
100% in customer's environment

Steps to Reproduce:
1. Fix timezone configuration

/etc/localtime was a symlink to /usr/share/zoneinfo/America/El_Salvador and /etc/sysconfig/clock had ZONE=America/Bogota

Remove symlink and copy /usr/share/zoneinfo/America/El_Salvador as /etc/localtime

Update ZONE in /etc/sysconfig/clock to America/El_Salvador and "tzdata-update"


2. Update lastHourAggr and lastDayAggr in history_configuration table

~~~
UPDATE history_configuration set var_datetime = now()- interval '1 day' WHERE var_name = 'lastHourAggr';
UPDATE history_configuration set var_datetime = now()- interval '2 day' WHERE var_name = 'lastDayAggr';
~~~

3. Restart DWH/Reports services


Actual results:

Report BR7 doesn't show information from earlier months, just show information from date after the last*Aggr updates

Expected results:

DWH db has old information and thus it should show statistics from earlier dates for hosts in cluster. Currently, selecting the problematic range of dates, the Input Controls shows "None Available" for Data Center.