My Oracle Support Banner

OLVM: AdminPortal Fails to Fetch Dashboard Data (Doc ID 2761131.1)

Last updated on MARCH 19, 2021

Applies to:

Linux OS - Version Oracle Linux 7.8 with Unbreakable Enterprise Kernel [4.14.35] and later
Linux x86-64

Symptoms

Dashboard fails to fetch data:


ovirt-engine-dwhd.log:

2021-02-17 16:08:59|1XjhFL|xJMhzB|xJMhzB|OVIRT_ENGINE_DWH|MinimalVersionCheck|Default|6|Java Exception|tJDBCConnection_2|org.postgresql.util.PSQLExceptio
n:FATAL: Ident authentication failed for user "ovirt_engine_history"|1
Exception in component tRunJob_2
java.lang.RuntimeException: Child job running failed
at ovirt_engine_dwh.historyetl_4_3.HistoryETL.tRunJob_2Process(HistoryETL.java:8323)
at ovirt_engine_dwh.historyetl_4_3.HistoryETL$3.run(HistoryETL.java:11811)
Exception in component tJDBCConnection_2
org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "ovirt_engine_history"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:34)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at routines.system.SharedDBConnection.getConnection(SharedDBConnection.java:63)
at routines.system.SharedDBConnection.getDBConnection(SharedDBConnection.java:131)
at ovirt_engine_dwh.parallelrun_4_3.ParallelRun.tJDBCConnection_2Process(ParallelRun.java:1209)
at ovirt_engine_dwh.parallelrun_4_3.ParallelRun.tJDBCConnection_1Process(ParallelRun.java:1126)
at ovirt_engine_dwh.parallelrun_4_3.ParallelRun.tPrejob_1Process(ParallelRun.java:1001)
at ovirt_engine_dwh.parallelrun_4_3.ParallelRun.runJobInTOS(ParallelRun.java:5597)
at ovirt_engine_dwh.parallelrun_4_3.ParallelRun.runJob(ParallelRun.java:5276)
at ovirt_engine_dwh.historyetl_4_3.HistoryETL.tRunJob_4Process(HistoryETL.java:1731)
at ovirt_engine_dwh.historyetl_4_3.HistoryETL$2.run(HistoryETL.java:11765)
2021-02-17 16:08:59|Wzc8Uy|xJMhzB|xJMhzB|OVIRT_ENGINE_DWH|ParallelRun|Default|6|Java Exception|tJDBCConnection_2|org.postgresql.util.PSQLException:FATAL: Ident authentication failed for user "ovirt_engine_history"|1

Server.log:

2021-02-17 16:08:49,444+08 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (ServerService Thread Pool -- 56) IJ000604: Throwable while
attempting to get a new connection: null: 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(SemaphoreConcu
rrentLinkedDequeManagedConnectionPool.java:1325)
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDeque
ManagedConnectionPool.java:499)
Caused by: org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "ovirt_engine_history"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:473) [postgresql.jar:42.2.2]
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:205) [postgresql.jar:42.2.2]
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) [postgresql.jar:42.2.2]
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) [postgresql.jar:42.2.2]
at org.postgresql.Driver.makeConnection(Driver.java:452) [postgresql.jar:42.2.2]
at org.postgresql.Driver.connect(Driver.java:254) [postgresql.jar:42.2.2]
at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:321)
... 60 more

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.