Error during Data Repository 21.2.3 Vertica database upgrade

book

Article ID: 223993

calendar_today

Updated On:

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.

Cause

Improper call made during upgrade triggers the error.

Environment

DX NetOps Performance Management release 21.2.3

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.

Attachments