"Event not found" error displayed when logging on Vertica vsql prompt

Products

• CA Performance Management - Usage and Administration

Issue/Introduction

When logging in Vertica using vsql prompt in Data Repository (DR) server, you can get the "event not found" error, as below:

Environment

Performance Management 3.7

Cause

In this case, the error occurred since the password has the "!" special character on it, and the password was not enclosured with single quotes.

Resolution

You have 2 options:

1- Enclosure the password with single quotes:

/opt/vertica/bin/vsql -U dradmin -w 'CA!a'

2- Suppress the "-w" parameter. This way, you will be prompted to enter the password:

/opt/vertica/bin/vsql -U dradmin