SDDC Manager UI failed to load Workload Domains with an error: "Failed to load all domains information"

Products

• VMware SDDC Manager

Issue/Introduction

Symptoms

• Below red banner is observed on "Workload Domains" page of SDDC manager:
  Failed to load all domains information. Something went wrong. Please retry or contact the service provider and provide the reference token..
  Failed to load cluster details.
  
  
• domainmanger.log:
  YYYY-MM-DDThh:mm:ss.822+0000 ERROR [vcf_dm,69###################,####] [c.v.e.s.e.h.VcfFallbackErrorController,http-nio-127.0.0.1-7200-exec-10]  [JJ1Q52] - Error attributes: {timestamp=Wed Dec
 10 16:52:14 UTC 2025, status=500, error=Internal Server Error, exception=java.lang.NullPointerException, trace=java.lang.NullPointerException: Cannot invoke "com.vmware.cloud.foundation.rest.commonsvcs.model.Cluster$PrimaryDatastoreTypeEnum.name()" because the return value of "com.vmware.cloud.foundation.rest.commonsvcs.model.Cluster.getPrimaryDatastoreType()" is null
        at com.vmware.vcf.clustermanager.services.impl.ClusterManagerIsServiceImpl.toCluster(ClusterManagerIsServiceImpl.java:909)


• Notice primary_datastore_name and primary_datastore_type fields are empty for one cluster, checking with below command in SDDC manager command line:
  psql -h localhost -U postgres -d platform -x -c "select * from cluster";

Environment

VCF 9.0

Cause

After upgrading to VMware Cloud Foundation (VCF) 9.0 from an existing (brownfield) environment, there are missing values of a primary datastore name and primary datastore type for one cluster in the SDDC Manager database which causes NullPointerException when loading the logical inventory in domainmanager.

Resolution

The missing values need to be manually inserted into SDDC Manager database.

Please open a ticket to engage Broadcom Support to assist with database modification.

Additional Information