<div dir="ltr"><br><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif;font-size:12.8px">Best regards,</span></pre><pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif;font-size:12.8px">Shirly Radco</span></pre><pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif">BI Software Engineer
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109</span></pre></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On Mon, Dec 19, 2016 at 10:33 AM, Andrea Ghelardi <span dir="ltr"><<a href="mailto:a.ghelardi@iontrading.com" target="_blank">a.ghelardi@iontrading.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div class="gmail-m_6297433308889054618WordSection1">
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">Hello Shirly,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">I restarted dwh service as per your suggestion with no success.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">Here a sample of DWH log:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">2016-12-14 12:31:55|kdcGa9|GCXnuH|PIv06L|<wbr>OVIRT_ENGINE_DWH|<wbr>SampleTimeKeepingJob|Default|<wbr>5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please
check your oVirt Engine status.|9704<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">2016-12-14 12:32:20|ncjn2O|GCXnuH|PIv06L|<wbr>OVIRT_ENGINE_DWH|<wbr>SampleTimeKeepingJob|Default|<wbr>5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please
check your oVirt Engine status.|9704<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">2016-12-14 15:52:37|Xx2zzb|GCXnuH|PIv06L|<wbr>OVIRT_ENGINE_DWH|<wbr>SampleTimeKeepingJob|Default|<wbr>5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please
check your oVirt Engine status.|9704<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">2016-12-16 17:39:13|ETL Service Stopped<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">2016-12-16 17:39:14|ETL Service Started<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">ovirtEngineDbDriverClass|org.<wbr>postgresql.Driver<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">ovirtEngineHistoryDbJdbcConnec<wbr>tion|jdbc:postgresql://<wbr>localhost:5432/ovirt_engine_<wbr>history?sslfactory=org.<wbr>postgresql.ssl.<wbr>NonValidatingFactory<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">hoursToKeepDaily|0<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">hoursToKeepHourly|720<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">ovirtEngineDbPassword|********<wbr>**************<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">runDeleteTime|3<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">ovirtEngineDbJdbcConnection|<wbr>jdbc:postgresql://localhost:<wbr>5432/engine?sslfactory=org.<wbr>postgresql.ssl.<wbr>NonValidatingFactory<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">runInterleave|20<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">limitRows|limit 1000<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">ovirtEngineHistoryDbUser|<wbr>ovirt_engine_history<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">ovirtEngineDbUser|engine<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">deleteIncrement|10<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">timeBetweenErrorEvents|300000<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">hoursToKeepSamples|24<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">deleteMultiplier|1000<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">lastErrorSent|2011-07-03 12:46:47.000000<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">etlVersion|4.0.5<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">dwhAggregationDebug|false<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">dwhUuid|a18846e6-d188-4170-<wbr>8549-aeb1c54fa390<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">ovirtEngineHistoryDbDriverClas<wbr>s|org.postgresql.Driver<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">ovirtEngineHistoryDbPassword|*<wbr>*********************<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">And here a sample of Engine.log<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">2016-12-19 04:32:05,939 WARN [org.ovirt.engine.core.<wbr>vdsbroker.irsbroker.<wbr>IrsProxyData] (DefaultQuartzScheduler5) [53791585] Domain '05c01989-18a1-4a45-9ed6-<wbr>76c6badc728a:intel2-dstore04'
report isn't an actual report<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">2016-12-19 04:32:05,939 WARN [org.ovirt.engine.core.<wbr>vdsbroker.irsbroker.<wbr>IrsProxyData] (DefaultQuartzScheduler5) [53791585] Domain 'f0d8ea03-17ab-4feb-bbf8-<wbr>408e0550fc29:boole2-dstore1'
report isn't an actual report<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif"><u></u></span></p></div></div></blockquote><div><br></div><div>Tal , Allon, Can you please update on what does this engine log error mean?</div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="EN-US"><div class="gmail-m_6297433308889054618WordSection1"><p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif"> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">So apparently DWH is working, but that “report isn't an actual report” is quite obscure to me.</span></p></div></div></blockquote><div><br></div><div>Did you start seeing data in the dashboard?</div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="EN-US"><div class="gmail-m_6297433308889054618WordSection1"><p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">I need to clarify that (almost) all these storages are iscsi SAN hosted and have been detached from Ovirt3 installation and IMPORTED into Ovirt4.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">Could you suggest for next step?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">Thanks<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif">Andrea<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11pt;font-family:calibri,sans-serif">From:</span></b><span style="font-size:11pt;font-family:calibri,sans-serif"> Shirly Radco [mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a>]
<br>
<b>Sent:</b> Thursday, December 8, 2016 10:22 AM<br>
<b>To:</b> Andrea Ghelardi <<a href="mailto:a.ghelardi@iontrading.com" target="_blank">a.ghelardi@iontrading.com</a>><br>
<b>Cc:</b> users <<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a>><br>
<b>Subject:</b> Re: [ovirt-users] Ovirt 4.0.5 reporting dashboard not working.<u></u><u></u></span></p><div><div class="gmail-h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal"><span style="color:black">Hi Andrea,</span><u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Please try to restart the dwh service. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">It is the service that collects the samples data from the engine database to a data warehouse, ovirt_engine_history.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">run:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">service ovirt-engine-dwhd restart<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">and send me the log again.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">If data is still not collected to ovirt_engine_history db I'll need you to open a bug so we can follow on this there.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<pre style="white-space:pre-wrap"><span style="font-size:9.5pt;font-family:arial,sans-serif;color:rgb(80,0,80)">Best regards,</span><span style="color:rgb(80,0,80)"><u></u><u></u></span></pre>
<pre style="white-space:pre-wrap"><span style="font-size:9.5pt;font-family:arial,sans-serif;color:rgb(80,0,80)">Shirly Radco</span><span style="color:rgb(80,0,80)"><u></u><u></u></span></pre>
<pre style="white-space:pre-wrap"><span style="font-family:arial,sans-serif;color:rgb(80,0,80)">BI Software Engineer<u></u><u></u></span></pre>
<pre><span style="font-family:arial,sans-serif;color:rgb(80,0,80)">Red Hat Israel Ltd.<u></u><u></u></span></pre>
<pre><span style="font-family:arial,sans-serif;color:rgb(80,0,80)">34 Jerusalem Road<u></u><u></u></span></pre>
<pre><span style="font-family:arial,sans-serif;color:rgb(80,0,80)">Building A, 4th floor<u></u><u></u></span></pre>
<pre><span style="font-family:arial,sans-serif;color:rgb(80,0,80)">Ra'anana, Israel 4350109</span><span style="color:rgb(80,0,80)"><u></u><u></u></span></pre>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Wed, Dec 7, 2016 at 5:43 PM, Andrea Ghelardi <<a href="mailto:a.ghelardi@iontrading.com" target="_blank">a.ghelardi@iontrading.com</a>> wrote:<u></u><u></u></p>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal">Hello group,<u></u><u></u></p>
<p class="MsoNormal">I noticed that my dashboard does not show little colored “cubes” which show storage CPU and RAM usage history status.<u></u><u></u></p>
<p class="MsoNormal">Attached an image and logs from /var/log/ovirt-engine-dwh/<wbr>ovirt-engine-dwhd.log<u></u><u></u></p>
<p class="MsoNormal">Here’s an extract:<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Exception in component tJDBCInput_5<u></u><u></u></p>
<p class="MsoNormal">org.postgresql.util.<wbr>PSQLException: ERROR: smallint out of range<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.core.v3.<wbr>QueryExecutorImpl.<wbr>receiveErrorResponse(<wbr>QueryExecutorImpl.java:2157)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.core.v3.<wbr>QueryExecutorImpl.<wbr>processResults(<wbr>QueryExecutorImpl.java:1886)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.core.v3.<wbr>QueryExecutorImpl.execute(<wbr>QueryExecutorImpl.java:255)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>execute(<wbr>AbstractJdbc2Statement.java:<wbr>555)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>executeWithFlags(<wbr>AbstractJdbc2Statement.java:<wbr>403)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>executeQuery(<wbr>AbstractJdbc2Statement.java:<wbr>283)<u></u><u></u></p>
<p class="MsoNormal"> at ovirt_engine_dwh.<wbr>statisticssync_4_0.<wbr>StatisticsSync.tJDBCInput_<wbr>5Process(StatisticsSync.java:<wbr>4056)<u></u><u></u></p>
<p class="MsoNormal"> at ovirt_engine_dwh.<wbr>statisticssync_4_0.<wbr>StatisticsSync$3.run(<wbr>StatisticsSync.java:15979)<u></u><u></u></p>
<p class="MsoNormal">Exception in component tJDBCInput_8<u></u><u></u></p>
<p class="MsoNormal">org.postgresql.util.<wbr>PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.core.v3.<wbr>QueryExecutorImpl.<wbr>receiveErrorResponse(<wbr>QueryExecutorImpl.java:2157)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.core.v3.<wbr>QueryExecutorImpl.<wbr>processResults(<wbr>QueryExecutorImpl.java:1886)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.core.v3.<wbr>QueryExecutorImpl.execute(<wbr>QueryExecutorImpl.java:255)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>execute(<wbr>AbstractJdbc2Statement.java:<wbr>555)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>executeWithFlags(<wbr>AbstractJdbc2Statement.java:<wbr>403)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>executeQuery(<wbr>AbstractJdbc2Statement.java:<wbr>283)<u></u><u></u></p>
<p class="MsoNormal"> at ovirt_engine_dwh.<wbr>statisticssync_4_0.<wbr>StatisticsSync.tJDBCInput_<wbr>8Process(StatisticsSync.java:<wbr>5991)<u></u><u></u></p>
<p class="MsoNormal"> at ovirt_engine_dwh.<wbr>statisticssync_4_0.<wbr>StatisticsSync$4.run(<wbr>StatisticsSync.java:16025)<u></u><u></u></p>
<p class="MsoNormal">2016-11-27 14:27:40|tm1tT6|GCXnuH|0jajaj|<wbr>OVIRT_ENGINE_DWH|<wbr>StatisticsSync|Default|6|Java Exception|tJDBCInput_5|org.<wbr>postgresql.util.PSQLException:<wbr>ERROR: smallint out of range|1<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">This is a quite fresh new installation, and restarting engine VM (hosted-engine –vm-stop + hosted-engine –vm-start) does not fix the problem.<u></u><u></u></p>
<p class="MsoNormal">Ovirt is behaving normally.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Any clue?<u></u><u></u></p>
<p class="MsoNormal">Cheers<u></u><u></u></p>
<p class="MsoNormal"><span style="color:rgb(136,136,136)">Andrea<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(136,136,136)"> <u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12pt"><br>
______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div></div></div>
</div>
</blockquote></div><br></div></div>