Thursday 8 January 2015

You do not have permissions to modify profile records because the tenant is mounted with the application database as read-only

Error Message:






You do not have permissions to modify profile records because the tenant is mounted with the application database as read-only. Contact your system administrator.

Problem Statement:

System returns above error message when you try to set any Profile ID as Default Role Center in Multi-Tenant environment. The problem happens because the tenant can’t write changes to the application database and the Profile table is in Application database.

Here is the list of tables which are distributed to Application database and Business Data Database.



Solution: If you want to allow the Tenant’s to allow changes in Application database then follow below steps.


Below is the screenshot of tenants list mounted to a servicetier in NAV Administration Tool


“Allow Application Database Writes” should be True to fix the above error.
By default “Allow Application Database Writes” will be False.

If you want to change then go to below path
C:\Program Files\Microsoft Dynamics NAV\80\Service\Instances\TradeOnline

Here you will find Tenants.Config file
Open it in Notepad and change the “Allow Application Database Writes” to True
And Restart the Service.




But make sure that if you change Default Role Center in one tenant then it will be applied to all tenants as Profile table is in Application Database.

1 comment:

  1. Mohana, well known problem in practice. thanks for the solution :)

    ReplyDelete