Unable to remove a stale Service Account from VCF SDDC Manager UI

Products

• VMware SDDC Manager

Issue/Introduction

• Unable to delete a stale service account in VCF sddc manager UI.
• After deleting the existing AVI deployment and creating a new AVI deployment fails.  

Environment

VMware Cloud foundation 5.x
VMware Cloud Foundation 4.x

Cause

AVI deployment failed because a service account user from a previous deployment, “[email protected],” is still present in the SDDC Password Management.

Resolution

1. Take a snapshot of the SDDC Manager.
2. SSH to the SDDC Manager with the account vcf user, and switch to root account type SU
3. Validate the stale username is present in the SDDC Manager database:

   • psql -h localhost -U postgres -d platform
     or
     /usr/pgsql/13/bin/psql -h localhost -U postgres -d platform;

   • select * from credential;

4. Delete the username
   

   delete from credential WHERE username='<username identified from step # 3>'; 

5. Restart the SDDC manager services:
   
   

   /opt/vmware/vcf/operationsmanager/scripts/cli/sddcmanager_restart_services.sh