Error while saving data: View or function 'Employee' is not updatable because the modification affects multiple base tables (2014.x)

Version 1

    Details

    Updating an Employee record in HEAT Premise Service Management 2014.x produces the error message. 

    Error while saving data: View or function 'Employee' is not updatable because the modification affects multiple base tables.

    This usually occurs after the Employee view is dropped and recreated/restored in SQL from a backup or from a Staging or other tenant running the same configuration.


    Resolution

     

    When the view was recreated/restored, it did not restore the "INSTEAD OF UPDATE"/"INSERT"/"DELETE" triggers with the view.

    From the mirrored database, use "Script As" on each of those three existing triggers, and change the "USE []" to the Production database name. 

    Frontrange Support recommends that you back up the Production database before executing the scripts. 

    The triggers must be scripted from a source database which contains precisely the same table/column configuration as the target, otherwise the triggers may not be accurate.