ID 804: Template already exists – VMM 2012

Virtual Machine Manager crashed while creating a template. When I retried to create the template, the message ‘template {name} already exists. specify a unique name’ with ID 804 appears.

I found this article, which was very helpful: http://www.altaro.com/hyper-v/error-804-hung-template-creation-in-scvmm-2008-r2/.

These instructions are also working for SCVMM 2012 SP1. Basically, you will adjust one value in your database:

1. Connect to your VMM database with SQL Management Studio
2. Locate the tablet dbo.tbl_WLC_VObject
3. Edit the Top 200 Rows
4. Find the corresponding template name in the column ‘Name’ and adjust the value in ‘ObjectState’ from ‘3’ to ‘0’
5. Restart the Virtual Machine Manager service and you will be able to create the template again