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

Version 1

    Verified Product Versions

    LANDESK Management Suite 2016.x

    Issue

     

    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

     

    Resolution

     

    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.