vSphere Horizon – Removing “Missing” Desktops from VMware View
i recieved this error on horizon view farm, the reboot of the vCenter, Connection adn Composer server doesnt help.
My solution is:
- delete VDI-214-001 from ADAM db
- delete VDI-214-001 from viewcomposer db
- delete VDI-214-001 from vCenter
- delete VDI-214-001 from ActiveDirectory
1. delete VDI-214-001 from ADAM db
Log into Horizon Connection server and connect to the ADAM database via ADSI Edit.
In ADSI Edit console click to „Connect to…“ and enter following info exactly as shown in the screenshot.
- VIEW ADAM DB
and click to OK and expand VIEW ADAM DB.
right-click the View ADAM Database and select New > Query.
in query string field enter name of vm
IN MY CASE:
Now you should see your Query listed under the View ADAM Database, to validate VDI-214-001 check:
delete object VDI-214-001.
2. delete VDI-214-001 from viewcomposer db
Connect to View Composer database useing SQL Management Studio and delete remove all entries of VDI-214-00 in database. I found SQL script, which will speed up the process !
- use: viewcomposer
sql delete script:
/*!!!DELETES VM FROM SQL DB CAUTION!!!*/ /*Enter Name Below for VM on line with set [@name='vm_name_here'] */ DECLARE @name nvarchar(255) set @name='NCC1701' /*Enter Name of VMware View Composer Database for line below [use database_name]*/ use Composer DELETE FROM [dbo].SVI_TASK_STATE WHERE SIM_CLONE_ID = (SELECT ID FROM [dbo].SVI_SIM_CLONE WHERE VM_NAME like @name) DELETE FROM [dbo].SVI_SC_PDISK_INFO WHERE PARENT_ID = (SELECT ID FROM [dbo].SVI_SIM_CLONE WHERE VM_NAME like @name) DELETE FROM [dbo].SVI_SC_BASE_DISK_KEYS WHERE PARENT_ID = (SELECT ID FROM [dbo].SVI_SIM_CLONE WHERE VM_NAME like @name) DELETE FROM [dbo].SVI_SIM_CLONE WHERE VM_NAME = @name DELETE FROM [dbo].SVI_COMPUTER_NAME WHERE NAME = @name DELETE FROM [dbo].SVI_VM_NAME WHERE NAME = @name
3.delete VM VDI-214-001 from vCenter
4.delete VDI-214-001 from Active Directory
Since provisioning was enabled on the pool it actually rebuilt the VM right away, which was nice !