Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

"Ledger Entry Dimensions" are preparing to update in NAV 2013 Data Upgrade

Posted on by 310

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: "Ledger Entry Dimensions" are preparing to update in NAV 2013 Data Upgrade

    Hi Palla,

    Were you able to this issue? I am having the same problem. Thanks

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: "Ledger Entry Dimensions" are preparing to update in NAV 2013 Data Upgrade

    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).

  • Suggested answer
    dkatson Profile Picture
    dkatson 2,263 on at
    RE: "Ledger Entry Dimensions" are preparing to update in NAV 2013 Data Upgrade

    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.

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: "Ledger Entry Dimensions" are preparing to update in NAV 2013 Data Upgrade

    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).

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: "Ledger Entry Dimensions" are preparing to update in NAV 2013 Data Upgrade

    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

  • Palla Jagadeesh Profile Picture
    Palla Jagadeesh 310 on at
    RE: "Ledger Entry Dimensions" are preparing to update in NAV 2013 Data Upgrade

    HI,

    Thanks for reply, am using high end server 64 GB RAM and 1TB Hard Disk

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: "Ledger Entry Dimensions" are preparing to update in NAV 2013 Data Upgrade

    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans