NAV 2015 Synchronize Schema Changes

Roelof

I'm currently in an upgrade to NAV2015 (build 41779) and I'm running the 'Sync. Schema for All Tables'. It ran for a while and currently the progression bar is at 100% for some hours now but the 'State' is still saying 'OperationalSyncInProgress'. The database to convert is a large database but I'm getting a bit concerned how long this process should take. I would assume that the 'State' field would mention when the whole syncing process would be completed, wouldn't it?

mohana_cse06

state field will be Operational once the process is finished.

Roelof

But how long can this take and is there a way to monitor the process?

aman_mbs

Hi Roelof did you got some success on this problem even I am facing the same.

Regards,
Aman

Roelof

Hi Aman, yes I did. Out of experience I noticed that you actually synchronize with force all tables as soon you're in NAV2015. That shouldn't take that long since no changes have been made (objects are the same). The status should say: Operational. Then, when you import all customizations, you synchronize with CheckOnly. It will tell you if there are any error. Run the synchronization only from the prompt in the admin shell. In that case you can control the process much better. When all errors are fixed or no error are found you run the synchronization with Force. At some point it looks like the process has been completed and you come back to the prompt. However, the status still might say: 'OperationalSyncInProgress'. Let the process continue in the background and check in once a while until the status is saying: Operational.

kvb

I had same issue several times, but only now find the answer.
System freezes at the 'OperationalSyncInProgress' status if you did not compile system tables before (range 2000000004 to 2000000130). No matter what you use Power Shell or Dev Environment.
Even more, if you compile system objects after you`ve got 'OperationalSyncInProgress' it will not help, so be accurate.
I spent hours to find this out.

abrar273

I am having this issue, when i run Syc Schmea with validation in NAV 2018 Dev Environment it stuck on this screen. no error shown in event viewer as well. and then I compile all table With Sync Schema Now with validation it goes fine for all tables no error found. then I tried Syc Schmea with validation in NAV 2018 Dev Environment but screen stuck with pendin status and no error shown.
Any suggestion please.
I want to run data upgrade after this step any suggestion.
Thanks in advance.

Roelof

Abrar273, I would recommend to cancel the synching and restart the SQL server. Then start the synchronization process using the Dynamics NAV Adminstration Shell (run as administrator), as: sync-navtenant <navservicename>
Also: make sure that the SQL Server has enough memory to run.

Thanigaivelan

@kvb Thanks, It worked and the reason is exactly the same as you mentioned.