Bug 1064317

Hi Udayendu,

The Monthly reports uses daily aggregated.
and the Daily reports uses Hourly aggregated data. 

Lets try and see if the aggregation to Hourly is working.

For that you need access to the clients "ovirt_engine_history" database.

I will use the "hosts" data just for an example (because you say you see this issue in all of the reports)


1. After connecting to the client by ssh in the command line please run:

   psql -U postgres ovirt_engine_history

   You are supposed to be logged into the database :

   "ovirt_engine_history-#"

   Then run : 

   SELECT * FROM host_hourly_history ORDER BY history_datetime DESC;

   See if you get result. See if they are from recent day. Let Me know.


2. If you do get results lets see if the view is also providing us with results.

   Run : 

   SELECT * FROM v3_3_statistics_hosts_resources_usage_hourly ORDER BY history_datetime DESC;

   See if you get result.  See if they are from recent day. Let Me know.

3. Please run this query also and send me the results:

   SELECT var_name, var_value, var_datetime FROM history_configuration;


Please let me know if this is clear and what you find.

Created attachment 877472 [details]
Putty logs showing all commands out put.

Created attachment 878163 [details]
Latest history DB collected on 22nd March 2014

(In reply to Udayendu Sekhar Kar from comment #22)
> Created attachment 878163 [details]
> Latest history DB collected on 22nd March 2014

The DB dump you and Marina attached can not be uploaded correctly.
Please use this command in order to create it again:

pg_dump -d < database name > -f < filename > -C -D -U < user >