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

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

book

Article ID: 344800

calendar_today

Updated On:

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';