Problem saving permissions in Manager

Owned by Ruud de Bruijckere
Last updated: 19 Feb 2017 by Mattias Löfstrand
1 min read

Problem

User cannot save changes in permissions on any type of information in Manager. Error message indicate problem with constraints in database.

Client's database is created during the period October 2015 to March 2016.

Solution

There is a problem with the database migration scripts for databases created during the above time period. Update has to be manually applied by running the below two scripts on the database using SQL Manager.

ALTER TABLE [dbo].[ResourcePermissionItems] DROP CONSTRAINT [FK_dbo.ResourcePermissionItems_dbo.Catalogues_Catalogue_Id]
ALTER TABLE [dbo].[ResourcePermissionItems] ADD CONSTRAINT [FK_dbo.ResourcePermissionItems_dbo.Presentations_Presentation_Id] FOREIGN KEY([Presentation_Id]) REFERENCES [dbo].[Presentations] ([Id])