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:
- Close all SCVMM admin console.
- Stop SCVMMService (Virtual Machine Manager) one the SCVMM Server
- Full Backup your SCVMM DB (just in case of 😉 )
- 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.