vSphere Horizon – Removing “Missing” Desktops from VMware View

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:

1. delete VDI-214-001 from ADAM db
2. delete VDI-214-001 from viewcomposer db
3. delete VDI-214-001 from vCenter
4. 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
• dc=vdi,dc=vmware,dc=int
• localhost:389

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

General string:

•  (&(objectClass=pae-VM)(pae-displayname=VirtualMachineName))

IN MY CASE:

• (&(objectClass=pae-VM)(pae-displayname=VDI-214-001))

Now you should see your Query listed under the View ADAM Database, to validate VDI-214-001 check:

• ipHostNumber
• description

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 !

• @name=VDI-214-00
• 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 !