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

Version 1



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




    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



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




    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.




    • 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+