<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body><div>Yaniv,<br></div>
<div><br></div>
<div>Thanks for the reply.<br></div>
<div><br></div>
<div>Didi,<br></div>
<div><br></div>
<div>Dully noted!<br></div>
<div><br></div>
<div>Thank you all for the reply. I got it all fixed.<br></div>
<div><br></div>
<div>Regards,</div>
<div><br></div>
<div id="sig20414817"><div class="signature">--<br></div>
<div class="signature">Fernando Fuentes<br></div>
<div class="signature">ffuentes@txweather.org<br></div>
<div class="signature">http://www.txweather.org<br></div>
<div class="signature"><br></div>
</div>
<div><br></div>
<div><br></div>
<div>On Tue, Aug 16, 2016, at 12:56 AM, Yaniv Dary wrote:<br></div>
<blockquote type="cite"><div dir="ltr">This looks like a DWH, not a reports issue. Are you sure you only install reports remotely?<br></div>
<div><div><br></div>
<div><div><div dir="ltr"><div><div dir="ltr"><pre><span class="font" style="font-family:arial, helvetica, sans-serif">Yaniv Dary
Technical Product Manager
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109
Tel : +972 (9) 7692306
8272306
Email: <a href="mailto:ydary@redhat.com">ydary@redhat.com</a>
IRC : ydary</span><br></pre></div>
</div>
</div>
</div>
</div>
<div><br></div>
<div defang_data-gmailquote="yes"><div>On Tue, Aug 16, 2016 at 8:48 AM, Yedidyah Bar David <span dir="ltr"><<a href="mailto:didi@redhat.com">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;" defang_data-gmailquote="yes"><div><span>On Tue, Aug 16, 2016 at 12:09 AM, Fernando Fuentes <<a href="mailto:ffuentes@darktcp.net">ffuentes@darktcp.net</a>> wrote:<br> > David,<br> <br> </span>(Actually it's "Yedidyah" or "Didi", "Bar David" is my surname)</div>
<div> <br></div>
<div><div><div><br></div>
<div>><br></div>
<div> > After an attempt to run this remote setup something went really wrong<br></div>
<div> > and my dwh went fubar on my ovirt 4.0<br></div>
<div> ><br></div>
<div> > I got:<br></div>
<div> ><br></div>
<div> > 2016-08-15 16:03:34|ETL Service Started<br></div>
<div> > ovirtEngineDbDriverClass|org.<wbr>postgresql.Driver<br></div>
<div> > ovirtEngineHistoryDbJdbcConnec<wbr>tion|jdbc:postgresql://<wbr>localhost:5432/ovirt_engine_<wbr>history?sslfactory=org.<wbr>postgresql.ssl.<wbr>NonValidatingFactory<br></div>
<div> > hoursToKeepDaily|43800<br></div>
<div> > hoursToKeepHourly|1440<br></div>
<div> > ovirtEngineDbPassword|********<wbr>**************<br></div>
<div> > runDeleteTime|3<br></div>
<div> > ovirtEngineDbJdbcConnection|<wbr>jdbc:postgresql://localhost:<wbr>5432/engine?sslfactory=org.<wbr>postgresql.ssl.<wbr>NonValidatingFactory<br></div>
<div> > runInterleave|20<br></div>
<div> > limitRows|limit 1000<br></div>
<div> > ovirtEngineHistoryDbUser|<wbr>ovirt_engine_history<br></div>
<div> > ovirtEngineDbUser|engine<br></div>
<div> > deleteIncrement|10<br></div>
<div> > timeBetweenErrorEvents|300000<br></div>
<div> > hoursToKeepSamples|24<br></div>
<div> > deleteMultiplier|1000<br></div>
<div> > lastErrorSent|2011-07-03 12:46:47.000000<br></div>
<div> > etlVersion|4.0.2<br></div>
<div> > dwhAggregationDebug|false<br></div>
<div> > dwhUuid|759f3eb5-5072-4c28-<wbr>9686-a363eb956077<br></div>
<div> > ovirtEngineHistoryDbDriverClas<wbr>s|org.postgresql.Driver<br></div>
<div> > ovirtEngineHistoryDbPassword|*<wbr>*********************<br></div>
<div> > Exception in component tJDBCInput_2<br></div>
<div> > org.postgresql.util.<wbr>PSQLException: ERROR: relation<br></div>
<div> > "history_configuration" does not exist<br></div>
<div> > Position: 65<br></div>
<div> > at<br></div>
<div> > org.postgresql.core.v3.<wbr>QueryExecutorImpl.<wbr>receiveErrorResponse(<wbr>QueryExecutorImpl.java:2157)<br></div>
<div> > at<br></div>
<div> > org.postgresql.core.v3.<wbr>QueryExecutorImpl.<wbr>processResults(<wbr>QueryExecutorImpl.java:1886)<br></div>
<div> > at<br></div>
<div> > org.postgresql.core.v3.<wbr>QueryExecutorImpl.execute(<wbr>QueryExecutorImpl.java:255)<br></div>
<div> > at<br></div>
<div> > org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>execute(<wbr>AbstractJdbc2Statement.java:<wbr>555)<br></div>
<div> > at<br></div>
<div> > org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>executeWithFlags(<wbr>AbstractJdbc2Statement.java:<wbr>403)<br></div>
<div> > at<br></div>
<div> > org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>executeQuery(<wbr>AbstractJdbc2Statement.java:<wbr>283)<br></div>
<div> > at<br></div>
<div> > ovirt_engine_dwh.<wbr>minimalversioncheck_4_0.<wbr>MinimalVersionCheck.<wbr>tJDBCInput_2Process(<wbr>MinimalVersionCheck.java:1574)<br></div>
<div> > at<br></div>
<div> > ovirt_engine_dwh.<wbr>minimalversioncheck_4_0.<wbr>MinimalVersionCheck.<wbr>tJDBCInput_1Process(<wbr>MinimalVersionCheck.java:1229)<br></div>
<div> > at<br></div>
<div> > ovirt_engine_dwh.<wbr>minimalversioncheck_4_0.<wbr>MinimalVersionCheck.<wbr>tJDBCConnection_2Process(<wbr>MinimalVersionCheck.java:782)<br></div>
<div> > at<br></div>
<div> > ovirt_engine_dwh.<wbr>minimalversioncheck_4_0.<wbr>MinimalVersionCheck.<wbr>tJDBCConnection_1Process(<wbr>MinimalVersionCheck.java:657)<br></div>
<div> > at<br></div>
<div> > ovirt_engine_dwh.<wbr>minimalversioncheck_4_0.<wbr>MinimalVersionCheck.<wbr>runJobInTOS(<wbr>MinimalVersionCheck.java:3089)<br></div>
<div> > at<br></div>
<div> > ovirt_engine_dwh.<wbr>minimalversioncheck_4_0.<wbr>MinimalVersionCheck.runJob(<wbr>MinimalVersionCheck.java:2853)<br></div>
<div> > at<br></div>
<div> > ovirt_engine_dwh.historyetl_4_<wbr>0.HistoryETL.tRunJob_2Process(<wbr>HistoryETL.java:8009)<br></div>
<div> > at<br></div>
<div> > ovirt_engine_dwh.historyetl_4_<wbr>0.HistoryETL$3.run(HistoryETL.<wbr>java:11520)<br></div>
<div> > 2016-08-15<br></div>
<div> > 16:03:34|NAl0ai|349e7f|349e7f|<wbr>OVIRT_ENGINE_DWH|<wbr>MinimalVersionCheck|Default|6|<wbr>Java<br></div>
<div> > Exception|tJDBCInput_2|org.<wbr>postgresql.util.PSQLException:<wbr>ERROR: relation<br></div>
<div> > "history_configuration" does not exist<br></div>
<div> > Position: 65|1<br></div>
<div> > Exception in component tRunJob_2<br></div>
<div> > java.lang.RuntimeException: Child job running failed<br></div>
<div> > at<br></div>
<div> > ovirt_engine_dwh.historyetl_4_<wbr>0.HistoryETL.tRunJob_2Process(<wbr>HistoryETL.java:8032)<br></div>
<div> > at<br></div>
<div> > ovirt_engine_dwh.historyetl_4_<wbr>0.HistoryETL$3.run(HistoryETL.<wbr>java:11520)<br></div>
<div> > 2016-08-15<br></div>
<div> > 16:03:34|349e7f|349e7f|349e7f|<wbr>OVIRT_ENGINE_DWH|HistoryETL|<wbr>Default|6|Java<br></div>
<div> > Exception|tRunJob_2|java.lang.<wbr>RuntimeException:Child job running<br></div>
<div> > failed|1<br></div>
<div> > 2016-08-15 16:03:34|ETL Service Stopped<br></div>
<div> ><br></div>
<div> > Can you please help?<br></div>
<div> <br></div>
</div>
</div>
<div>Please provide setup logs on the engine and reports machines. All of<br></div>
<div> /var/log/ovirt-engine/setup/* on both of them. Thanks.<br></div>
<div> <br></div>
<div><div><div><br></div>
<div>><br></div>
<div> > Regards,<br></div>
<div> ><br></div>
<div> > --<br></div>
<div> > Fernando Fuentes<br></div>
<div> > <a href="mailto:ffuentes@txweather.org">ffuentes@txweather.org</a><br></div>
<div> > <a href="http://www.txweather.org">http://www.txweather.org</a><br></div>
<div> ><br></div>
<div> > On Mon, Aug 15, 2016, at 10:16 AM, Fernando Fuentes wrote:<br></div>
<div> >> Thanks David!<br></div>
<div> >><br></div>
<div> >> Regards,<br></div>
<div> >><br></div>
<div> >><br></div>
<div> >> --<br></div>
<div> >> Fernando Fuentes<br></div>
<div> >> <a href="mailto:ffuentes@txweather.org">ffuentes@txweather.org</a><br></div>
<div> >> <a href="http://www.txweather.org">http://www.txweather.org</a><br></div>
<div> >><br></div>
<div> >> On Mon, Aug 15, 2016, at 12:31 AM, Yedidyah Bar David wrote:<br></div>
<div> >> > On Sun, Aug 14, 2016 at 6:57 PM, Fernando Fuentes <<a href="mailto:ffuentes@darktcp.net">ffuentes@darktcp.net</a>><br></div>
<div> >> > wrote:<br></div>
<div> >> > > David,<br></div>
<div> >> > ><br></div>
<div> >> > > Thats exactly what I am trying to accomplish.<br></div>
<div> >> > > When I re-run the ovirt setup on my 3.6 system, I give it the IP of my<br></div>
<div> >> > > ovirt 4.0 machine, Do I leave the DB to the default name? Is there a db<br></div>
<div> >> > > user and password on the 4.0 machine?<br></div>
<div> >> > ><br></div>
<div> >> > > Sorry for so many questions... This is not documented...<br></div>
<div> >> ><br></div>
<div> >> > Not for 3.6 vs 4.0, but it actually is, here:<br></div>
<div> >> ><br></div>
<div> >> > <a href="http://www.ovirt.org/develop/release-management/features/engine/separate-reports-host/">http://www.ovirt.org/develop/<wbr>release-management/features/<wbr>engine/separate-reports-host/</a><br></div>
<div> >> ><br></div>
<div> >> > See also:<br></div>
<div> >> ><br></div>
<div> >> > <a href="http://www.ovirt.org/develop/release-management/features/engine/separate-dwh-host/">http://www.ovirt.org/develop/<wbr>release-management/features/<wbr>engine/separate-dwh-host/</a><br></div>
<div> >> ><br></div>
<div> >> > In above, each of engine, dwh, reports is in its own machine.<br></div>
<div> >> > You can do a similar thing with engine+dwh on one and reports on another.<br></div>
<div> >> ><br></div>
<div> >> > Do not hesitate ping back if you are stuck!<br></div>
<div> >> ><br></div>
<div> >> > Best,<br></div>
<div> >> ><br></div>
<div> >> > ><br></div>
<div> >> > > Thank you for all the help!<br></div>
<div> >> > ><br></div>
<div> >> > > Regards,<br></div>
<div> >> > ><br></div>
<div> >> > > --<br></div>
<div> >> > > Fernando Fuentes<br></div>
<div> >> > > <a href="mailto:ffuentes@txweather.org">ffuentes@txweather.org</a><br></div>
<div> >> > > <a href="http://www.txweather.org">http://www.txweather.org</a><br></div>
<div> >> > ><br></div>
<div> >> > > On Sun, Aug 14, 2016, at 02:01 AM, Yedidyah Bar David wrote:<br></div>
<div> >> > >> On Sat, Aug 13, 2016 at 10:38 PM, Fernando Fuentes <<a href="mailto:ffuentes@darktcp.net">ffuentes@darktcp.net</a>><br></div>
<div> >> > >> wrote:<br></div>
<div> >> > >> > Team,<br></div>
<div> >> > >> ><br></div>
<div> >> > >> > I got two oVirt Servers. One in 4.0.2 and one in 3.6.X<br></div>
<div> >> > >> > I love the new 4.0 dashboard, But I need a way to continue to build<br></div>
<div> >> > >> > reports with ease, 3.6 Can do this with ovirt-reports. How can I make my<br></div>
<div> >> > >> > oVirt 4.0.2 send data for reports to my ovirt reports on 3.6?<br></div>
<div> >> > >> ><br></div>
<div> >> > >> > Thanks for the help team!<br></div>
<div> >> > >><br></div>
<div> >> > >> I didn't try this myself, but pointing your reports setup to the 4.0 dwh<br></div>
<div> >> > >> database should work. If you have problems, please give more details -<br></div>
<div> >> > >> it's not clear what exactly you have on each machine.<br></div>
<div> >> > >><br></div>
<div> >> > >> Generally speaking, oVirt does not currently provide tools to make<br></div>
<div> >> > >> the engine or dwh "send data" elsewhere (a 3.6 reports or whatever).<br></div>
<div> >> > >> You can try doing this yourself using generic postgresql means/tools.<br></div>
<div> >> > >><br></div>
<div> >> > >> Best<br></div>
<div> >> > >> --<br></div>
<div> >> > >> Didi<br></div>
<div> >> ><br></div>
<div> >> ><br></div>
<div> >> ><br></div>
<div> >> > --<br></div>
<div> >> > Didi<br></div>
<div> >> ______________________________<wbr>_________________<br></div>
<div> >> Users mailing list<br></div>
<div> >> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br></div>
<div> >> <a href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br></div>
<div> > ______________________________<wbr>_________________<br></div>
<div> > Users mailing list<br></div>
<div> > <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br></div>
<div> > <a href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br></div>
<div> <br></div>
<div> <br></div>
<div> <br></div>
<div> --<br></div>
<div> Didi<br></div>
<div> ______________________________<wbr>_________________<br></div>
<div> Users mailing list<br></div>
<div> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br></div>
<div> <a href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br></div>
</div>
</div>
</blockquote></div>
</div>
</blockquote><div><br></div>
</body>
</html>