<div dir="ltr"><div>Hi,</div><div><br></div><div>Did you install ovirt-engine-dwh during the upgrade? Was it installed before?</div>If it is installed , Can you please check the ovirt-engine-dwh.log file for errors?<div>If not, It must be installed in order to view the Dashboards. It is collecting the statistics used for the dashboards.</div><div><br></div><div>Best regards,</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif;font-size:12.8px">Shirly Radco</span><br></pre><pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif">BI Software Engineer
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109</span></pre></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On Thu, Aug 25, 2016 at 9:28 AM, Maton, Brett <span dir="ltr"><<a href="mailto:matonb@ltresources.co.uk" target="_blank">matonb@ltresources.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div>I've just upgraded Ovirt3.6 to 4.0.2 and I can't get the dashboard to work.<br><br></div><div>The dashboard page displays this error:<br><br><span style="font-size:15px">Could not fetch dashboard data. Please ensure that data warehouse is properly installed and configured.</span><br></div><div><br></div><div>Running on CentOS 7.2<br></div><div>PostgreSQL server 9.5.4 (remote)<br></div><div><br>I see these errors being generated in engine.log when I try to display the dash board<br><br> ERROR [org.ovirt.engine.ui.frontend.<wbr>server.dashboard.<wbr>DashboardDataServlet] (default task-6) [] Unable to retrieve dashboard data: org.ovirt.engine.ui.frontend.<wbr>server.dashboard.<wbr>DashboardDataException: Error while running SQL query<br> at org.ovirt.engine.ui.frontend.<wbr>server.dashboard.dao.BaseDao.<wbr>runQuery(BaseDao.java:60) [frontend.jar:]<br> at org.ovirt.engine.ui.frontend.<wbr>server.dashboard.dao.<wbr>HostDwhDao.<wbr>getTotalCpuMemCount(<wbr>HostDwhDao.java:78) [frontend.jar:]<br>...<br>Caused by: javax.resource.<wbr>ResourceException: IJ031083: Wrong driver class [org.postgresql.Driver] for this connection URL [None]<br> at org.jboss.jca.adapters.jdbc.<wbr>local.<wbr>LocalManagedConnectionFactory.<wbr>createLocalManagedConnection(<wbr>LocalManagedConnectionFactory.<wbr>java:321)<br> ... 66 more<br><br><br><br><br></div>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<br><br></div>I checked the class path generated by dwh-classpath.sh which seems to be using the correct JDBC driver.<br><br># /usr/share/ovirt-engine-dwh/<wbr>bin/dwh-classpath.sh run<br>:/usr/share/java/dom4j.jar:/<wbr>usr/share/java/apache-commons-<wbr>collections.jar:/usr/share/<wbr>java/postgresql-jdbc.jar<br><br># rpm -qf /usr/share/java/postgresql-<wbr>jdbc.jar<br>postgresql-jdbc-9.2.1002-5.<wbr>el7.noarch<br><br><br></div>Any suggestions on what to try next?<br></div>
<br>______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>