ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Vertica backup failing


Article ID: 4326


Updated On:


CA Infrastructure Management CA Infrastructure Management CA Performance Management - Usage and Administration


When running the vertica backup it fails with the following error:

"When communicating with vertica, the process failed with code 1 backup failed!"


As the error is generic, you should run the backup with the --debug3 flag:


/opt/vertica/bin/ --task backup --config-file /path to .ini file/<filename>.ini --debug=3 

This identified the following error:

vsql: FATAL 3781: Invalid username or password 

Cannot connect to vertica database, please check server status or db parameters 

backup failed! 




To resolve, simply review the .ini file that was created to run the backup and change either the dbUser value or the password in the passwordFile, or possibly both.  The dbUser should be set to the same user that you use to open adminTools.  After doing this just rerun the backup and it should complete successfully