Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 300 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Dynamics NAV 2017 Data upgrade-UpdateItem
navdeveloper
Member Posts: 23
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
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
0
Answers
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