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