Data Aggregator install failed to pass the pre-requisite checking for the Vertica database 100161

Products

• CA Performance Management - Usage and Administration
• CA Infrastructure Management

Issue/Introduction

The following error is displayed while installing the Data Aggregator:

Error code: 1
Description: unable to execute test to verify that user is a superuser; cause: [Vertica][VJDBC](100161) The connection is closed.

Environment

DX NetOps Performance Management 20.2.5

Cause

Even though there is no connection issue from the DA machine to the DR machine, the test is failing during the DA installation.

Copied the  /opt/vertica/bin/vsql file from the DR to the DA machine and run the following syntax:

./vsql -h <DR_hostname_or_IP> -U dradmin -w dbpass -c 'select version()'

./vsql -h <DR_hostname_or_IP> -U dradmin -w dbpass -c '\dn'

You can find the dradmin password in the drinstall.properties file:

$ cat /opt/CA/IMDataRepository_vertica9/drinstall.properties

# Database password
# Comment out with # to provide password interactively
DbPwd=dbpass

Resolution

Shutdown and start the Data Repository

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/20-2/administrating/restart-ca-performance-management-component-services/restart-the-data-repository.html