SDDC Manager Pre-Check Fails for “Cluster Inventory Sync Check” with the error – “Cluster Mor id cannot be null or empty”

Products

• VMware Cloud Foundation

Issue/Introduction

Symptoms:
While running the SDDC Manager pre-checks, the pre-checks fail for “Cluster Inventory Sync Check” with the error – “Cluster Mor id cannot be null or empty”.

Cause

If vSphere cluster create workflow fails because of any reason, the VCF inventory will not have source_id populated for the cluster.

Resolution

1. Take snapshot of SDDC Manager VM
2. SSH to SDDC Manager using vcf and su to root
3. Connect to platform database
   • psql -h localhost -U postgres -d platform
4. Fetch all the details for the cluster and note the cluster ID.
   • select * from cluster;
5. Verify whether the “source_id” is present for the cluster or not.
   • 
6. If the “source_id” is not present, login to vCenter GUI, navigate to the cluster (red box towards the left) and note the “source_id”(ClusterComputeResource) from the URL (red box towards the right).
   • 
7. Update the “source_id” using this command:
   • update cluster set source_id=’<source id gathered from step 6>’ where id=’cluster ID’;
8. Run the pre-checks again, everything should be in order now.

Additional Information

Impact/Risks:
SDDC Manager can't load any of the clusters, due to which we can't continue with any of the upgrades.