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