“VMM cannot find VirtualHardDisk object” when refreshing a virtual machine in Virtual Machine Manager 2012

You might get an error when refreshing a virtual machine on VMM:

Error (801)
VMM cannot find VirtualHardDisk object 3ce58e1c-bfff-421d-8155-b06fb2fb4ea5.

Recommended Action
Ensure the library object is valid, and then try the operation again.

To resolve this, use the following SQL command against your VMM database:

delete from dbo.tbl_WLC_VDrive where VHDId='3ce58e1c-bfff-421d-8155-b06fb2fb4ea5'

The ID is the same in error message and in SQL command.

Of course you should have backup of your VMM database and stop VMM service before the command and start VMM service after the command.

Updated 19.04.2017:

Today I found out for one vm, that this command would work also if above doesnt help

delete from dbo.tbl_WLC_VDrive where Name='virtualservername'

but first try to find, whether you delete the right one or not by changing “delete” to “select *”

select * from dbo.tbl_WLC_VDrive where Name='life'