After upgrading VMware SDDC Manager, the backup user is no longer available in the Password Management page in the UI.

Products

• VMware Cloud Foundation

Issue/Introduction

Symptoms:

• In the Password Management section on the SDDC Manager UI, the backup user is not shown. 

• Connecting to the Postgres database and review the sddc_manager_controller table, shows missing data for the BACKUP user. 

Environment

VMware Cloud Foundation 3.8.x

Cause

During a migration based upgrade, where a new SDDC Manager VM is created and the old data is copied from the older VM, data about the backup user in not migrated. 

Resolution

This is a known issue affecting VMware Cloud Foundation 3.8.

Workaround:

To workaround this issue, please see the steps below.

1. Open a SSH session to the SDDC Manager and change to the root user:
   su - 

2. Connect to the Postgres database:
   psql -h localhost -U postgres

3. Run the below command:
   update credential set entityid = ( select id from sddc_manager_controller where vm_management_ip_address='<new_sddc_vm_ip>') where entitytype='BACKUP' and credentialtype='FTP';