"Failed to create VUM database" VCSA 6.7 upgrade fails during Update Manager Firstboot

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• vCenter Server Appliance 6.7 upgrade fails during Update Manager firstboot while creating VUM Database with error:"Failed to create VUM database"
• You will see similar entries in /var/log/firstboot/updatemgr-firstboot.py_####_stdout.log

2019-04-17T22:08:04.346Z  Exception caught in checkException: Failed to create Database schema
2019-04-17 22:08:04,347  UpdateMgr received BaseInstallException '{
    "detail": [
        {
            "localized": "Failed to create VUM database",
            "translatable": "Failed to create VUM database",
            "id": "install.updatemgr.error.db_create"
        },
        {
            "localized": "Failed to setup VUM database",
            "translatable": "Failed to setup VUM database",
            "id": "install.updatemgr.error.db_setup"
        }
    ],
    "resolution": {
        "localized": "Search for these symptoms in the VMware knowledge base for any known issues and possible workarounds. If none can be found, collect a support bundle and open a  support request.",
        "translatable": "Search for these symptoms in the VMware knowledge base for any known issues and possible workarounds. If none can be found, collect a support bundle and open a  support request.",
        "id": "install.updatemgr.resolution.common"
    },
    "problemId": "install.updatemgr.firstboot",
    "componentKey": "Update Manager"
}' during action 'firstboot'.
Traceback (most recent call last):
  File "/usr/lib/vmware-updatemgr/firstboot/updatemgr-firstboot.py", line 106, in proxy
    return func(self, *args, **kwargs)
  File "/usr/lib/vmware-updatemgr/firstboot/updatemgr-firstboot.py", line 577, in _createDataBaseSchema
    raise LoggedException("Failed to create Database schema")
LoggedException: Failed to create Database schema

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/vmware-updatemgr/firstboot/updatemgr-firstboot.py", line 710, in Main
    updateMgrFB.firstbootAction()
  File "/usr/lib/vmware-updatemgr/firstboot/updatemgr-firstboot.py", line 668, in firstbootAction
    self._setupDataBase(msg)
  File "/usr/lib/vmware-updatemgr/firstboot/updatemgr-firstboot.py", line 106, in proxy
    return func(self, *args, **kwargs)
  File "/usr/lib/vmware-updatemgr/firstboot/updatemgr-firstboot.py", line 530, in _setupDataBase
    self._createDataBaseSchema(msg)
  File "/usr/lib/vmware-updatemgr/firstboot/updatemgr-firstboot.py", line 117, in proxy
    problemId="install.updatemgr.firstboot")
cis.baseCISException.BaseInstallException: {
    "detail": [
        {
            "localized": "Failed to create VUM database",
            "translatable": "Failed to create VUM database",
            "id": "install.updatemgr.error.db_create"
        },
        {
            "localized": "Failed to setup VUM database",
            "translatable": "Failed to setup VUM database",
            "id": "install.updatemgr.error.db_setup"
        }
    ],
    "resolution": {
        "localized": "Search for these symptoms in the VMware knowledge base for any known issues and possible workarounds. If none can be found, collect a support bundle and open a  support request.",
        "translatable": "Search for these symptoms in the VMware knowledge base for any known issues and possible workarounds. If none can be found, collect a support bundle and open a  support request.",
        "id": "install.updatemgr.resolution.common"
    },
    "problemId": "install.updatemgr.firstboot",
    "componentKey": "Update Manager"
}

Updatemgr-Firstboot.py:

2019-04-18 21:25:58.647 UTC 5cb8eb66.56dc 0 VCDB postgres ERROR:  role "vumuser" already exists
2019-04-18 21:25:58.647 UTC 5cb8eb66.56dc 0 VCDB postgres STATEMENT:  CREATE USER vumuser WITH PASSWORD 'yIqMtKL7=3r01$gG';
2019-04-18 21:25:59.107 UTC 5cb8eb67.5700 0 VCDB vumuser FATAL:  password authentication failed for user "vumuser"
2019-04-18 21:25:59.107 UTC 5cb8eb67.5700 0 VCDB vumuser DETAIL:  Password does not match for user "vumuser"

Environment

VMware vCenter Update Manager 6.7.x

Cause

This issue occurs when the  role "vumuser" already exists and its trying to create the user vumuser .

Resolution

• Take a backup of the VUM database.
• Take a snapshot of the VCSA appliance.
• Run the below commands to connect to DB and drop the users,
  • /opt/vmware/vpostgres/current/bin/psql -U postgres -d VCDB
  • Drop owned by vumuser;
  • Drop user vumuser;
• Re-run the VCSA upgrade process again.