Hi all,
I am doing NAV 2009SP1 to NAV 2013 Data Upgrade. But i am stuck at 2nd upgrade tool kit as ""Ledger Entry Dimensions" are preparing to update. I am not getting any error just same screen appearing from 2 days.
My Database Size is 110 GB.
Table-"Ledger Entry Dimension" have 3,76,56,241 records.
Please suggest me the solution.
Thanks & Regards,
Palla Jagadeesh.
*This post is locked for comments
Hi Palla,
Were you able to this issue? I am having the same problem. Thanks
As other members discussed, it most likely connected with a conversion of dimensions information, which should be quite big. If you would fail to make a conversion, you can also opt for transferring open balances at certain date (e.g., beginning of the fiscal year).
It tryes to convert your old 355 table to new dimension set.
If you have 110GB DB, I think you have more than 30mln g/l entries, it means more than 100 mln dimension entries... it will take time.
It will take time, upgrade checks all dimension tables.
After upgrade of dimension from 2009 SP1 to 2013 the new dimension set id is then assigned to documents(Posted and in-posted).
Palla Jagadeesh ,
please check you have create any new global dimensions on your existing (2009SP1) and also its already upgraded NAV 2013 DB
You can check the development environment to see it
HI,
Thanks for reply, am using high end server 64 GB RAM and 1TB Hard Disk
May be due to large DB size it is taking time to update the same as dimension concept changed from NAV 2013 on wards. Try to run high end machine/server and check
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,963 Most Valuable Professional
nmaenpaa 101,156