"Unable to update a vCO endpoint" error while deleting a vCenter Endpoint from the vRO Server Configuration page

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:

• Unable to delete a created vCenter endpoint from the vRO Server Configuration page.
• You see the error message similar to:
  
  Error Unable to delete a vCO endpoint of type 'VC'. Reason: 'java.net.MalformedURLException: no protocol: (Unusable)

 

Environment

VMware vRealize Automation 6.x
VMware vRealize Automation 6.2.x
VMware vRealize Automation 7.1.x
VMware vRealize Automation 7.2.x
VMware vRealize Automation 7.0.x
VMware vRealize Automation Desktop 6.2
VMware vRealize Automation 7.x
VMware vRealize Automation 6.2
VMware vRealize Automation 7.3.x
VMware vRealize Automation 7.4.x
VMware vRealize Automation Desktop 6.2.x

Resolution

This issue is resolved in VMware vRealize Automation 7.4, available at VMware Downloads.

 

To work around the issue:

1. Log in to the vRA virtual appliance.
2. Connect to the postgres database by running this command:
   
   /opt/vmware/vpostgres/current/bin/psql vcac -U postgres
    
3. For better display run the command:
   
   \x
    
4. Display the endpoints by running this command:
   
   select * from asd_endpoint;
    
5. Check which are the unusable endpoints by running this command:
   
   select * from asd_endpoint where rootobjecturi like '(Unusable)%';
    
6. Delete the unusable endpoints by running this command:
   
   delete from asd_endpoint where rootobjecturi like '(Unusable)%';
    
7. Quit the postgres database by running this command:
   
   \q
   
    

Additional Information

To be alerted when this document is updated, click the Subscribe to Article link in the Actions box.