web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / NAV Data Upgrade comma...
Small and medium business | Business Central, N...
Answered

NAV Data Upgrade command taking too much time when upgrading to BC 14

(0) ShareShare
ReportReport
Posted on by Bilal Haider 412

Hello,

I am upgrading NAV 2009-R2 to BC 14. I used the path =>>  2009-R2 -> 2013 -> 2015 -> BC14

I have successfully converted it to BC 14 and successfully synchronized with the merged tables.

Now when I start NAV data upgrade process it took around 40 hours to finish although the process successfully upgraded data but its a long time. I have done some research and found that 98 percent of this time is taken by one upgrade function that is Item table upgrade. 

In DB that I am upgrading there are more than 131000 items and only one company. We know that product groups are obsoleted and they are converted to Item Categories during this process.

The machine on which I am working is 80 GB of RAM but not more than 30% of it is consumed during this process.

Are there any suggestions so that I can reduce the time that is taking on Start-NAVDataUpgrade command. Or any way so SQL can use full machine resources.

Thanks 

I have the same question (0)
  • Lars Lohndorf-Larsen Profile Picture
    Lars Lohndorf-Larsen on at

    Hi Bilal,

    Good job for isolating the slow function to begin with. What function is it, and have you located the slow code in that function? Maybe there is a filter that just needs a better index. 131.000 items is not that many, so I would think that the code can be optimized, probably by matching filter and key better.

  • Verified answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

    Hi,

    If its due to Product Group There can be two issues - 

    1. Data Cleanup- 

    There should not be any blank Item Category.

    There should not be any Record in Product Group Table where Code is empty.

    There should not be any record in Product Group Table where Item Category Code is Empty.

    The Product Group Code Should be unique (There should not be two product Group Code with Same Code).

    ** Reason - Product Group becomes Item Category in future. If there are multiple records with same product group code it will confuse the process to update it. 

    2. Ledger Update.

    There is a function - UpdateItemCategoryCodeOnLinesRecords which updates product group in ledger / transactional table.

    You Should be able to rewrite this function in SQL and comment in Upgrade Codeunit.

  • Bilal Haider Profile Picture
    Bilal Haider 412 on at

    Hi Saurav,

    Verified the data cleanup points as you mentioned.

    Will try to comment UpdateItemCategoryCodeOnLinesRecords procedure and share the results, if it affects.

  • Bilal Haider Profile Picture
    Bilal Haider 412 on at

    Hi Lars,

    The function is

    [UpgradePerCompany] UpdateItem()

    from upgrade codeunit 104000 that is taking more than 95% of the data upgrade time.

  • Bilal Haider Profile Picture
    Bilal Haider 412 on at

    Another update:

    530 items have pictures are as well that are transformed to media from blob during data upgrade process.

  • Lars Lohndorf-Larsen Profile Picture
    Lars Lohndorf-Larsen on at

    Hi,

    I think you have narrowed this down very nicely, to one of these areas:

    UpdateItemPicture;
    UpdateItemCategoryPostingGroups;
    UpdateMyItem;
    UpgradeProductGroup;
    UpdateBlockedFields;

    Either remark them one by one, or design then save codeunit 104000 and change it to a normal codeunit, then run these functions one by one to see which one takes so long. You may have to first transfer all items into  the UPGItem first.

  • Bilal Haider Profile Picture
    Bilal Haider 412 on at

    Thanks Saurav and Lars.

    Yes, now I am narrowing down to each function one by one and see which is taking much time.

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 412 on at

    I was working on other tasks so this task went on backlog. But on weekend I run an iteration of upgrade.

    Good thing is that I have found that it is exactly this function UpdateItemCategoryCodeOnLinesRecords that is taking 95 percent of the time. As Saurav suggested we can rewrite the function in SQL so I wrote and it runs extremely fast.

    Thanks saurav and lars for helping me on this issue.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans