Update from SDDC Manager 5.2.1.1. to 5.2.1.2 fails with the GUI with error: "Bundle update failed".

Products

• VMware SDDC Manager

Issue/Introduction

Update from SDDC Manager 5.2.1.1. to 5.2.1.2 fails with the GUI with error: "Bundle update failed."

Environment

VCF on VxRail 5.2.0 and 5.2.1

Cause

The issue occurs due to a null value in the 'type' column of the vCenter table within the SDDC database for one or more vCenter entries.

To confirm this, execute the following command and check if the type field for any vCenter appears as NULL or \N:
psql -h localhost -U postgres -d platform -c "SELECT * FROM vcenter;" > /home/vcf/output.txt
less /home/vcf/output.txt

Example Output:

| **Field**                 | **Value**                    |
| ------------------------- | ---------------------------- |
| **id**                    | ######-####-###-####-####### |
| **creation time**         | 1.74795E+12                  |
| **modification time**     | 1.75055E+12                  |
| **bundle repo datastore** | N                            |
| **datastore name**        | N                            |
| **ssh host key**          | N                            |
| **ssh host key type**     | ssh-rsa                      |
| **status**                | ACTIVE                       |
| **type**                  | \N                           |
| **version**               | 8.0.3.00400-24322831         |
| **vm hostname**           | ###-###-###-##.##.##         |
| **vm management IP**      | ##.###.##.##                 |
| **vm name**               | ###-##-##-vc                 |
| **join sso status**       | JOINED                       |

Resolution

To resolve the issue, please follow the steps below:

• Take a  non-memory snapshot of the SDDC manager
• SSH into the SDDC Manager using the vcf user.
• Elevate the privileges to root: su
• Access the database: psql --host=localhost -U postgres -d platform
• Update the vcenter table with the appropriate type value: update vcenter set type='VI' where id='<ID>';
• Verify the update: select * from vcenter set type='VI' where id='<ID>';
• Exit the database: \q
• Restart LCM: systemctl restart lcm
• Clear any existing upgrade plans from the domains. Reference snippet: 
  
• Restart all SDDC Manager services: /opt/vmware/vcf/operationsmanager/scripts/cli/sddcmanager_restart_services.sh

Additional Information

Reference KB: 384469