Data Aggregator cannot connect to Data Repository after migration step of restoring files.

Products

• Network Observability
• CA Performance Management

Issue/Introduction

DA will not start after the migration step of restoring files.

In the DA_INSTALL_DIR/apache-karaf/data/logs/karaf.log we see the error:

ERROR | read-1-toHost:<HOSTNAME> | 2024-02-20T10:22:26,953 | shutdown | ase.heartbeat.DBStateManagerImpl  747 | ommon.core.services.impl |       | DB heartbeat to host <HOSTNAME> failed.  Query attempt took 0:00:00.004
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLInvalidAuthorizationSpecException: [Vertica][VJDBC](3781) FATAL: Invalid username or password
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:84) ~[bundleFile:?]
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376) ~[bundleFile:?]
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:431) ~[bundleFile:?]
        at com.ca.im.core.services.database.heartbeat.DBStateManagerImpl$StateCheckTask.run(DBStateManagerImpl.java:205) ~[bundleFile:?]
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) ~[?:?]
        at java.util.concurrent.FutureTask.runAndReset(Unknown Source) ~[?:?]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[?:?]
        at java.lang.Thread.run(Unknown Source) ~[?:?]
Caused by: java.sql.SQLInvalidAuthorizationSpecException: [Vertica][VJDBC](3781) FATAL: Invalid username or password
        at com.vertica.util.ServerErrorData.buildException(Unknown Source) ~[?:?]
        at com.vertica.io.ProtocolStream.authenticate(Unknown Source) ~[?:?]
        at com.vertica.io.ProtocolStream.initSession(Unknown Source) ~[?:?]
        at com.vertica.core.VConnection.tryConnect(Unknown Source) ~[?:?]
        at com.vertica.core.VConnection.connect(Unknown Source) ~[?:?]
        at com.vertica.jdbc.common.BaseConnectionFactory.doConnect(BaseConnectionFactory.java:223) ~[?:?]
        at com.vertica.jdbc.common.AbstractDataSource.getSimbaConnection(AbstractDataSource.java:624) ~[?:?]
        at com.vertica.jdbc.common.AbstractDataSource.getConnection(AbstractDataSource.java:174) ~[?:?]
        at com.vertica.jdbc.common.AbstractDataSource.getConnection(AbstractDataSource.java:195) ~[?:?]
        at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDataSource(PooledConnection.java:278) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:226) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:769) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:697) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:496) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:154) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:121) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:110) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:134) ~[bundleFile:?]
        at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:160) ~[bundleFile:?]
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:118) ~[bundleFile:?]
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81) ~[bundleFile:?]
        ... 9 more
Caused by: com.vertica.support.exceptions.InvalidAuthorizationException: [Vertica][VJDBC](3781) FATAL: Invalid username or password
        at com.vertica.util.ServerErrorData.buildException(Unknown Source) ~[?:?]
        at com.vertica.io.ProtocolStream.authenticate(Unknown Source) ~[?:?]
        at com.vertica.io.ProtocolStream.initSession(Unknown Source) ~[?:?]
        at com.vertica.core.VConnection.tryConnect(Unknown Source) ~[?:?]
        at com.vertica.core.VConnection.connect(Unknown Source) ~[?:?]
        at com.vertica.jdbc.common.BaseConnectionFactory.doConnect(BaseConnectionFactory.java:223) ~[?:?]
        at com.vertica.jdbc.common.AbstractDataSource.getSimbaConnection(AbstractDataSource.java:624) ~[?:?]
        at com.vertica.jdbc.common.AbstractDataSource.getConnection(AbstractDataSource.java:174) ~[?:?]
        at com.vertica.jdbc.common.AbstractDataSource.getConnection(AbstractDataSource.java:195) ~[?:?]
        at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDataSource(PooledConnection.java:278) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:226) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:769) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:697) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:496) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:154) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:121) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:110) ~[bundleFile:?]
        at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:134) ~[bundleFile:?]
        at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:160) ~[bundleFile:?]
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:118) ~[bundleFile:?]
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81) ~[bundleFile:?]
        ... 9 more
WARN  | read-1-toHost:<HOSTNAME> | 2024-02-20T10:22:26,955 | shutdown | ase.heartbeat.DBStateManagerImpl  813 | ommon.core.services.impl |       | DB state for host <HOSTNAME> changing from INIT to DOWN

Environment

22.2.5

Cause

The passwords for the DA User were different between the two systems.

Resolution

When installing the Data Aggregator you are migrating to, use the same password as the source system for all passwords.