Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

Upgrade for NAV 2013 R2 to NAV 2018 has taking more than 4days because of product groups?

Posted on by Microsoft Employee

Hi All,

Presently i am doing upgrade form NAV 2013 R2 to NAV 2018 Cu2 and database size was 426GB. Data upgrade process has taking longer than 3 days because still product group update process running for all history items.

Is there any simple way to do the product group update. Or Usually it takes this much time.

Any suggestion would be highly appreciated.

Thank you

Ramesh

--

  • Junshah Profile Picture
    Junshah 10 on at
    RE: Upgrade for NAV 2013 R2 to NAV 2018 has taking more than 4days because of product groups?

    Hello Ramesh,

    Please share step by step guide of Microsoft Dynamics Navision 2013 to 2018 upgrade,

    Scenario:

    Old - Server 2008 (SQL 2012, Nav2013)

    New - Server 2016 (SQL 2017, Nav2018)

    I am trying to take the SQL Backup and restore in the new server but failed. Is there any proper step by step guideline, please share.

  • Suggested answer
    AlexDen Profile Picture
    AlexDen 90 on at
    RE: Upgrade for NAV 2013 R2 to NAV 2018 has taking more than 4days because of product groups?

    Hi.

    Try to disable all indexes in Item table except primary before starting upgrade.

    When upgrade is finished you will have to enable it again.

  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 17,959 Super User 2024 Season 2 on at
    RE: Upgrade for NAV 2013 R2 to NAV 2018 has taking more than 4days because of product groups?

    It make sense and the reason is data.

    Follow these steps -

    1. Open Item category table and check any record with Code = '' (Delete that).

    2. Run Product Group Table and check for any record with Item Category code = '' (Delete that).

    3. Check Product Group table has unique record w.r.t Code field. If two product group code records have same value for Code then rename and keep it unique.

    What these are required -

    1. During upgrade data from these two tables will get consolidated in one table.

    2. Item Category table data is set to Parent Record and Product Group data is set as child record.

    3. Each Child Record is set to Parent code to show data to user.

    If any data exist with three cases discussed above upgrade logic goes into a endless loop.

    Let me know if any questions.

  • Rashed Profile Picture
    Rashed 3,765 on at
    RE: Upgrade for NAV 2013 R2 to NAV 2018 has taking more than 4days because of product groups?

    No I have to queries to share. You need to build it yourself.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Upgrade for NAV 2013 R2 to NAV 2018 has taking more than 4days because of product groups?

    Hi Ahmed,

    Thank you for reply. Is any sample queries please share us will help.

    Thank You

    Ramesh

  • Rashed Profile Picture
    Rashed 3,765 on at
    RE: Upgrade for NAV 2013 R2 to NAV 2018 has taking more than 4days because of product groups?

    You can write custom SQL query to update the data and comment on the standard nav code.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans