Dynamics Community Forum Thread Details

NAV 2017 CU 2.1. (Juanary 2017) installation issue

Hello folks,

I'm try the update CU 2.1. in NAV without any customization.

I have update the platform (uninstall and install again)

I have imported the .fob file and validation is ok

When the system try sync I receive the error "Change where found that may delete data from the relevant field or table."

So I open NAV Admin Shell and try with Sync-NAVTenant

CheckOnly mode no error displayed (the command don't tell me anythinc)

PS C:\Temp> Sync-NAVTenant 'MicrosoftDynamicsNavServer$DynamicsNAV100' -Mode CheckOnly

PS C:\Temp>

Sync mode the system tell me:

PS C:\Temp> Sync-NAVTenant 'MicrosoftDynamicsNavServer$DynamicsNAV100' -Mode Sync

MicrosoftDynamicsNavServer$DynamicsNAV100
Confirm synchronization of default tenant in Sync mode
[Y] Yes [N] No [S] Suspend [?] Help (default is "Y"): Y

Sync-NAVTenant : The following SQL error was unexpected:
Column names in each table must be unique. Column name 'Has Children' in table 'dbo.ZZSoft$Item Category' is specified
more than once.
At line:1 char:1
+ Sync-NAVTenant 'MicrosoftDynamicsNavServer$DynamicsNAV100' -Mode Sync
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (0:Int32) [Sync-NAVTenant], NavCommandException
+ FullyQualifiedErrorId : MicrosoftDynamicsNavServer$DynamicsNAV100,Microsoft.Dynamics.Nav.Management.Cmdlets.Sync
NavTenant

I use admin shell in Administrator mode.

Thanks for any help

Quick Links