Unhandled exception has occurred in your application. (76690)

vRanger GUI crashes with following windows popup error message:

“Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.

No such host is known.”

This usually happens when browsing vRanger>Tools>Options>Licensing>Host or creating/editing a backup job.

The reason for this is that there is a disconnected host/Virtual Center in the Inventory of vRanger

Option 1.

This disconnected host needs to be removed manually from vRanger database:

1. Stop the vRanger Pro Services.
2. Use the following commands to list hosts known to vRanger. (When SQL Express is installed on local host)

sqlcmd -S localhost\vRangerPro -d vRangerPro -Q "select left(address, 40), IsDeleted from InventorySourceConnection"

3. Execute this command 1 time for each host that needs to be removed from " My Inventory"

sqlcmd -S localhost\vRangerPro -d vRangerPro -Q "update InventorySourceConnection set IsDeleted='True' where address='Hostname' "

4. Restart vRangerPro service

Option 2.

This disconnected VC or host needs to be removed manually from vRanger database:

1. Stop the vRanger Services
2. Install SQL Server Management Studio Express to edit VC/Host information in the vRanger database. Link here: http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en#filelist
3. Once installed, launch the application (SQL Server Management Studio Express)
4. Enter the Servername (or IP address) and database instance (computername\vrangerpro)
5. Expand Databases and vRangerPro
6. Expand Tables
7. Right-click on dbo.InventorySourceConnection and select Open Table
8. In the Results grid, find entry for the disconnected vCenter or ESX host/s
9. Scroll to the IsDeleted column and change all records to True (click anywhere on the table for value to take effect)
10. Start the vRanger Pro service and launch the GUI.