NAV Team: Importing objects in a multi tenancy environment

[Blog bot]

The following posting is based on a support request where a partner wanted specific instructions what the process should be when trying to import a FOB file in a true multi tenant environment. If you simply import the FOB file, the
following message box will first pop up to you:



This box is new in Dynamics NAV 2015 and is not part of the scope of this blog posting. It is the other message box that needs more explanation:



The first suggestion is to verify if the server is indeed running (of course it is) and the suggestion from support would be to always verify if the server is accessible via the mentioned port. If these are all true, then the second suggestion is to ensure all tenants are dismounted except one. This is because there should only be one tenant mounted that does have the option “Allow application database write to” enabled.

The following configuration will generate the warning “Unable to process table changes because the request cannot be processed by the specified Dynamics NAV Server instance”:



If you dismount all the tenants except the one that does have the option “Allow application database writes” enabled, the warning will not pop up and you will be able to continue the object import. The following configuration will therefore not generate the warning “Unable to process table changes because the request cannot be processed by the specified Dynamics NAV Server instance”:



To dismount a tenant, you can utilize the Microsoft Dynamics NAV 2015 Administration Shell which may need to be start up with Run as Administrator:

Dismount-NavTenant –ServerInstance DynamicsNAV80SSL –tenant marketing –force
Dismount-NavTenant –ServerInstance DynamicsNAV80SSL –tenant production –force
Dismount-NavTenant –ServerInstance DynamicsNAV80SSL –tenant sales –force
Dismount-NavTenant –ServerInstance DynamicsNAV80SSL –tenant staff –force

After you have done the necessary work to get the application upgraded with the latest rollup or whatever fob file you are trying to import, you need do mount the tenants again:

Mount-NavTenant –ServerInstance DynamicsNAV80SSL –DatabaseInstance NAVDEMO –DatabaseName marketing –DatabaseServer SQL-02 –DefaultCompany ‘CONTOSO Marketing Ltd.’ –id marketing
Mount-NavTenant –ServerInstance DynamicsNAV80SSL –DatabaseInstance NAVDEMO –DatabaseName production –DatabaseServer SQL-02 –DefaultCompany ‘CONTOSO Production Ltd.’ –id production
Mount-NavTenant –ServerInstance DynamicsNAV80SSL –DatabaseInstance NAVDEMO –DatabaseName sales –DatabaseServer SQL-02 –DefaultCompany ‘CONTOSO Sales Ltd.’ –id sales
Mount-NavTenant –ServerInstance DynamicsNAV80SSL –DatabaseInstance NAVDEMO –DatabaseName staff –DatabaseServer SQL-02 –DefaultCompany ‘CONTOSO Staff Ltd.’ –id staff

Last but not least you need to synchronize the tenant with the application
database:

Sync-NavTenant –ServerInstance DynamicsNAV80SSL –tenant marketing
Sync-NavTenant –ServerInstance DynamicsNAV80SSL –tenant production
Sync-NavTenant –ServerInstance DynamicsNAV80SSL –tenant staff
Sync-NavTenant –ServerInstance DynamicsNAV80SSL –tenant sales

Hope this makes the process a bit more clear.

Regards,

Marco Mels
CSS EMEA

This posting is provided "AS IS" with no warranties, and confers no rights

[img]//feeds.feedburner.com/~r/MicrosoftDynamicsNavTeamBlog/~4/9FvsfbGoDPA[/img]

Источник: http://feedproxy.google.com/~r/Micro...vironment.aspx