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

book

Article ID: 206580

calendar_today

Updated On:

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.

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

Environment

DX NetOps Performance Management 20.2.5

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

Attachments