MTP web GUI has error Could not open database connection

Products

• APPLICATION DELIVERY ANALYSIS
• SUPERAGENT

Issue/Introduction

Description:

SSUE

The MTP web GUI has the error:

Error: Could not open database connection.Error in SqlCommand at Execute :
Data in SA from the MTP remains collecting.

This is caused by corruption in the Vertica database on the MTP, usually as a result of shutting down the MTP without gracefully shutting down the Vertica db first.

<Please see attached file for image>

Solution:

To resolve, you must recreate the Vertica database.

• SSH to the MTP
• Log in using the netqos account
• Run the following commands

sudo /opt/NetQoS/scripts/stopprocs.sh (stops all the daemon processes)
sudo /opt/NetQoS/install/setupVertica.sh --new
sudo /opt/NetQoS/install/setupReplicateMySqlToVertica.sh
sudo /opt/NetQoS/scripts/startprocs.sh

Environment

Release:
Component: NQSPRA