Error 801: SCVMM Cannot find ISO object

Hi,

This error can occur if you mount an ISO in a VM from the SCVMM 2012 SP1 Library, delete the ISO file from the Library (How coult it be possible? Admins can !) then try to remove the ISO from the VM.

At this step you cannot clone the VM, create  a template from it or delete it. You could have  the error 801 if you try to remove the host from the cluster and if this host is hosting the VM.

There is only one solution to fix this : delete the entrie for this ISO in the SQL DB. Wow. Not easy, tricky and risky business. So the best way to do this is to use this SQL Script:

  1. Close all SCVMM admin console.
  2. Stop SCVMMService (Virtual Machine Manager) one the SCVMM Server
  3. Full Backup your SCVMM DB (just in case of 😉 )
  4. Run this SQL script on the SCVMM dataBase (SCVMMDB by default).
BEGIN TRANSACTION T1

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

DECLARE @ISOId uniqueidentifier 
DECLARE @VDriveId uniqueidentifier

OPEN custom_cursor 
FETCH NEXT FROM custom_cursor INTO @ISOId, @VDriveId
WHILE(@@fetch_status = 0) 

BEGIN 
if(@ISOId is NOT NULL) 
DELETE FROM dbo.tbl_WLC_VDrive 
    WHERE VDriveId = @VDriveId 
    FETCH NEXT FROM custom_cursor INTO @ISOId, @VDriveId 
  END 

CLOSE custom_cursor 
DEALLOCATE custom_cursor
COMMIT TRANSACTION T1

5. Restart SCVMM Service. The stale ISO reference should have been cleaned up.

source :
http://social.technet.microsoft.com/Forums/en-US/virtualmachinemanager/thread/933e0f09-1cce-4e32-8d6a-49fb87e7735e/

Leave a Reply

Your email address will not be published. Required fields are marked *

*