Bug 1382474

Summary: BR7 report doesn't show statistics
Product: Red Hat Enterprise Virtualization Manager Reporter: Javier Coscia <jcoscia>
Component: ovirt-engine-reportsAssignee: Shirly Radco <sradco>
Status: CLOSED NOTABUG QA Contact: Pavel Stehlik <pstehlik>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 3.6.5CC: gklein, jcoscia, lsurette, rbalakri, Rhev-m-bugs, sradco, srevivo, ykaul, ylavi
Target Milestone: ovirt-3.6.11   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-12-08 09:54:28 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Reports RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Javier Coscia 2016-10-06 18:59:46 UTC 
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.