Error: "value too long for type character varying(128)" when attempting to update email settings in Cloud Director

Products

• VMware Cloud Director

Issue/Introduction

• Cannot update email settings for a new Organization/Tenant.
• Cannot update existing email settings with a new password.
• Receive the following error when attempting to update email settings

value too long for type character varying(128)

• In the UI, the following SQL is presented as causing the issue

update smtp_server set password='<length longer than 128>', port=<port>, server='<server>', secure_mode='NONE', ssl_truststore=NULL, use_authentication='TRUE', user_name='<user@domain>' where org_id='<ORG_ID>'

Environment

Cloud Director 10.5.x

Cause

This issue will occur when you attempt to use a long password within the email settings.

Cloud Director will hash the password being sent, with the hashing process adding additional length to the string, taking over the 128 characters allowed in the database.

Resolution

This is not a bug in Cloud Director but simply a character limit that has been exceeded.

• If you have the option of reducing the password length please do so.
• Alternatively, if you need to keep the password length as is, please engage Broadcom Support.