Hi Shubham,

In case you do not need the DWH setup, you can disable the Dashboard background queries via the ovirt-engine.conf.

Please, add the following file to your $DEV_OVIRT_PREFIX folder:

 "$DEV_OVIRT_PREFIX/etc/ovirt-engine/engine.conf.d/99-no-dashboard.conf"

and add it the following content:

     #
     # Enable/disable updating the dashboard DB query caches at regular intervals.
     #
     DASHBOARD_CACHE_UPDATE=false

This should stop the error message

Regards,

Maor

On Mon, Apr 17, 2017 at 3:50 PM, Alexander Wels <awels@redhat.com> wrote:

On Friday, April 14, 2017 9:38:23 AM EDT Sandro Bonazzola wrote:
> Adding Martin
>

That exception is telling you it can't run the queries needed to populate the
dashboard. Highly likely you don't have the DWH properly installed/configured.
That still shouldn't give you just a blank page, the code is written to
display an error stating unable to display dashboard or something of that
nature.

> On Thu, Apr 13, 2017 at 5:51 AM, shubham dubey <sdubey504@gmail.com> wrote:
> > Hello,
> > I have installed ovirt engine from source and installed all other required
> > packages also,
> > including ovirt-js-dependencies.But when I am login to the admin account I
> > am getting blank
> > page everytime. Some other pages are also coming empty sometime.
> > I have pasted the logs for $HOME/ovirt-engine/share/
> > ovirt-engine/services/ovirt-engine/ovirt-engine.py start[1].The possible
> > error log is
> >
> > 2017-04-13 09:07:09,902+05 ERROR [org.ovirt.engine.ui.frontend.
> > server.dashboard.DashboardDataServlet.CacheUpdate.Utilization]
> > (EE-ManagedThreadFactory-default-Thread-1) [] Could not update the
> > Utilization Cache: Error while running SQL query:
> > 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:]
> >
> >        at org.ovirt.engine.ui.frontend.server.dashboard.
> >
> > HourlySummaryHelper.getTotalCpuMemCount(HourlySummaryHelper.java:43)
> > [frontend.jar:]
> >
> >        at org.ovirt.engine.ui.frontend.server.dashboard.
> >
> > HourlySummaryHelper.getCpuMemSummary(HourlySummaryHelper.java:21)
> > [frontend.jar:]
> >
> >        at org.ovirt.engine.ui.frontend.server.dashboard.
> >
> > DashboardDataServlet.lookupGlobalUtilization(DashboardDataServlet.java:294
> > )
> > [frontend.jar:]
> >
> >        at org.ovirt.engine.ui.frontend.server.dashboard.
> >
> > DashboardDataServlet.getDashboard(DashboardDataServlet.java:268)
> > [frontend.jar:]
> >
> >        at org.ovirt.engine.ui.frontend.server.dashboard.
> >
> > DashboardDataServlet.populateUtilizationCache(DashboardDataServlet.java:23
> > 1) [frontend.jar:]
> >
> >        at org.ovirt.engine.ui.frontend.server.dashboard.
> >
> > DashboardDataServlet.access$000(DashboardDataServlet.java:26)
> > [frontend.jar:]
> >
> >        at org.ovirt.engine.ui.frontend.server.dashboard.
> >
> > DashboardDataServlet$1.run(DashboardDataServlet.java:106) [frontend.jar:]
> >
> >        at
> >        java.util.concurrent.Executors$RunnableAdapter.call(Executors.java
> >        :511)
> >
> > [rt.jar:1.8.0_121]
> >
> >        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
> >
> > [rt.jar:1.8.0_121]
> >
> >        at org.glassfish.enterprise.concurrent.internal.
> >
> > ManagedScheduledThreadPoolExecutor$ManagedScheduledFutureTask.access$201(
> > ManagedScheduledThreadPoolExecutor.java:383) [javax.enterprise.concurrent-
> > 1.0.jar:]
> >
> >        at org.glassfish.enterprise.concurrent.internal.
> >
> > ManagedScheduledThreadPoolExecutor$ManagedScheduledFutureTask.run(
> > ManagedScheduledThreadPoolExecutor.java:534) [javax.enterprise.concurrent-
> > 1.0.jar:]
> >
> >        at
> >        java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecut
> >        or.java:1142)>
> > [rt.jar:1.8.0_121]
> >
> >        at
> >        java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecu
> >        tor.java:617)>
> > [rt.jar:1.8.0_121]
> >
> >        at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_121]
> >        at org.glassfish.enterprise.concurrent.ManagedThreadFactoryImpl$
> >
> > ManagedThread.run(ManagedThreadFactoryImpl.java:250)
> > [javax.enterprise.concurrent-1.0.jar:]
> > Caused by: java.sql.SQLException: javax.resource.ResourceException:
> > IJ000453: Unable to get managed connection for java:/DWHDataSource
> >
> >        at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(
> >
> > WrapperDataSource.java:146)
> >
> >        at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.
> >
> > getConnection(WildFlyDataSource.java:66)
> >
> >        at
> >        org.ovirt.engine.ui.frontend.server.dashboard.dao.BaseDao.runQuery
> >        (BaseDao.java:53)>
> > [frontend.jar:]
> >
> >        ... 16 more
> >
> > Caused by: javax.resource.ResourceException: IJ000453: Unable to get
> > managed connection for java:/DWHDataSource
> >
> >        at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.
> >
> > getManagedConnection(AbstractConnectionManager.java:656)
> >
> >        at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.
> >
> > getManagedConnection(TxConnectionManagerImpl.java:429)
> >
> >        at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.
> >
> > allocateConnection(AbstractConnectionManager.java:747)
> >
> >        at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(
> >
> > WrapperDataSource.java:138)
> >
> >        ... 18 more
> >
> > Caused by: javax.resource.ResourceException: IJ031084: Unable to create
> > connection
> >
> >        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.
> >
> > createLocalManagedConnection(LocalManagedConnectionFactory.java:345)
> >
> >        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.
> >
> > getLocalManagedConnection(LocalManagedConnectionFactory.java:352)
> >
> >        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.
> >
> > createManagedConnection(LocalManagedConnectionFactory.java:287)
> >
> >        at org.jboss.jca.core.connectionmanager.pool.mcp.
> >
> > SemaphoreConcurrentLinkedDequeManagedConnectionPool.
> > createConnectionEventListener(SemaphoreConcurrentLinkedDeque
> > ManagedConnectionPool.java:1320)
> >
> >        at org.jboss.jca.core.connectionmanager.pool.mcp.
> >
> > SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(
> > SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:496)
> >
> >        at org.jboss.jca.core.connectionmanager.pool.AbstractPool.
> >
> > getSimpleConnection(AbstractPool.java:617)
> >
> >        at org.jboss.jca.core.connectionmanager.pool.
> >
> > AbstractPool.getConnection(AbstractPool.java:589)
> >
> >        at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.
> >
> > getManagedConnection(AbstractConnectionManager.java:590)
> >
> >        ... 21 more
> >
> > [1]https://pastebin.com/UZ5VFH7H
> >
> >
> > Thanks,
> > Shubham
> >
> > _______________________________________________
> > 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