Upgrade Failure: Cannot Find The Object 'DeleteHypervisor', Because It Does Not Exist Or You Do Not Have Permission Error

Version 6

    Purpose

     

    The purpose of this article is to go over how to troubleshoot the error you encounter when updating the SQL database from Protect 9.1 to Protect 9.2:  "Cannot find the object 'DeleteHypervisor', because it does not exist or you do not have permission"

     

    Symptoms

     

    After successfully connecting to the SQL database in the Database Setup Tool, the install will fail with the error: Cannot find the object 'DeleteHypervisor', because it does not exist or you do not have permission

     

    Cause

     

    Shavlik changed who owns the schema in the SQL database for Protect in Protect 9.2. This owned schema now belongs to the DBO.

     

    Resolution

     

    1) Open SQL Server Management Studio. If you do not have SQL Server Management Studio, please see the following article: Download Links for Microsoft SQL Management Studio Express Editions

     

    2) Navigate to your SQL database for Protect. Expand Databases. Expand Protect. Expand Security. Expand Users. Right click DBO and Select Properties.

    "Protect" is the default database name.  If you have renamed your database to something other than "Protect" please choose the database your Shavlik install is connected to.

    dbo1.png

     

    3) Click on Owned Schema. Make sure Reporting, Services and Virtual boxes are checked. Click OK.

    dbo2.png

     

    4) Perform the Shavlik Protect 9.2 Upgrade.

     

    Additional Information

     

    The same resolution can also be used when encountering the error: "Cannot find the object 'APEventDeleHistorical', because it does not exist or you do not have permission."

    For more on that error, consult the following article: Database Upgrade Failure - Cannot Find The Object 'APEventDeleteHistorical'

     

    Affected Product(s)


    Shavlik Protect 9.2