<div dir="ltr"><div>Hi,</div><div><br></div>No. You don't need to reinstall.<div><br></div><div>There should be a cron job that restarts the dwh service after it is down for an hour.</div><div>Didi, In what cases it will not start?</div><div><br></div><div>Best regards,</div><div>Shirly</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif">Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109</span></pre></div></div></div>
<br><div class="gmail_quote">On Tue, Apr 5, 2016 at 6:49 PM, Fernando Fuentes <span dir="ltr"><<a href="mailto:ffuentes@darktcp.net" target="_blank">ffuentes@darktcp.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div><div>Team,<br></div>
<div> </div>
<div>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.<br></div>
<div>A good note to the list is that November is right around the month I did the update to <span>3.5.4.2-1.el6</span><br></div>
<div>Do I have to re-installovirt-engine-reports?<br></div><span class="">
<div> </div>
<div><span>Regards,</span><br></div>
<div> </div>
<div><div>--<br></div>
<div>Fernando Fuentes<br></div>
<div><a href="mailto:ffuentes@txweather.org" target="_blank">ffuentes@txweather.org</a><br></div>
<div><a href="http://www.txweather.org" target="_blank">http://www.txweather.org</a><br></div>
<div> </div>
</div>
<div> </div>
<div> </div>
</span><div><div class="h5"><div>On Tue, Apr 5, 2016, at 10:23 AM, Fernando Fuentes wrote:<br></div>
</div></div><blockquote type="cite"><div><div class="h5"><div>As requested all dumps and info are at:<br></div>
<div> <br></div>
<div><a href="http://pastebin.com/RMSP8HFB" target="_blank">http://pastebin.com/RMSP8HFB</a><br></div>
<div> <br></div>
<div>All systems are running the guest agent.<br></div>
<div> <br></div>
<div>Regards,<br></div>
<div> <br></div>
<div><div>--<br></div>
<div>Fernando Fuentes<br></div>
<div><a href="mailto:ffuentes@txweather.org" target="_blank">ffuentes@txweather.org</a><br></div>
<div><a href="http://www.txweather.org" target="_blank">http://www.txweather.org</a><br></div>
<div> <br></div>
</div>
<div> <br></div>
<div> <br></div>
<div>On Tue, Apr 5, 2016, at 03:38 AM, Shirly Radco wrote:<br></div>
<blockquote type="cite"><div dir="ltr"><div>Hi <span style="color:rgb(51,51,51)"><span style="font-family:'normal arial',sans-serif">Fernando,</span></span><br></div>
<div><span style="color:rgb(51,51,51)"><span style="font-family:'normal arial',sans-serif"><br></span></span>Please check guest agent is running on all hosts.</div>
<div>Please also check if you see data from recent days in table "host_hourly_history".<br></div>
<div> <br></div>
<div>Best regards,<br></div>
<div>Shirly Radco<br></div>
<div> <br></div>
</div>
<div><div> <br></div>
<div><div><div dir="ltr"><pre style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif">Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109</span><br></pre></div>
</div>
</div>
<div> <br></div>
<div><div>On Tue, Apr 5, 2016 at 9:02 AM, Yedidyah Bar David <span dir="ltr"><<a href="mailto:didi@redhat.com" target="_blank">didi@redhat.com</a>></span> wrote:<br></div>
<blockquote style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><span>On Mon, Apr 4, 2016 at 8:53 PM, Fernando Fuentes <<a href="mailto:ffuentes@darktcp.net" target="_blank">ffuentes@darktcp.net</a>> wrote:<br> > Didi,<br> ><br> > As requested.<br> ><br> ><br> > [root@ovirt-dev ~]# service ovirt-engine-dwhd status<br> > ovirt-engine-dwhd (pid 32410) is running...<br> > [root@ovirt-dev ~]#<br> ><br> > The log is over at pastebin to prevent a huge email/<br> ><br> > <a href="http://pastebin.com/hPcYCKVE" target="_blank">http://pastebin.com/hPcYCKVE</a><br> ><br> > Hope that is ok.<br> <br> </span>The log looks mostly ok to me.</div>
<div> <br></div>
<div>Was this a normal, default setup?<br></div>
<div> <br></div>
<div>Please post the output of:<br></div>
<div> <br></div>
<div>su - postgres -c 'psql -c \\l'<br></div>
<div> <br></div>
<div>su - postgres -c "psql -c 'SELECT pg_database.datname,<br></div>
<div>pg_size_pretty(pg_database_size(pg_database.datname)) FROM<br></div>
<div>pg_database'"<br></div>
<div> <br></div>
<div>su - postgres -c "psql ovirt_engine_reports -c 'select<br></div>
<div>connectionurl,username from jijdbcdatasource'"<br></div>
<div> <br></div>
<div>grep DATABASE /etc/ovirt-engine/engine.conf.d/*<br></div>
<div>/etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/*<br></div>
<div> <br></div>
<div>grep dbName /var/lib/ovirt-engine-reports/build-conf/master.properties<br></div>
<div> <br></div>
<div>Adding Shirly.<br></div>
<div><span><span style="color:rgb(136,136,136)">--<br> Didi</span></span></div>
</blockquote></div>
</div>
</blockquote><div> <br></div>
</div></div><span class=""><div><u>_______________________________________________</u><br></div>
<div>Users mailing list<br></div>
<div><a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br></div>
<div><a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br></div>
</span></blockquote><div> </div>
</div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>