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 -- Scott Dickerson Senior Software Engineer RHEV-M Engineering - UX Team Red Hat, Inc _______________________________________________ Devel mailing list Devel@ovirt.org http://lists.phx.ovirt.org/mailman/listinfo/devel Yanir Quinn yquinn@redhat.com via <https://support.google.com/mail/answer/1311182?hl=en&authuser=1> ovirt.org 12/12/16 to Scott, devel setting DASHBOARD_CACHE_UPDATE=false indeed stops the issue. Thanks. _______________________________________________ Devel mailing list Devel@ovirt.org http://lists.phx.ovirt.org/mailman/listinfo/devel 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.

...

...

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

On Thu, Apr 13, 2017 at 5:51 AM, shubham dubey <sdubey504@gmail.com> wrote: 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

Thanks,the error is resolved. On Tue, Apr 18, 2017 at 1:23 PM, Maor Lipchuk <mlipchuk@redhat.com> wrote:

On Tue, Apr 18, 2017 at 10:50 AM, Maor Lipchuk <mlipchuk@redhat.com> wrote:

...

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

Deleted the extra copied info, it should be irrelevant.

...

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.

...

...

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

On Thu, Apr 13, 2017 at 5:51 AM, shubham dubey <sdubey504@gmail.com> wrote: 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.DashboardDataE xception: Error while running SQL query

at org.ovirt.engine.ui.frontend.server.dashboard.dao.BaseDao.ru nQuery (BaseDao.java:60)> [frontend.jar:]

at org.ovirt.engine.ui.frontend.s erver.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(DashboardDataSe rvlet.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(DashboardDataS ervlet.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(Executor s.java :511)

[rt.jar:1.8.0_121]

at java.util.concurrent.FutureTas k.runAndReset(FutureTask.java:308)

[rt.jar:1.8.0_121]

at org.glassfish.enterprise.concurrent.internal.

ManagedScheduledThreadPoolExecutor$ManagedScheduledFutureTas k.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(ThreadPool Execut or.java:1142)> [rt.jar:1.8.0_121]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo lExecu 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.concu rrent.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.Wr apperDataSource.getConnection(

WrapperDataSource.java:146)

at org.jboss.as.connector.subsyst ems.datasources.WildFlyDataSource.

getConnection(WildFlyDataSource.java:66)

at org.ovirt.engine.ui.frontend.server.dashboard.dao.BaseDao.ru nQuery (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.connectionm anager.AbstractConnectionManager.

getManagedConnection(AbstractConnectionManager.java:656)

at org.jboss.jca.core.connectionm anager.tx.TxConnectionManagerImpl.

getManagedConnection(TxConnectionManagerImpl.java:429)

at org.jboss.jca.core.connectionm anager.AbstractConnectionManager.

allocateConnection(AbstractConnectionManager.java:747)

at org.jboss.jca.adapters.jdbc.Wr apperDataSource.getConnection(

WrapperDataSource.java:138)

... 18 more

Caused by: javax.resource.ResourceException: IJ031084: Unable to create connection

at org.jboss.jca.adapters.jdbc.lo cal.LocalManagedConnectionFactory.

createLocalManagedConnection(LocalManagedConnectionFactory.java:345)

at org.jboss.jca.adapters.jdbc.lo cal.LocalManagedConnectionFactory.

getLocalManagedConnection(LocalManagedConnectionFactory.java:352)

at org.jboss.jca.adapters.jdbc.lo cal.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.connectionm anager.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