Dynamics NAV 2017 Data upgrade-UpdateItem

navdeveloper
navdeveloper Member Posts: 23
in NAV Three Tier
Hi,

I am running the final step of my data upgrade in NAV 2017. UpdateItem of a company has been running for last 72 hours. Status shows 97.51% completed and this percentage has no change for past 12 hours. I checked event viewer and it still shows update queries. Confused that it is stuck or still working, there is no error though. Would it be better to wait or stop the upgrade?. Only updateItem function is running in the biggest company of the database having 11 companies in total, all other functions are completed.

By any chance I can see how many items are remaining or the upgrade process is running without fail?. Any help would be highly appreciated.

Regards,
MS

Answers

  • navdeveloper
    navdeveloper Member Posts: 23
    Hi,

    During NAV 2017 data upgrade, UpdateItem function in upgrade codeunit calls 'UpdateItemCategoryCodeOnLinesRecords'. This function has 22 'ModifyAll' statements which modify almost all document tables. This was causing my 140 GB database's upgrade a never-ending story. Has anyone faced this issue?

    Finally I had to stop my upgrade without finishing 'UpdateItem' function in the biggest company. Now I am planning to run 'UpdateItem' using Invoke-Codeunit just for this single company after commenting 'ModifyAll' of archive tables. Hope this is going to be fine. Expert opinions and suggestions please :)

    Thanks,
    MS

Categories