Tuesday, June 12, 2018

LS NAV - Microsoft.Dynamics.Nav.Types.Exceptions.NavNCLTypeMappingException

This error occurs if you attempt to copy or synchronize the permission tables from one database to another.

You must export and import permissions.

Run these to remove all users and allow you to enter the database.

delete from [dbo].[User]
delete from [dbo].[Access Control]
delete from [dbo].[User Property]
delete from [dbo].[Page Data Personalization]
delete from [dbo].[User Default Style Sheet]
delete from [dbo].[User Metadata]
delete from [dbo].[User Personalization]

1 comment:

  1. Hello,

    I got that error in BC trying to transfer permission from one database to other and I am not able to return to the initial situation.

    I've tried deleting SQL Permission Table.. transfer via DataDirector on LS Retail..but it doesnt work. ¿How could I return a initial permission in that DDBB?

    ReplyDelete