Customer receives error message when trying to save final state permission setting.  Error: Violation of PRIMARY KEY constraint 'PK_def_translations'.  Cannot insert duplicate key..."

Version 1

    Details

    When checking "Allow Editing" to grant Admin role "Final State" override rights, customer receives following error message.

    Error: Violation of PRIMARY KEY constraint 'PK_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."






    Resolution

    This error is a known issue in the 2014.2.1 code base and addressed in RM 219903.

     

    Here are the steps for a workaround until able to upgrade:

    1. Navigate  to Configure Application>Organizational Profile> Languages

    2.  Uncheck all languages except English(United Status)


      This will allow you to make the changes on Object Permissions for the Admin Role.  Once these changes are complete, you can re-check all the languages again.

    3.  Navigate  to Configure Application>User Permissions>Roles and Permissions and make your changes to the Admin Role. Save.
    4.  Verify that the Admin role now has the desired permissions.
    5.  Navigate  to Configure Application>Organizational Profile> Languages and re-check the languages.