Hello Shirly,

I restarted dwh service as per your suggestion with no success.

 

Here a sample of DWH log:

2016-12-14 12:31:55|kdcGa9|GCXnuH|PIv06L|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-12-14 12:32:20|ncjn2O|GCXnuH|PIv06L|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-12-14 15:52:37|Xx2zzb|GCXnuH|PIv06L|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-12-16 17:39:13|ETL Service Stopped

2016-12-16 17:39:14|ETL Service Started

ovirtEngineDbDriverClass|org.postgresql.Driver

ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory

hoursToKeepDaily|0

hoursToKeepHourly|720

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.5

dwhAggregationDebug|false

dwhUuid|a18846e6-d188-4170-8549-aeb1c54fa390

ovirtEngineHistoryDbDriverClass|org.postgresql.Driver

ovirtEngineHistoryDbPassword|**********************

 

 

And here a sample of Engine.log

 

2016-12-19 04:32:05,939 WARN  [org.ovirt.engine.core.vdsbroker.irsbroker.IrsProxyData] (DefaultQuartzScheduler5) [53791585] Domain '05c01989-18a1-4a45-9ed6-76c6badc728a:intel2-dstore04' report isn't an actual report

2016-12-19 04:32:05,939 WARN  [org.ovirt.engine.core.vdsbroker.irsbroker.IrsProxyData] (DefaultQuartzScheduler5) [53791585] Domain 'f0d8ea03-17ab-4feb-bbf8-408e0550fc29:boole2-dstore1' report isn't an actual report

 

 

So apparently DWH is working, but that “report isn't an actual report” is quite obscure to me.

I need to clarify that (almost) all these storages are iscsi SAN hosted and have been detached from Ovirt3 installation and IMPORTED into Ovirt4.

 

Could you suggest for next step?

Thanks

Andrea

 

From: Shirly Radco [mailto:sradco@redhat.com]
Sent: Thursday, December 8, 2016 10:22 AM
To: Andrea Ghelardi <a.ghelardi@iontrading.com>
Cc: users <users@ovirt.org>
Subject: Re: [ovirt-users] Ovirt 4.0.5 reporting dashboard not working.

 

Hi Andrea,

 

Please try to restart the dwh service. 

It is the service that collects the samples data from the engine database to a data warehouse, ovirt_engine_history.

run:

 

service ovirt-engine-dwhd restart

 

and send me the log again.

 

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.

Best regards,

Shirly Radco

BI Software Engineer

Red Hat Israel Ltd.

34 Jerusalem Road

Building A, 4th floor

Ra'anana, Israel 4350109

 

On Wed, Dec 7, 2016 at 5:43 PM, Andrea Ghelardi <a.ghelardi@iontrading.com> wrote:

Hello group,

I noticed that my dashboard does not show little colored “cubes” which show storage CPU and RAM usage history status.

Attached an image and logs from /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log

Here’s an extract:

 

Exception in component tJDBCInput_5

org.postgresql.util.PSQLException: ERROR: smallint out of range

        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.statisticssync_4_0.StatisticsSync.tJDBCInput_5Process(StatisticsSync.java:4056)

        at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync$3.run(StatisticsSync.java:15979)

Exception in component tJDBCInput_8

org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

        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.statisticssync_4_0.StatisticsSync.tJDBCInput_8Process(StatisticsSync.java:5991)

        at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync$4.run(StatisticsSync.java:16025)

2016-11-27 14:27:40|tm1tT6|GCXnuH|0jajaj|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java Exception|tJDBCInput_5|org.postgresql.util.PSQLException:ERROR: smallint out of range|1

 

This is a quite fresh new installation, and restarting engine VM (hosted-engine –vm-stop + hosted-engine –vm-start) does not fix the problem.

Ovirt is behaving normally.

 

Any clue?

Cheers

Andrea

 

_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users