VMware Horizon Community
ring22
Contributor
Contributor

rebuild composer

Hello !,

In my environment ,I built a system for Horizon7 and used composer server & connection server to post linked-clone VDI.

Recently, I found that my linked-clone cluster had headache  ,couldn't to remove builed-VM from edit VM quantity resized 20 to 10.

and I tried to command viewdbchk had no apparent effect.

Now, Is there any method or possibile to rebuild composer and change sql database but keep service on ,  replace composer in the background?

Tags (1)
Reply
0 Kudos
1 Reply
yukiafronia
Enthusiast
Enthusiast

Hi, @ring22 

Please follow the steps below to see if it works.

Check the KB for manual deletion, not ViewDbchk,
Try to see if you can perform machine deletion from each component.

* Manually delete link clone or steal virtual desktop entries from the View Composer database in VMware View Manager and VMware Horizon View (2015112)
https://kb.vmware.com/s/article/2015112
------------------
1. Delete the virtual machine from the ADAM database on the connection server.
2.Delete all desktop references in the View Composer database.
3.Delete all affected computer objects from Active Directory.
4. Delete desktops from vCenter Server.
------------------

1. Delete the virtual machine from the ADAM database on the connection server. Regarding.
I assume you have already deleted the machine from the Connection Server,
However, we would appreciate it if you could check if there is any machine information left in the ADAM database just to be sure.
------------------
Deleting a virtual machine from the ADAM database on the connection server
Important:
Before you begin these steps, use the View Administrator to disable provisioning on the pool from which you want to remove machines.

Note: Before deleting an entry from the ADAM database, the name of the desktop virtual machine to be deleted,
Composer database for reference when editing the database.
1. Connect to the View ADAM database. For more information on connecting to the ADAM database using ADSI Edit,
Connecting to the View ADAM Database (2012377).

* Connecting to the View ADAM Database (2012377)
https://kb.vmware.com/s/article/2012377

2. Search for the virtual machine to be deleted.

2-1. Right-click [Connections] View ADAM database [localhost:389] and click [New] > [Query].
2-2. Enter a query name such as "VM Search" for example.
Under Root of Search, click Browse and select the configuration unit of Servers. 2-4.
Click OK. 2-5.
Paste the following search string into Query String.
(&(objectClass=pae-VM)(pae-displayname=VirtualMachineName))
where VirtualMachineName is the name of the virtual machine whose GUID is to be searched.
* and ? as wildcards to match multiple desktops.
2-6Click OK to create the query.
2-7Click Query in the left pane. The virtual machines that match the search will appear in the right pane.
------------------

2. "2. Delete all desktop references in the View Composer database." For more information about
As with Connection Server, please check to see if any machine information remains in Composer,
If so, delete it.

------------------
To remove a reference to a linked clone from the View Composer database, perform the following steps: 1.
1. open SQL Manager > Databases > View Composer Database > Tables.
2. Open the dbo.SVI_VM_NAME table and delete the entire row where the virtual machine is referenced in the NAME column.
3. Open the dbo.SVI_COMPUTER_NAME table and delete the entire row where the virtual machine is referenced in the NAME column.
4. Open the dbo.SVI_SIM_CLONE table and find the reference to the virtual machine in the VM_NAME column and write down the ID.
If you delete this row, dependencies with other tables will be an issue.
5. Open the dbo.SVI_SC_PDISK_INFO table and delete the entire row where the dbo.SVI_SIM_CLONE ID is referenced in the PARENT_ID column.
6. Open the dbo.SVI_SC_BASE_DISK_KEYS table and delete the entire row where dbo.SVI_SIM_CLONE ID is referenced in the PARENT_ID column.
7. If the link clone was in the process of deployment when the problem occurred,
Additional references to the clone may remain in the dbo.SVI_TASK_STATE and dbo.SVI_REQUEST tables.
7-1. Open the dbo.SVI_TASK_STATE table and find the row in the SIM_CLONE_ID column that references the dbo.SVI_SIM_CLONE ID.
Write down the REQUEST_ID for that row.
Open the dbo.SVI_REQUEST table and delete the entire row where dbo.SVI_TASK_STATE REQUEST_ID is referenced.
7-3. Delete the entire row from the dbo.SVI_TASK_STATE table.
8. Delete the entire row in the dbo.SVI_SIM_CLONE table where the virtual machine is referenced.
------------------

3. Delete all affected computer objects from Active Directory.
4. Delete desktops from vCenter Server. Regarding
I assume that the information on the machine is still there, so can you please delete it?

------------------
Delete virtual machines from Active Directory
To remove a virtual machine from Active Directory, perform the following steps

Log in to the domain controller as an administrator. 2.
Navigate to Start > Administrative Tools > Active Directory Users and Computers. 3.
Delete the virtual machine from Computers.
Note: The virtual machine may not be in the computer's OU (Organizational Unit).
If so, it may be in a different OU.

Deleting Virtual Machines from vCenter Server
To delete a virtual machine from vCenter Server, perform the following steps

Log in to the vCenter Server using the vSphere Client.
Right-click the virtual machine in the linked clone and click Power > Power Off.
Right-click the virtual machine in the linked clone and click Remove from Disk.
4. Enable pool provisioning.
------------------

 

YouTube

https://www.youtube.com/watch?v=Tm1kUXIKek8 (Japanese)

https://youtu.be/ayG5SBJZRpE (Part1 - English)
https://youtu.be/APd5mTmKOnM (Part2 - English)

Reply
0 Kudos