Dynamics NAV 2017 Data upgrade-Item category


During NAV 2017 data upgrade, UpdateItem function in upgrade codeunit calls 'UpdateItemCategoryCodeOnLinesRecords'. This function has 22 'ModifyAll' statements which modify almost all document tables to update item category code. 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 one of the companies. Now I am running 'UpdateItem' using Invoke-Codeunit just for this single company. Please let me know if anyone has any suggestion to speed up this process.

Thanks & Regards,