Re: [ovirt-users] Could not fetch dashboard data. Please ensure that data warehouse is properly installed and configured.

[Shirly Radco]

Hi,

Did you install ovirt-engine-dwh during the upgrade? Was it installed
before?
If it is installed , Can you please check the ovirt-engine-dwh.log file for
errors?
If not, It must be installed in order to view the Dashboards. It is
collecting the statistics used for the dashboards.

Best regards,

Shirly Radco

BI Software Engineer
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109


On Thu, Aug 25, 2016 at 9:28 AM, Maton, Brett 
wrote:

> I've just upgraded Ovirt3.6 to 4.0.2 and I can't get the dashboard to work.
>
> The dashboard page displays this error:
>
> Could not fetch dashboard data. Please ensure that data warehouse is
> properly installed and configured.
>
> Running on CentOS 7.2
> PostgreSQL server 9.5.4 (remote)
>
> I see these errors being generated in engine.log when I try to display the
> dash board
>
>  ERROR [org.ovirt.engine.ui.frontend.server.dashboard.DashboardDataServlet]
> (default task-6) [] Unable to retrieve dashboard data:
> org.ovirt.engine.ui.frontend.server.dashboard.DashboardDataException:
> Error while running SQL query
> at 
> org.ovirt.engine.ui.frontend.server.dashboard.dao.BaseDao.runQuery(BaseDao.java:60)
> [frontend.jar:]
> at org.ovirt.engine.ui.frontend.server.dashboard.dao.HostDwhDao.
> getTotalCpuMemCount(HostDwhDao.java:78) [frontend.jar:]
> ...
> Caused by: javax.resource.ResourceException: IJ031083: Wrong driver class
> [org.postgresql.Driver] for this connection URL [None]
> at org.jboss.jca.adapters.jdbc.local.
> LocalManagedConnectionFactory.createLocalManagedConnection(
> LocalManagedConnectionFactory.java:321)
> ... 66 more
>
>
>
>
> Google returned some hints that it's probably the postgresql java version,
> I did have 9.4.xxx installed bu have since downgraded to
> postgresql-jdbc-9.2.1002-5
>
> I checked the class path generated by dwh-classpath.sh which seems to be
> using the correct JDBC driver.
>
> # /usr/share/ovirt-engine-dwh/bin/dwh-classpath.sh run
> :/usr/share/java/dom4j.jar:/usr/share/java/apache-commons-
> collections.jar:/usr/share/java/postgresql-jdbc.jar
>
> # rpm -qf /usr/share/java/postgresql-jdbc.jar
> postgresql-jdbc-9.2.1002-5.el7.noarch
>
>
> Any suggestions on what to try next?
>
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

[ovirt-users] Could not fetch dashboard data. Please ensure that data warehouse is properly installed and configured.

[Maton, Brett]

I've just upgraded Ovirt3.6 to 4.0.2 and I can't get the dashboard to work.

The dashboard page displays this error:

Could not fetch dashboard data. Please ensure that data warehouse is
properly installed and configured.

Running on CentOS 7.2
PostgreSQL server 9.5.4 (remote)

I see these errors being generated in engine.log when I try to display the
dash board

 ERROR [org.ovirt.engine.ui.frontend.server.dashboard.DashboardDataServlet]
(default task-6) [] Unable to retrieve dashboard data:
org.ovirt.engine.ui.frontend.server.dashboard.DashboardDataException: Error
while running SQL query
at
org.ovirt.engine.ui.frontend.server.dashboard.dao.BaseDao.runQuery(BaseDao.java:60)
[frontend.jar:]
at
org.ovirt.engine.ui.frontend.server.dashboard.dao.HostDwhDao.getTotalCpuMemCount(HostDwhDao.java:78)
[frontend.jar:]
...
Caused by: javax.resource.ResourceException: IJ031083: Wrong driver class
[org.postgresql.Driver] for this connection URL [None]
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:321)
... 66 more




Google returned some hints that it's probably the postgresql java version,
I did have 9.4.xxx installed bu have since downgraded to
postgresql-jdbc-9.2.1002-5

I checked the class path generated by dwh-classpath.sh which seems to be
using the correct JDBC driver.

# /usr/share/ovirt-engine-dwh/bin/dwh-classpath.sh run
:/usr/share/java/dom4j.jar:/usr/share/java/apache-commons-collections.jar:/usr/share/java/postgresql-jdbc.jar

# rpm -qf /usr/share/java/postgresql-jdbc.jar
postgresql-jdbc-9.2.1002-5.el7.noarch


Any suggestions on what to try next?
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users