Error during Data Repository 21.2.3 Vertica database upgrade
search cancel

Error during Data Repository 21.2.3 Vertica database upgrade


Article ID: 223993


Updated On:


CA Performance Management - Usage and Administration DX NetOps


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 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.


DX NetOps Performance Management release 21.2.3


Improper call made during upgrade triggers the error.


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 script again.