Database Upgrade Fails With Data Conversion Error - The Index 'ABC' Is Dependent On Column 'XYZ'

Version 1

    Purpose

     

    The purpose of this document is to help troubleshoot database upgrade failures specifying a data conversion error related to indexes.

     

    Symptoms

     

    When attempting to upgrade your database (such as upgrading from Shavlik Protect 9.x to Ivanti Patch for Windows Servers 9.3), the installation fails.

    You see a message indicating "A data conversion error has been detected during the database upgrade process" and text referring to an index near the bottom:

    The index 'abc' is dependent on column 'xyz'.

    ALTER TABLE DROP COLUMN xyz failed because one or more objects access this

    column.

     

    In this example screenshot, the index is called 'idx_PatchDeployments' and the column is called 'deployedByAgent'.

     

    Cause

     

    This is caused by a custom index ('idx_PatchDeployments' in the picture above) being present in the database.  Custom indexes are not supported for upgrade.

     

    Resolution

     

    • Remove the custom index(es)
    • Perform the database upgrade
    • Add the custom index back in

     

    This should allow you to upgrade successfully.  If you are still experiencing issues upgrading after attempting this fix, please open a support case.

     

    Additional Information

     

    Preparing for Upgrade of Protect and Resolving Common Upgrade Issues

    Database Upgrade Failure - Cannot Find The Object 'APEventDeleteHistorical'

     

    Affected Product(s)

     

    Shavlik Protect 9.x

    Ivanti Patch for Windows Servers 9.3+