HEAT 2014.2.1: Unable to add tab to existing role / Cannot modify the roles

Version 1

    Details

    For certain customers, when admin tries to modify the role definition or adding a new tab to the role, user will be prompted with below error and they cannot save the changes

    Error Message:

    Unhandled SaaS exception: DB constraint violation exception: Violation of PRIMARY KEY constraint 'PK__Frs_def_translations'. Cannot insert duplicate key in object 'dbo.Frs_def_translations'. The duplicate key value is (de, Frs_def_role_desktops, Admin, _WorkspaceNames_). The statement has been terminated..


    Error Screenshot:



    Development confirmed that this is a product issue


    Resolution

    To correct the error, you would need to remove all the localized languages supported, except US English in the localization tool in admin  (Configure->Organization Profile->Languages) and then make the necessary modification to the role. And after making necessary role changes, the languages can be enabled back