Fix broken Hub Sites in SharePoint Online
If you have been an early adopter of the Hub Site functionality (https://docs.microsoft.com/en-us/sharepoint/planning-hub-sites) in SharePoint Online, you might also get stuck in some trouble with Hub Sites not showing up in SharePoint Admin Center or being unable to register or unregister these sites. Fortunately it is quite easy to clean up broken hub sites and get back on track.
Example of error message from PowerShell registering a hub site (Register-SPOHubSite):
The list item could not be added or updated because duplicate values were found in the following field(s) om the list: [HubSite, Site]
So it tells us something like there is already an registered hub site for that URL but thing are messed up and now it doesn't work. Usually you run into these issues right before launching a new intranet or other portals for you company, so this can be a bit stressful.
Solution: Clean up old hub sites
Using the PnP PowerShell module as an SharePoint administrator run this:
Connect-PnPOnline -Url https://TENANTNAME-my.sharepoint.com Get-PnPListItem -List HubSites
You will get a result like this:
Id Title GUID -- ----- ---- 6 Intranet e1a88177-fe1a-4c32-9109-d4ada14469b8 7 Finance a862d25f-56db-48e3-9641-7313fac36855 8 Operations b584407b-aebd-499f-9ee7-f3f864574ca6
Remove the Hub Site(s) that doesn't work like this (change "Identity" with the correct value):
Remove-PnPListItem -List HubSites -Identity 8 -Recycle
You might get an access denied, this needs to be fixed by assigning yourself as a site collection administrator using the SharePoint Online PowerShell module:
Connect-SPOService -Url https://TENANTNAME-admin.sharepoint.com Set-SPOUser -Site https://TENANTNAME-my.sharepoint.com -IsSiteCollectionAdmin:$true -LoginName USERNAME@TENANTNAME.onmicrosoft.com
By cleaning up the hidden list "HubSites" with PowerShell you should be able to get your Hub Sites back on track. Note that is is recommended from Microsoft to wait 24 hours before re-registering a broken Hub Site to allow the system to clean up and be able to get it right the next time.