[ovirt-users] Ovirt 4.0.5 reporting dashboard not working.

[Shirly Radco]

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 at 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 at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20161208/56dd6b73/attachment-0001.html>