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

(0) Share

Report

Posted on by Community Member

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

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Rashed 3,765 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ahmed,

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

Thank You

Ramesh

Was this reply helpful? Yes No
Rashed 3,765 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

AlexDen 90 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Junshah 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No