Error during Data Repository 21.2.3 Vertica database upgrade

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

DX NetOps Performance Management Data Repository 21.2.3 upgrade includes an upgrade to a new Vertica version.

The following error may be observed when running the dr_install.sh to upgrade the Data Repository Vertica database to 21.2.3.

Text version of error:

Error code: 1
Description: unable to execute SQL statement; cause: [Vertica][JDBC](11320) A RowCount was expected but not generated from query "select set_config_parameter('SecurityAlgorithm','SHA512')". Query not executed.

Environment

DX NetOps Performance Management release 21.2.3

Cause

Improper call made during upgrade triggers the error.

Resolution

This will be resolved in the 21.2.4 release of DX NetOps Performance Management.

To work around the problem until 21.2.4 is released take the following steps.

1. Log into the Vertica Vsql prompt as the dradmin user
2. Run the command that failed:
   1. select set_config_parameter('SecurityAlgorithm','SHA512');
3. Run the dr_install.sh script again.