ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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.


Improper call made during upgrade triggers the error.


DX NetOps Performance Management release 21.2.3


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.