[ovirt-users] Empty ovirt engine web pages

[Alexander Wels]

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 at 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 at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users