This was caused by the following.
The updatecli.log shows the /opt/vmware/hms/conf/embedded_db.cfg as below.
+ '[' -r /opt/vmware/hms/conf/embedded_db.cfg ']'
+ source /opt/vmware/hms/conf/embedded_db.cfg
++ EMB_DB_INSTALL_DIR=/opt/vmware/vpostgres/9.5
++ EMB_DB_INSTANCE=vrmsdb
++ EMB_DB_VCTA_INSTANCE=vctadb
++ EMB_DB_USER=vrmsdb
++ EMB_DB_PASSWORD=unused
++ EMB_DB_STORAGE=/var/lib/vrmsdb
++ EMB_DB_MAX_CONNECTIONS=150
The correct value is
The updatecli.log shows the embedded_db.cfg as below.
+ '[' -r /opt/vmware/hms/conf/embedded_db.cfg ']'
+ source /opt/vmware/hms/conf/embedded_db.cfg
++ EMB_DB_INSTALL_DIR=/opt/vmware/vpostgres/current
++ EMB_DB_INSTANCE=vrmsdb
++ EMB_DB_VCTA_INSTANCE=vctadb
++ EMB_DB_USER=vrmsdb
++ EMB_DB_PASSWORD=unused
++ EMB_DB_STORAGE=/var/lib/vrmsdb
++ EMB_DB_MAX_CONNECTIONS=150