Problem saving permissions in Manager

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])

Signifikant Knowledge Base

Problem saving permissions in Manager

Analytics

Problem

Solution

Related articles

Related content