Error: Cannot insert the value NULL into column 'ui_index'

Version 1

    Verified Product Versions

    Endpoint Manager 2016.x



    When upgrading your Workspaces framework after applying SU3 for 2016.3, the upgrade fails with the following error:


    Pasted image at 2017_05_04 09_47 AM.png




    The SQL script mentioned below is not an official script from Ivanti support. This script is not supported, and has not gone through Ivanti's testing process. Run at your own risk!

    ALWAYS back up your database before running an unknown SQL statement on your database.

    The SQL Script attached to this document can be run against the Workspaces database to resolve this.


    What Does The Script Do?


    The script inserts a missing value that the upgrade is looking for, and failing to find. The script doesn't delete any existing data.