NSX edge clusters are missing/not listed on SDDC Manager's UI for the management and the workload domains after upgrading SDDC from 4.5.1 to 5.2.1

Products

• VMware SDDC Manager

Issue/Introduction

•  NSX edge clusters are missing on SDDC Manager's UI for the management and the workload domains but are present/listed in NSX-T Manager's UI

Environment

• VMware SDDC Manager 5.x

Cause

• Listed all the NSX Edge clusters in SDDC DB, two of the edge clusters do not have the source ID in the list and when cross-checked those edge clusters in NSX-T Manager's UI, they are not present, they have been deleted from the NSX-T Manager directly before the upgrade
  
  

  To list all the NSX Edge clusters from SDDC DB 
  
  SSH into the SDDC Manager
  
  root@sddc [  ]# psql -h localhost -U postgres -d platform -c "select id,name,source_id from nsxt_edge_cluster;"
  
  The output looks similar to:
  
                 id                  |       name        |              source_id
  --------------------------------------+-------------------+--------------------------------------
   ########-9228-####-###-1f71###28c1 | ####-##-##-##-### | ########-06d3-####-####-########
   ########-e9b1-####-###-d9f4###1fd5 | ####-##-##-04-lb  | ########-5237-####-####-########
   ########-e944-####-####-8dea###ab1d7 | ####-##-##-01-lb  | 
   ########-5746-####-####-982f6###69e6 | ####-##-###c-ns-### | 
   ########-898d-####-####-b227####2fc06 | ####-##-##-##-lb  | #######-####-####-####-#######
   

• The stale entries present in SDDC Manager's DB is causing the issue 

Resolution

• The resolution requires removing stale entries present in SDDC Manager's DB.
• Please contact Broadcom support  for assistance.