[ovirt-users] oVirt Reports

Mon Aug 15 21:09:59 UTC 2016

David,

After an attempt to run this remote setup something went really wrong
and my dwh went fubar on my ovirt 4.0

I got:

2016-08-15 16:03:34|ETL Service Started
ovirtEngineDbDriverClass|org.postgresql.Driver
ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory
hoursToKeepDaily|43800
hoursToKeepHourly|1440
ovirtEngineDbPassword|**********************
runDeleteTime|3
ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory
runInterleave|20
limitRows|limit 1000
ovirtEngineHistoryDbUser|ovirt_engine_history
ovirtEngineDbUser|engine
deleteIncrement|10
timeBetweenErrorEvents|300000
hoursToKeepSamples|24
deleteMultiplier|1000
lastErrorSent|2011-07-03 12:46:47.000000
etlVersion|4.0.2
dwhAggregationDebug|false
dwhUuid|759f3eb5-5072-4c28-9686-a363eb956077
ovirtEngineHistoryDbDriverClass|org.postgresql.Driver
ovirtEngineHistoryDbPassword|**********************
Exception in component tJDBCInput_2
org.postgresql.util.PSQLException: ERROR: relation
"history_configuration" does not exist
  Position: 65
        at
        org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
        at
        org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
        at
        org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at
        org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
        at
        org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
        at
        org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
        at
        ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCInput_2Process(MinimalVersionCheck.java:1574)
        at
        ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCInput_1Process(MinimalVersionCheck.java:1229)
        at
        ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCConnection_2Process(MinimalVersionCheck.java:782)
        at
        ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCConnection_1Process(MinimalVersionCheck.java:657)
        at
        ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.runJobInTOS(MinimalVersionCheck.java:3089)
        at
        ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.runJob(MinimalVersionCheck.java:2853)
        at
        ovirt_engine_dwh.historyetl_4_0.HistoryETL.tRunJob_2Process(HistoryETL.java:8009)
        at
        ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryETL.java:11520)
2016-08-15
16:03:34|NAl0ai|349e7f|349e7f|OVIRT_ENGINE_DWH|MinimalVersionCheck|Default|6|Java
Exception|tJDBCInput_2|org.postgresql.util.PSQLException:ERROR: relation
"history_configuration" does not exist
  Position: 65|1
Exception in component tRunJob_2
java.lang.RuntimeException: Child job running failed
        at
        ovirt_engine_dwh.historyetl_4_0.HistoryETL.tRunJob_2Process(HistoryETL.java:8032)
        at
        ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryETL.java:11520)
2016-08-15
16:03:34|349e7f|349e7f|349e7f|OVIRT_ENGINE_DWH|HistoryETL|Default|6|Java
Exception|tRunJob_2|java.lang.RuntimeException:Child job running
failed|1
2016-08-15 16:03:34|ETL Service Stopped

Can you please help?

Regards,

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

On Mon, Aug 15, 2016, at 10:16 AM, Fernando Fuentes wrote:
> Thanks David!
> 
> Regards,
> 
> 
> -- 
> Fernando Fuentes
> ffuentes at txweather.org
> http://www.txweather.org
> 
> On Mon, Aug 15, 2016, at 12:31 AM, Yedidyah Bar David wrote:
> > On Sun, Aug 14, 2016 at 6:57 PM, Fernando Fuentes <ffuentes at darktcp.net>
> > wrote:
> > > David,
> > >
> > > Thats exactly what I am trying to accomplish.
> > > When I re-run the ovirt setup on my 3.6 system, I give it the IP of my
> > > ovirt 4.0 machine, Do I leave the DB to the default name? Is there a db
> > > user and password on the 4.0 machine?
> > >
> > > Sorry for so many questions... This is not documented...
> > 
> > Not for 3.6 vs 4.0, but it actually is, here:
> > 
> > http://www.ovirt.org/develop/release-management/features/engine/separate-reports-host/
> > 
> > See also:
> > 
> > http://www.ovirt.org/develop/release-management/features/engine/separate-dwh-host/
> > 
> > In above, each of engine, dwh, reports is in its own machine.
> > You can do a similar thing with engine+dwh on one and reports on another.
> > 
> > Do not hesitate ping back if you are stuck!
> > 
> > Best,
> > 
> > >
> > > Thank you for all the help!
> > >
> > > Regards,
> > >
> > > --
> > > Fernando Fuentes
> > > ffuentes at txweather.org
> > > http://www.txweather.org
> > >
> > > On Sun, Aug 14, 2016, at 02:01 AM, Yedidyah Bar David wrote:
> > >> On Sat, Aug 13, 2016 at 10:38 PM, Fernando Fuentes <ffuentes at darktcp.net>
> > >> wrote:
> > >> > Team,
> > >> >
> > >> > I got two oVirt Servers. One in 4.0.2 and one in 3.6.X
> > >> > I love the new 4.0 dashboard, But I need a way to continue to build
> > >> > reports with ease, 3.6 Can do this with ovirt-reports. How can I make my
> > >> > oVirt 4.0.2 send data for reports to my ovirt reports on 3.6?
> > >> >
> > >> > Thanks for the help team!
> > >>
> > >> I didn't try this myself, but pointing your reports setup to the 4.0 dwh
> > >> database should work. If you have problems, please give more details -
> > >> it's not clear what exactly you have on each machine.
> > >>
> > >> Generally speaking, oVirt does not currently provide tools to make
> > >> the engine or dwh "send data" elsewhere (a 3.6 reports or whatever).
> > >> You can try doing this yourself using generic postgresql means/tools.
> > >>
> > >> Best
> > >> --
> > >> Didi
> > 
> > 
> > 
> > -- 
> > Didi
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users