PM: Vertica issues after problematic DR / Vertica upgrade

Products

• Network Observability
• CA Performance Management

Issue/Introduction

If you upgrade your DX NetOps Performance Management Data Repository and run into issues such as out of space issues during the upgrade of a cluster node, manage to get vertica upgraded but have problems with library packages such as the one below:

Caused by: com.vertica.util.ClientSyntaxErrorException: [Vertica][VJDBC](6999) ERROR: The library [VFunctionsLib] for the function [LISTAGG(varchar)] was compiled with an incompatible SDK Version [23.4.0]

We can manually run the install packages again across the enture cluster. 

Environment

DX NetOps Performance Management

PM Data Repository

Vertica

Cause

During the initial upgrade, the library packages were not installed to all nodes properly.

Resolution

To repair the packages run:

admintools -t install_package --package=default --force-reinstall -d drdata -p PASSWORD

The output should look like the below:

Content: 
Checking whether package ComplexTypes is already installed...
Installing package ComplexTypes...
...Success!
Checking whether package DelimitedExport is already installed...
Installing package DelimitedExport...
...Success!
Checking whether package JsonExport is already installed...
Installing package JsonExport...
...Success!
Checking whether package MachineLearning is already installed...
Installing package MachineLearning...
STATUS: vertica.engine.api.vsql_script.module is still running on 1 host: x.x.x.x as of 2026-03-10 11:31:53. See /opt/vertica/log/adminTools.log for full details.
...Success!
Checking whether package OrcExport is already installed...
Installing package OrcExport...
...Success!
Checking whether package ParquetExport is already installed...
Installing package ParquetExport...
...Success!
Checking whether package VFunctions is already installed...
Installing package VFunctions...
...Success!
Checking whether package approximate is already installed...
Installing package approximate...
...Success!
Checking whether package flextable is already installed...
Installing package flextable...
...Success!
Checking whether package kafka is already installed...
Installing package kafka...
...Success!
Checking whether package logsearch is already installed...
Installing package logsearch...
...Success!
Checking whether package place is already installed...
Installing package place...
...Success!
Checking whether package txtindex is already installed...
Installing package txtindex...
...Success!
Checking whether package voltagesecure is already installed...
Installing package voltagesecure...
...Success!