none
Error 801: VMM Cannot find ISO object

    Question

  • is there a way to handle this directly on VMM SQL DB?

    I still can't find a way to deal with it!
    I'm quite sure the file exists and is OK. On this particular VM it won't let me define virtual DVD to "no media"

    thank you in advance

    Tuesday, September 21, 2010 11:42 AM

Answers

  • Alright, here is what you should do:

    1. Close VMM admin console.

    2. Stop VMMService 

    3. Take full Backup your VMM database ( this step is important to ensure data can be reinstated if anything goes wrong)

    4. Run the following SQL script against VMM db.

    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 VMM Service. The stale ISO reference should have been cleaned up.

     


    posting is provided "AS IS" with no warranties, and confers no rights. User assumes all
    • Marked as answer by Lmmlopes Monday, September 27, 2010 3:15 PM
    Wednesday, September 22, 2010 5:31 PM

All replies

  • The issue here is probably the ISO is not present in DB. Is this VMGuest.ISO? Is the VM residing on host or in library?

    Please provide the above information, I can share SQL script with you that will clean up the stale entry from db.

     


    posting is provided "AS IS" with no warranties, and confers no rights. User assumes all
    Tuesday, September 21, 2010 2:21 PM
  • it's VMGuest.ISO.

    The Vm it's on a Host. I've allready copied the iso file to the library and tried to remove the ISO from the VM. I've even verify that the file exists in this places:

    VMM library
    system32 folder on the VMM server
    system32 folder on the Host
    system32 folder on the VM

    by the way.... I can install Virtual Guest Services on other VM's

    thank you

     

    Tuesday, September 21, 2010 2:26 PM
  • Alright, here is what you should do:

    1. Close VMM admin console.

    2. Stop VMMService 

    3. Take full Backup your VMM database ( this step is important to ensure data can be reinstated if anything goes wrong)

    4. Run the following SQL script against VMM db.

    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 VMM Service. The stale ISO reference should have been cleaned up.

     


    posting is provided "AS IS" with no warranties, and confers no rights. User assumes all
    • Marked as answer by Lmmlopes Monday, September 27, 2010 3:15 PM
    Wednesday, September 22, 2010 5:31 PM
  • Awesome! It solved the problem. Thank you!
    Monday, October 27, 2014 9:20 AM
  • Awesome.

    Thanks a lot

    Friday, September 16, 2016 8:07 PM