Database Upgrade Failure - Cannot Find The Object 'APEventDeleteHistorical'

Version 2

    Symptoms

     

    When upgrading from Shavlik Protect 9.1 to 9.2, the database upgrade fails with a SQL install script error "A data conversion error has been detected during the database upgrade process. Cannot find the object 'APEventsDeleteHistorical' because it does not exist or you do not have permission."

    APEVENTS.JPG

     

    Cause

     

    The upgrade from 9.1 to 9.2 requires database user "dbo" to own the Reporting, Services, and Virtual schemas.

     

    Resolution

     

    1. Open SQL Server Management Studio**
    2. Navigate to Databases > Protect*** > Security > Users
    3. Once you have expanded the Users container right click on "dbo" and choose properties.
    4. Under "Select a Page" choose "Owned Schemas", add the Owned Schema's listed below and press OK

     

    • Reporting
    • Services
    • Virtual

     

    SQLMgmnt.JPG

     

      SQL Management Studio is a tool used to manage permissions and setting for SQL database. For more information and download links please see the following article:

    Download Links for Microsoft SQL Management Studio Express Editions

      "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.

     

    Affected Product(s)


    Shavlik Protect 9.1.x

    Shavlik Protect 9.2.x