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.
Shavlik Protect 9.x
Ivanti Patch for Windows Servers 9.3+