Error: "Could not get VCF BOM details" when upgrading Aria Lifecycle Manager (LCM)

Products

• VMware Aria Suite

Issue/Introduction

• The Aria Lifecycle Manager (LCM) upgrade failed, although the system remained operational. The error message indicated an issue with checking VCF-supported versions during the upgrade, specifically "Could not get VCF BOM details."
• When trying to upgrade Aria Lifecycle Manager through ISO, you might also see 'No upgrade available' on the UI 

Environment

• VMware Aria Suite Lifecycle 8.x
• VMware SDDC 4.x
• VMware SDDC 5.x

Cause

• The error message, "Could not get VCF BOM details" suggests a problem with the SDDC Manager’s versioning and database state.
• The system's inability to retrieve VCF BOM details points to a possible issue with the versioning in the SDDC database.

Resolution

• Take a snapshot of SDDC manager.
• SSH to the SDDC VM and run the below command to update the SDDC version on the database: 

psql -h localhost -U postgres -d platform

UPDATE sddc_manager_controller set version ='4.5.1.0-1234';

• Retry the LCM upgrade now. 
• Once LCM is upgraded, update the SDDC version back to the original version: 

psql -h localhost -U postgres -d platform

UPDATE sddc_manager_controller set version ='5.2.1.1.<buildnumber>';