Didi,

Yes. I still get empty reports. :(

--
Fernando Fuentes
ffuentes@txweather.org
http://www.txweather.org

On Wed, Apr 6, 2016, at 02:08 AM, Yedidyah Bar David wrote:
> On Wed, Apr 6, 2016 at 9:51 AM, Shirly Radco <sradco@redhat.com> wrote:
> > Hi,
> >
> > No. You don't need to reinstall.
> >
> > There should be a cron job that restarts the dwh service after it is down
> > for an hour.
> > Didi, In what cases it will not start?
>
> The log, posted earlier in this thread, seems to show it's actually
> running:
>
> >
> > Best regards,
> > Shirly
> >
> > 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 6:49 PM, Fernando Fuentes <ffuentes@darktcp.net>
> > wrote:
> >>
> >> Team,
> >>
> >> Digging deaper I found that I do have data and create reports up to Oct of
> >> 2015.... Somewhere in Nov 2015 it stop hence why I cant see recent data.
> >> A good note to the list is that November is right around the month I did
> >> the update to 3.5.4.2-1.el6
> >> Do I have to re-installovirt-engine-reports?
> >>
> >> Regards,
> >>
> >> --
> >> Fernando Fuentes
> >> ffuentes@txweather.org
> >> http://www.txweather.org
> >>
> >>
> >>
> >> On Tue, Apr 5, 2016, at 10:23 AM, Fernando Fuentes wrote:
> >>
> >> As requested all dumps and info are at:
> >>
> >> http://pastebin.com/RMSP8HFB
> >>
> >> All systems are running the guest agent.
> >>
> >> Regards,
> >>
> >> --
> >> Fernando Fuentes
> >> ffuentes@txweather.org
> >> http://www.txweather.org
> >>
> >>
> >>
> >> On Tue, Apr 5, 2016, at 03:38 AM, Shirly Radco wrote:
> >>
> >> 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.
>
> The end of it looked like this:
>
> 2015-11-01
> 02:00:29|YigZCz|UkJGNp|IMHBxO|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
> 2016-04-03 14:57:41|ETL Service Stopped
> 2016-04-03 15:12:41|ETL Service Started
>
> From this, I understood that:
> 1. Many months ago, either there was some problem (e.g. dwhd could not
> connect to engine db, or not see updates there, or whatever) or simply
> there was no new data (engine was down, or simply nothing changed (is
> this possible?)).
> 2. Then things became ok for several months (or at least, nothing
> caused dwhd to say otherwise)
> 3. Then dwhd was restarted, perhaps for an upgrade, and still no new
> errors.
>
> Fernando: Do you still only get empty reports?
>
> >>
> >> 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
> >>
> >>
> >> _______________________________________________
> >> Users mailing list
> >> Users@ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/users
> >>
> >>
> >>
> >> _______________________________________________
> >> Users mailing list
> >> Users@ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/users
> >>
> >
>
>
>
> --
> Didi