Error in Dashboard view on SDDC Manager UI when logged as AD user with more that 40 characters in the user's UPN

Products

• VMware Cloud Foundation

Issue/Introduction

Symptoms:
Dashboard view on SDDC Manager has a red banner with the following error message:

"Failed to save dashboard configuration. Encountered error requesting dashboard config POST API - value too long for type character varying(40)"

The user is logged into the UI with AD credentials.

The username in UPN format is greater than 40 characters.

e.g. [email protected]

The UI logs will contain entries similar to:

3-05-23T09:12:32.869+0000 VERBOSE [7c88b1f645274c19] [../node_modules/winston/node_modules/readable-stream/lib/_stream_writable.js, http-get-workflows, on
write:483] Start csrfErrorLogger()
2023-05-23T09:12:32.872+0000 ERROR [7c88b1f645274c19] [../internal/process/task_queues.js, http-get-workflows, processTicksAndRejections:82] Sending error re
sponse: {"upn":"[email protected]","id":"43310852-1f52-4adf-90ab-5052eca33020","requestedPath":"/ui/api/internal/dashboard/settings"
,"error":{"length":98,"name":"error","severity":"ERROR","code":"22001","file":"varchar.c","line":"624","routine":"varchar"},"stack":"error: Encountered error requesting dashboard config POST API - value too long for type character varying(40)\n at Parser.parseErrorMessage (/opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/pg-protocol/dist/parser.js:287:98)\n at Parser.handlePacket (/opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/pg-protocol/dist/parser.js:126:29)\n at Parser.parse (/opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/pg-protocol/dist/parser.js:39:38)\n at Socket.<anonymous> (/opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/pg-protocol/dist/index.js:11:42)\n at Socket.emit (events.js:400:28)\n at addChunk (internal/streams/readable.js:290:12)\n at readableAddChunk (internal/streams/readable.js:265:9)\n at Socket.Readable.push (internal/streams/readable.js:204:10)\n
at TCP.onStreamRead (internal/stream_base_commons.js:188:23)\n at TCP.callbackTrampoline (internal/async_hooks.js:131:17)"}

Environment

VMware Cloud Foundation 4.x

Cause

This is caused by a default limit of 40 characters on the upn row of the user_preferences table in the sddc_manager_ui database schema. When the username in UPN format exceeds 40 characters, the error is thrown.

Resolution

Please open a ticket with Broadcom Support. 

Additional Information