VMWare View (Desktop Composer Fault: Virtual Machine with input specifications already exists)

Summary

This error is caused when View Composer has some kind of hiccup and ‘thinks’ it deployed a desktop and can’t get over the fact that it failed.  There are 3 event entries that will usually show up right next to each other:

• Desktop Composer Error:VMware.Sim.Fault.InvalidParameterFaultParam: cSpec Detail: AlreadyExist; Error Type:com.vmware.SviService.InvalidParameterFau
• Desktop Composer Fault: Virtual Machine with input specifications already exists
• PendingOperation-Path/that/has/been/defined/VMName

Config:

• View 4.0.1
• SQL 2005

Resolution:

I found this SQL script on the vmware communities board after I went through the manual hell of finding each related key.  Essentially, you need to delete all related SQL entries so View Composer can move on to start deploying VM’s again.  This script makes this job a WHOLE lot easier.

   1: DECLARE @vmdelete varchar(20);

   2: set @vmdelete = 'FAILED_VM_NAME';

   3: delete from SVI_VM_NAME where NAME = @vmdelete

   4: delete from SVI_COMPUTER_NAME where NAME = @vmdelete

   5: delete from SVI_TASK_STATE where SIM_CLONE_ID = (SELECT ID FROM SVI_SIM_CLONE WHERE (VM_NAME = @vmdelete))

   6: delete from SVI_SC_BASE_DISK_KEYS where PARENT_ID = (SELECT ID FROM SVI_SIM_CLONE WHERE (VM_NAME = @vmdelete))

   7: delete from SVI_SC_PDISK_INFO where PARENT_ID = (SELECT ID FROM SVI_SIM_CLONE WHERE (VM_NAME = @vmdelete))

   8: delete FROM SVI_SIM_CLONE WHERE (VM_NAME = @vmdelete)