Hi ,
My friend faced same issue.
he forget to add OS profile, to resolve that just create New VM template with existing sysprep vhd and Add both Hardware profileand OS Profile .
then you can pass both VM Name and Computer name from App Controller.
if you are using service template and doing VM provisiong from App Controller then you can pass only computer name .
and
if you are using service template and doing VM provisiong from SCVMM then you can pass both VM Name and computer name .
Snap of VM template.
* will result in a randomly-generated hostname and
# wildcards are supported for incrementing numerical values.
you can pass winvm-## in compuername if required computername is winvm-01,02 and so-on.
if you want to remove VM name from SCVMM DB, then use scvmm Powershell commands
$VM = Get-VM -Name "VM Name"
Remove-VM -VM $VM -Force
or
from SQL DB Table, you can see The VM Name.
Open SQL Server Management and drill down to the VirtualManagerDB tables node
Once there scroll down and find the tbl_WLC_VObject table, right click on it and choose
Open Table:
in Name field , you can see the VM Name
link:->
http://blogs.technet.com/b/scvmm/archive/2009/04/30/fixing-an-incomplete-vm-that-s-stuck-in-the-creating-state.aspx