[ovirt-users] Re: ETL service aggregation to hourly tables has encountered an error. Please consult the service log for more details.

Hi, The lastHourAgg should be the hour before last. But for some reason it is 1 hour after that. Do you know when this started? Thi fix the issue you need to update the "lastHourAgg" . Please run the following commands: service ovirt-engine-dwhd stop su postgres -c 'psql -d ovirt_engine_history -c " UPDATE history_configuration set var_datetime = var_datetime - interval '24 hour' WHERE var_name = 'lastHourAggr' "'; su postgres -c 'psql -d ovirt_engine_history -c " UPDATE history_configuration set var_datetime = var_datetime - interval '1 day' WHERE var_name = 'lastDayAggr' "'; service ovirt-engine-dwhd start Best, -- SHIRLY RADCO BI SENIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Tue, Jan 22, 2019 at 10:15 AM <melnyksergii(a)gmail.com&gt; wrote: