Background:
Installed vRA 7.3 in HA using 2 appliances and 2 x each IaaS server type (web, dem-o, dem-w, ims, proxy agent), which were all configured using the wizard. On the "Agents" page during the vRA 7 Configuration Wizard run, there were 2 vCenter Endpoints added - for a total of FOUR proxy agents. ONE of the agents for a second vCenter had a typo in the Endpoint Name field. This has lead to the database having a reference in dbo.Agents for the Endpoint name being the typo/misspelled Agent Endpoint name. Subsequent attempts to uninstall the second vCenter agent for the two Agent Proxy Servers had been totally unsuccessful; the database entry for the Endpoint name is not corrected with an uninstall / reinstall of the Proxy Agents for the affected vCenter
Solution (likely not supported by VMware - so open a support ticket and have GSS walk you through this):
- Uninstall the Proxy Agents for the specific vCenter Endpoint that has an issue
- SQL Management Studio, open the VRA database on your SQL server, and edit the first 200 rows of the dbo.Agents table
- Find the row that has your mispelled Proxy Agent Endpoint listed (be VERY meticulous in reviewing that row for the Endpoint you are looking for)
- Delete the row that contains the misspelled Endpoint Name
- Close the end table
- Reinstall your Proxy Agents being very careful not to make any typos
- Wait ~10 mintues
- Check the ado.Agents table to see that your agents now appear in the table correctly
- Logon to your vRA tenant, probably the Default Tenant
- Add the Endpoint that was giving you the error previously