Description:
Symptoms;
Your MTP collector has stopped.
And maybe the system is down since a power outage? And or a network interruption?
The Analysis page on the collector is hanging (update circle running) and showing error;
"Could not open database connection. Error in SqlCommand at Execute:"
On the SA Admin page the collector status is stopped and it cannot be started (action failed).
All attempts to start the DB are futile and after a reboot the DB status goes into state of "INITIALIZING"
Did you have a power outage? It's possible that the Vertica database has been corrupted.
And it's possible you may need to stop and recreate the database.
If in any doubt about following these steps, then please raise a support case with CA support.
Solution:
Fix steps, if stop and recreate is required.
All should now be fine.