Performing an operation in Virtual Machine Manager fails with error 801

Article ID: 2756886 - View products that this article applies to.
Expand all | Collapse all

Symptoms

When performing any operation on a virtual machine (VM) in System Center 2012 Virtual Machine Manager (VMM 2012), the job fails with the following error:

Error (801)
VMM cannot find VirtualHardDisk object <GUIDValue>

Cause

This can occur if VMM has orphaned records in the database showing snapshots that no longer exist.

Resolution

To resolve this issue, remove the orphaned objects from the database by following the steps below.

1. Stop the System Center Virtual Machine Manager service on the VMM 2012 server.

2. Back up the Virtual Manager database.

3. Open SQL Management Studio and run the following script on the VMM database:

BEGIN TRANSACTION T1

DECLARE custom_cursor CURSOR FOR
SELECT VHDId, VDriveId from
dbo.tbl_WLC_VDrive WHERE [VHDId] NOT IN
(SELECT VHDId from dbo.tbl_WLC_VHD WHERE VHDID IS NOT NULL)

DECLARE @VHDId uniqueidentifier
DECLARE @VDriveId uniqueidentifier

OPEN custom_cursor
FETCH NEXT FROM custom_cursor INTO @VHDId, @VDriveId

WHILE(@@fetch_status = 0)
BEGIN
if(@VHDId is NOT NULL)
DELETE FROM dbo.tbl_WLC_VDrive
WHERE VDriveId = @VDriveId
FETCH NEXT FROM custom_cursor INTO @VHDId, @VDriveId
END
CLOSE custom_cursor
DEALLOCATE custom_cursor

COMMIT TRANSACTION T1
4. Start the System Center Virtual Machine Manager service again and refresh problem VMs. The VMs should return to a proper reporting state.

More information

This resolution can also be used for 801 errors when perfoming a Physical to Virtual conversion (P2V). Information on that solution can be found here:

959596 - Description of the System Center Virtual Machine Manager 2008 update to address physical to virtual (P2V) issues (http://support.microsoft.com/kb/959596)
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2756886 - Last Review: February 20, 2014 - Revision: 5.0
Applies to
  • Microsoft System Center 2012 Virtual Machine Manager
  • Microsoft System Center 2012 R2 Virtual Machine Manager
Keywords: 
KB2756886

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com