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

2019-02-04 Thread melnyksergii
All is works, thank you
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/RDWH25IYNTX4YMRUEEHHNLSL5VNRU6RI/


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

2019-01-22 Thread Shirly Radco
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 

TRIED. TESTED. TRUSTED. 


On Tue, Jan 22, 2019 at 10:15 AM  wrote:

> Dears,
> Could you answer how can I fix my problem?
> Thanks
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@ovirt.org
> Privacy Statement: https://www.ovirt.org/site/privacy-policy/
> oVirt Code of Conduct:
> https://www.ovirt.org/community/about/community-guidelines/
> List Archives:
> https://lists.ovirt.org/archives/list/users@ovirt.org/message/VQ6MWBWX2NAR7MEH4KCK3AO4TAHK3A46/
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/UZCBUUNPVNXUKKH32XQWANJDQDBKMY6I/


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

2019-01-22 Thread melnyksergii
Dears, 
Could you answer how can I fix my problem?
Thanks
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/VQ6MWBWX2NAR7MEH4KCK3AO4TAHK3A46/


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

2019-01-20 Thread Yedidyah Bar David
On Fri, Jan 18, 2019 at 12:35 PM Sandro Bonazzola  wrote:
>
>
>
> Il giorno mar 15 gen 2019 alle ore 08:18 Yedidyah Bar David  
> ha scritto:
>>
>> On Mon, Jan 14, 2019 at 7:06 PM  wrote:
>> >
>> > Dears,
>> > I have an a some error in Ovirt 4.2.7
>> > In dash I see:
>> > ETL service aggregation to hourly tables has encountered an error. Please 
>> > consult the service log for more details.
>> > In log ovirt engine server:
>> > 2019-01-14 
>> > 15:59:59|rwL6AB|euUXph|wfcjQ7|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2019-01-14
>> >  15:59:59| ETL service aggregation to hourly tables has encountered an 
>> > error. lastHourAgg value =Mon Jan 14 14:00:00 EET 2019 and runTime = Mon 
>> > Jan 14 15:59:59 EET 2019 .Please consult the service log for more 
>> > details.|42
>> > In some sources people said the problem is in PostgreSQL DB, but I don't 
>> > understand how can I fix this problem?
>>
>> The "service log" refers to /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log .
>> Please check/share that. Thanks.
>>
>> Adding Shirly.
>>
>> Also, we might want to change the message to mention the log location.
>
>
> Didi is this tracked in a BZ?

Now opened: https://bugzilla.redhat.com/show_bug.cgi?id=1667726

>
>>
>>
>> Best regards,
>> --
>> Didi
>> ___
>> Users mailing list -- users@ovirt.org
>> To unsubscribe send an email to users-le...@ovirt.org
>> Privacy Statement: https://www.ovirt.org/site/privacy-policy/
>> oVirt Code of Conduct: 
>> https://www.ovirt.org/community/about/community-guidelines/
>> List Archives: 
>> https://lists.ovirt.org/archives/list/users@ovirt.org/message/I76Y3SNM33R4ZWTNGXJ6NYU6RZPYZBEI/
>
>
>
> --
>
> SANDRO BONAZZOLA
>
> MANAGER, SOFTWARE ENGINEERING, EMEA R RHV
>
> Red Hat EMEA
>
> sbona...@redhat.com



-- 
Didi
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/T6BVG5WERSSCTUHBAGTEUMCW4US3ANDD/


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

2019-01-20 Thread Yedidyah Bar David
On Fri, Jan 18, 2019 at 12:35 PM Sandro Bonazzola  wrote:
>
> Didi, Shirly, can you please check these logs?

I can't see here anything explaining why it failed, I hope
Shirly can, or can tell what other information can help.

>
> Il giorno mar 15 gen 2019 alle ore 09:13  ha scritto:
>>
>> 2018-10-22 17:58:40|ETL Service Started
>> ovirtEngineDbDriverClass|org.postgresql.Driver
>> ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory
>> hoursToKeepDaily|0
>> hoursToKeepHourly|720
>> ovirtEngineDbPassword|**
>> runDeleteTime|3
>> ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory
>> runInterleave|60
>> limitRows|limit 1000
>> ovirtEngineHistoryDbUser|ovirt_engine_history
>> ovirtEngineDbUser|engine
>> deleteIncrement|10
>> timeBetweenErrorEvents|30
>> hoursToKeepSamples|24
>> deleteMultiplier|1000
>> lastErrorSent|2011-07-03 12:46:47.00
>> etlVersion|4.2.4.3
>> dwhAggregationDebug|false
>> dwhUuid|69462636-22a6-4aae-9703-70ce55856985
>> ovirtEngineHistoryDbDriverClass|org.postgresql.Driver
>> ovirtEngineHistoryDbPassword|**
>> 2018-10-23 
>> 16:59:59|QUC3MI|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-23
>>  16:59:59| ETL service aggregation to hourly tables has encountered an 
>> error. lastHourAgg value =Tue Oct 23 15:00:00 EEST 2018 and runTime = Tue 
>> Oct 23 16:59:59 EEST 2018 .Please consult the service log for more 
>> details.|42
>> 2018-10-24 
>> 17:59:59|xMmYXu|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-24
>>  17:59:59| ETL service aggregation to hourly tables has encountered an 
>> error. lastHourAgg value =Wed Oct 24 16:00:00 EEST 2018 and runTime = Wed 
>> Oct 24 17:59:59 EEST 2018 .Please consult the service log for more 
>> details.|42
>> 2018-10-25 
>> 16:59:59|cUcnsD|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-25
>>  16:59:59| ETL service aggregation to hourly tables has encountered an 
>> error. lastHourAgg value =Thu Oct 25 15:00:00 EEST 2018 and runTime = Thu 
>> Oct 25 16:59:59 EEST 2018 .Please consult the service log for more 
>> details.|42
>> 2018-10-25 
>> 17:59:59|eJkgGv|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-25
>>  17:59:59| ETL service aggregation to hourly tables has encountered an 
>> error. lastHourAgg value =Thu Oct 25 16:00:00 EEST 2018 and runTime = Thu 
>> Oct 25 17:59:59 EEST 2018 .Please consult the service log for more 
>> details.|42
>> 2018-10-25 
>> 20:59:58|Sc5Lfp|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-25
>>  20:59:58| ETL service aggregation to hourly tables has encountered an 
>> error. lastHourAgg value =Thu Oct 25 19:00:00 EEST 2018 and runTime = Thu 
>> Oct 25 20:59:58 EEST 2018 .Please consult the service log for more 
>> details.|42
>> 2018-10-26 
>> 01:59:59|TQ4s8m|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-26
>>  01:59:59| ETL service aggregation to hourly tables has encountered an 
>> error. lastHourAgg value =Fri Oct 26 00:00:00 EEST 2018 and runTime = Fri 
>> Oct 26 01:59:59 EEST 2018 .Please consult the service log for more 
>> details.|42
>> 2018-10-26 
>> 15:59:55|Tiv1gZ|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-26
>>  15:59:55| ETL service aggregation to hourly tables has encountered an 
>> error. lastHourAgg value =Fri Oct 26 14:00:00 EEST 2018 and runTime = Fri 
>> Oct 26 15:59:55 EEST 2018 .Please consult the service log for more 
>> details.|42
>> 2018-10-27 
>> 22:59:59|tsRtk4|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-27
>>  22:59:59| ETL service aggregation to hourly tables has encountered an 
>> error. lastHourAgg value =Sat Oct 27 21:00:00 EEST 2018 and runTime = Sat 
>> Oct 27 22:59:59 EEST 2018 .Please consult the service log for more 
>> details.|42
>> 2018-10-28 
>> 03:00:00|We7dPQ|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-28
>>  03:00:00| ETL service aggregation to hourly tables has encountered an 
>> error. lastHourAgg value =Sun Oct 28 03:00:00 EET 2018 and runTime = Sun Oct 
>> 28 03:00:00 EET 2018 .Please consult the service log for more details.|42
>> 2018-10-28 
>> 03:00:14|c3NnXS|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
>>  not sample data, oVirt Engine is not updating the statistics. Please check 
>> your oVirt Engine status.|9704
>> 2018-10-28 
>> 03:01:19|3CFZLf|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
>>  not sample data, oVirt Engine is not updating the statistics. Please check 
>> your oVirt Engine status.|9704
>> 2018-10-28 
>> 

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

2019-01-18 Thread Sandro Bonazzola
Didi, Shirly, can you please check these logs?

Il giorno mar 15 gen 2019 alle ore 09:13  ha
scritto:

> 2018-10-22 17:58:40|ETL Service Started
> ovirtEngineDbDriverClass|org.postgresql.Driver
>
> ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory
> hoursToKeepDaily|0
> hoursToKeepHourly|720
> ovirtEngineDbPassword|**
> runDeleteTime|3
>
> ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory
> runInterleave|60
> limitRows|limit 1000
> ovirtEngineHistoryDbUser|ovirt_engine_history
> ovirtEngineDbUser|engine
> deleteIncrement|10
> timeBetweenErrorEvents|30
> hoursToKeepSamples|24
> deleteMultiplier|1000
> lastErrorSent|2011-07-03 12:46:47.00
> etlVersion|4.2.4.3
> dwhAggregationDebug|false
> dwhUuid|69462636-22a6-4aae-9703-70ce55856985
> ovirtEngineHistoryDbDriverClass|org.postgresql.Driver
> ovirtEngineHistoryDbPassword|**
> 2018-10-23
> 16:59:59|QUC3MI|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-23
> 16:59:59| ETL service aggregation to hourly tables has encountered an
> error. lastHourAgg value =Tue Oct 23 15:00:00 EEST 2018 and runTime = Tue
> Oct 23 16:59:59 EEST 2018 .Please consult the service log for more
> details.|42
> 2018-10-24
> 17:59:59|xMmYXu|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-24
> 17:59:59| ETL service aggregation to hourly tables has encountered an
> error. lastHourAgg value =Wed Oct 24 16:00:00 EEST 2018 and runTime = Wed
> Oct 24 17:59:59 EEST 2018 .Please consult the service log for more
> details.|42
> 2018-10-25
> 16:59:59|cUcnsD|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-25
> 16:59:59| ETL service aggregation to hourly tables has encountered an
> error. lastHourAgg value =Thu Oct 25 15:00:00 EEST 2018 and runTime = Thu
> Oct 25 16:59:59 EEST 2018 .Please consult the service log for more
> details.|42
> 2018-10-25
> 17:59:59|eJkgGv|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-25
> 17:59:59| ETL service aggregation to hourly tables has encountered an
> error. lastHourAgg value =Thu Oct 25 16:00:00 EEST 2018 and runTime = Thu
> Oct 25 17:59:59 EEST 2018 .Please consult the service log for more
> details.|42
> 2018-10-25
> 20:59:58|Sc5Lfp|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-25
> 20:59:58| ETL service aggregation to hourly tables has encountered an
> error. lastHourAgg value =Thu Oct 25 19:00:00 EEST 2018 and runTime = Thu
> Oct 25 20:59:58 EEST 2018 .Please consult the service log for more
> details.|42
> 2018-10-26
> 01:59:59|TQ4s8m|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-26
> 01:59:59| ETL service aggregation to hourly tables has encountered an
> error. lastHourAgg value =Fri Oct 26 00:00:00 EEST 2018 and runTime = Fri
> Oct 26 01:59:59 EEST 2018 .Please consult the service log for more
> details.|42
> 2018-10-26
> 15:59:55|Tiv1gZ|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-26
> 15:59:55| ETL service aggregation to hourly tables has encountered an
> error. lastHourAgg value =Fri Oct 26 14:00:00 EEST 2018 and runTime = Fri
> Oct 26 15:59:55 EEST 2018 .Please consult the service log for more
> details.|42
> 2018-10-27
> 22:59:59|tsRtk4|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-27
> 22:59:59| ETL service aggregation to hourly tables has encountered an
> error. lastHourAgg value =Sat Oct 27 21:00:00 EEST 2018 and runTime = Sat
> Oct 27 22:59:59 EEST 2018 .Please consult the service log for more
> details.|42
> 2018-10-28
> 03:00:00|We7dPQ|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-28
> 03:00:00| ETL service aggregation to hourly tables has encountered an
> error. lastHourAgg value =Sun Oct 28 03:00:00 EET 2018 and runTime = Sun
> Oct 28 03:00:00 EET 2018 .Please consult the service log for more
> details.|42
> 2018-10-28
> 03:00:14|c3NnXS|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
> not sample data, oVirt Engine is not updating the statistics. Please check
> your oVirt Engine status.|9704
> 2018-10-28
> 03:01:19|3CFZLf|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
> not sample data, oVirt Engine is not updating the statistics. Please check
> your oVirt Engine status.|9704
> 2018-10-28
> 03:02:24|gt6fSU|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
> not sample data, oVirt Engine is not updating the statistics. Please check
> your oVirt Engine status.|9704
> 2018-10-28
> 03:03:29|TzjHed|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
> not sample data, oVirt Engine is not updating 

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

2019-01-18 Thread Sandro Bonazzola
Il giorno mar 15 gen 2019 alle ore 08:18 Yedidyah Bar David 
ha scritto:

> On Mon, Jan 14, 2019 at 7:06 PM  wrote:
> >
> > Dears,
> > I have an a some error in Ovirt 4.2.7
> > In dash I see:
> > ETL service aggregation to hourly tables has encountered an error.
> Please consult the service log for more details.
> > In log ovirt engine server:
> > 2019-01-14
> 15:59:59|rwL6AB|euUXph|wfcjQ7|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2019-01-14
> 15:59:59| ETL service aggregation to hourly tables has encountered an
> error. lastHourAgg value =Mon Jan 14 14:00:00 EET 2019 and runTime = Mon
> Jan 14 15:59:59 EET 2019 .Please consult the service log for more
> details.|42
> > In some sources people said the problem is in PostgreSQL DB, but I don't
> understand how can I fix this problem?
>
> The "service log" refers to
> /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log .
> Please check/share that. Thanks.
>
> Adding Shirly.
>
> Also, we might want to change the message to mention the log location.
>

Didi is this tracked in a BZ?


>
> Best regards,
> --
> Didi
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@ovirt.org
> Privacy Statement: https://www.ovirt.org/site/privacy-policy/
> oVirt Code of Conduct:
> https://www.ovirt.org/community/about/community-guidelines/
> List Archives:
> https://lists.ovirt.org/archives/list/users@ovirt.org/message/I76Y3SNM33R4ZWTNGXJ6NYU6RZPYZBEI/
>


-- 

SANDRO BONAZZOLA

MANAGER, SOFTWARE ENGINEERING, EMEA R RHV

Red Hat EMEA 

sbona...@redhat.com

___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/YLFCC2DHWMOQUTMEFCNY76MUIQUCVHCY/


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

2019-01-15 Thread melnyksergii
2018-10-22 17:58:40|ETL Service Started
ovirtEngineDbDriverClass|org.postgresql.Driver
ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory
hoursToKeepDaily|0
hoursToKeepHourly|720
ovirtEngineDbPassword|**
runDeleteTime|3
ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory
runInterleave|60
limitRows|limit 1000
ovirtEngineHistoryDbUser|ovirt_engine_history
ovirtEngineDbUser|engine
deleteIncrement|10
timeBetweenErrorEvents|30
hoursToKeepSamples|24
deleteMultiplier|1000
lastErrorSent|2011-07-03 12:46:47.00
etlVersion|4.2.4.3
dwhAggregationDebug|false
dwhUuid|69462636-22a6-4aae-9703-70ce55856985
ovirtEngineHistoryDbDriverClass|org.postgresql.Driver
ovirtEngineHistoryDbPassword|**
2018-10-23 
16:59:59|QUC3MI|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-23
 16:59:59| ETL service aggregation to hourly tables has encountered an error. 
lastHourAgg value =Tue Oct 23 15:00:00 EEST 2018 and runTime = Tue Oct 23 
16:59:59 EEST 2018 .Please consult the service log for more details.|42
2018-10-24 
17:59:59|xMmYXu|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-24
 17:59:59| ETL service aggregation to hourly tables has encountered an error. 
lastHourAgg value =Wed Oct 24 16:00:00 EEST 2018 and runTime = Wed Oct 24 
17:59:59 EEST 2018 .Please consult the service log for more details.|42
2018-10-25 
16:59:59|cUcnsD|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-25
 16:59:59| ETL service aggregation to hourly tables has encountered an error. 
lastHourAgg value =Thu Oct 25 15:00:00 EEST 2018 and runTime = Thu Oct 25 
16:59:59 EEST 2018 .Please consult the service log for more details.|42
2018-10-25 
17:59:59|eJkgGv|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-25
 17:59:59| ETL service aggregation to hourly tables has encountered an error. 
lastHourAgg value =Thu Oct 25 16:00:00 EEST 2018 and runTime = Thu Oct 25 
17:59:59 EEST 2018 .Please consult the service log for more details.|42
2018-10-25 
20:59:58|Sc5Lfp|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-25
 20:59:58| ETL service aggregation to hourly tables has encountered an error. 
lastHourAgg value =Thu Oct 25 19:00:00 EEST 2018 and runTime = Thu Oct 25 
20:59:58 EEST 2018 .Please consult the service log for more details.|42
2018-10-26 
01:59:59|TQ4s8m|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-26
 01:59:59| ETL service aggregation to hourly tables has encountered an error. 
lastHourAgg value =Fri Oct 26 00:00:00 EEST 2018 and runTime = Fri Oct 26 
01:59:59 EEST 2018 .Please consult the service log for more details.|42
2018-10-26 
15:59:55|Tiv1gZ|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-26
 15:59:55| ETL service aggregation to hourly tables has encountered an error. 
lastHourAgg value =Fri Oct 26 14:00:00 EEST 2018 and runTime = Fri Oct 26 
15:59:55 EEST 2018 .Please consult the service log for more details.|42
2018-10-27 
22:59:59|tsRtk4|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-27
 22:59:59| ETL service aggregation to hourly tables has encountered an error. 
lastHourAgg value =Sat Oct 27 21:00:00 EEST 2018 and runTime = Sat Oct 27 
22:59:59 EEST 2018 .Please consult the service log for more details.|42
2018-10-28 
03:00:00|We7dPQ|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-28
 03:00:00| ETL service aggregation to hourly tables has encountered an error. 
lastHourAgg value =Sun Oct 28 03:00:00 EET 2018 and runTime = Sun Oct 28 
03:00:00 EET 2018 .Please consult the service log for more details.|42
2018-10-28 
03:00:14|c3NnXS|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
 not sample data, oVirt Engine is not updating the statistics. Please check 
your oVirt Engine status.|9704
2018-10-28 
03:01:19|3CFZLf|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
 not sample data, oVirt Engine is not updating the statistics. Please check 
your oVirt Engine status.|9704
2018-10-28 
03:02:24|gt6fSU|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
 not sample data, oVirt Engine is not updating the statistics. Please check 
your oVirt Engine status.|9704
2018-10-28 
03:03:29|TzjHed|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
 not sample data, oVirt Engine is not updating the statistics. Please check 
your oVirt Engine status.|9704
2018-10-28 
03:04:34|cK2IFe|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
 not sample data, oVirt Engine is not updating the statistics. Please 

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

2019-01-14 Thread Yedidyah Bar David
On Mon, Jan 14, 2019 at 7:06 PM  wrote:
>
> Dears,
> I have an a some error in Ovirt 4.2.7
> In dash I see:
> ETL service aggregation to hourly tables has encountered an error. Please 
> consult the service log for more details.
> In log ovirt engine server:
> 2019-01-14 
> 15:59:59|rwL6AB|euUXph|wfcjQ7|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2019-01-14
>  15:59:59| ETL service aggregation to hourly tables has encountered an error. 
> lastHourAgg value =Mon Jan 14 14:00:00 EET 2019 and runTime = Mon Jan 14 
> 15:59:59 EET 2019 .Please consult the service log for more details.|42
> In some sources people said the problem is in PostgreSQL DB, but I don't 
> understand how can I fix this problem?

The "service log" refers to /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log .
Please check/share that. Thanks.

Adding Shirly.

Also, we might want to change the message to mention the log location.

Best regards,
-- 
Didi
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/I76Y3SNM33R4ZWTNGXJ6NYU6RZPYZBEI/