Upgrade to HEAT 2014.3.1 error: There is already an object named 'PK_ActionToolbarItem' in the database.  Could not create constraint

Version 1

    Details

     

    When running the upgrade of a HEAT database in the System Configuration Wizard (SCW) the following error is displayed:
    There is already an object named 'PK_ActionToolbarItem' in the database.  Could not create constraint

     


    Resolution

    The SQL account/login that is specified in the System Configuration Wizard for accessing the HEAT Application database, does not have high enough permissions in order to make changes to the database schema that the upgrade performs.


    The SQL account/login needs to be able to drop and recreate items in the database schema.