Hi Fernando,

Please check guest agent is running on all hosts.
Please also check if you see data from recent days in table "host_hourly_history".

Best regards,
Shirly Radco


Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109

On Tue, Apr 5, 2016 at 9:02 AM, Yedidyah Bar David <didi@redhat.com> wrote:
On Mon, Apr 4, 2016 at 8:53 PM, Fernando Fuentes <ffuentes@darktcp.net> wrote:
> Didi,
>
> As requested.
>
>
> [root@ovirt-dev ~]# service ovirt-engine-dwhd status
> ovirt-engine-dwhd (pid  32410) is running...
> [root@ovirt-dev ~]#
>
> The log is over at pastebin to prevent a huge email/
>
> http://pastebin.com/hPcYCKVE
>
> Hope that is ok.

The log looks mostly ok to me.

Was this a normal, default setup?

Please post the output of:

su - postgres -c 'psql -c \\l'

su - postgres -c "psql -c 'SELECT pg_database.datname,
pg_size_pretty(pg_database_size(pg_database.datname)) FROM
pg_database'"

su - postgres -c "psql ovirt_engine_reports -c 'select
connectionurl,username from jijdbcdatasource'"

grep DATABASE /etc/ovirt-engine/engine.conf.d/*
/etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/*

grep dbName /var/lib/ovirt-engine-reports/build-conf/master.properties

Adding Shirly.
--
Didi