Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Data upgrade not starting

Posted on by 2,382

I am upgrading database from 2009 to 2015 . I have followed all the steps given in microsoft document . I am at the stage of data upgrade . I go to tool->Data Upgrade->Start but then process dosnt start. State display as stopped.I tried with cmdlet but it shows no error .

5126.Untitled.png

*This post is locked for comments

  • Verified answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Data upgrade not starting

    Agreed with Jonathan.

    Before starting the Upgrade Step 02, you need to have a working Dynamics NAV instance configured to NAV 2015 DB.

    Upload the partner license

    Restart the NST (Application service)

    Compile the system tables ( Sync should be set to Later)

    Run the Sync-NAVTenant in NAV administration Shell (As admin)

    Import objects (New object with new fields, if not you will lose data)(Sync Later)

    Import Upgrade601800.IT.2.fob (Sync Later)

    Run the Sync-NAVTenant in NAV administration Shell (As admin)

    Compile objects (with validation)

    Run Data upgrade step 2

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Data upgrade not starting

    cu 1 is therefore missing or not compiled. if not compiled, compile it, correct compile errors, compile again.

    if you upgrade directly from nav 2009 to nav 2015, then it's correct to use import the localised upgrade objects, in your case Upgrade601800.IT.1.fob. this fob file is for data upgrade step 1. it is used to prepare the database so you can open it in the nav 2015 dev. env.

    after running the upgrade step 1 in nav 2009 dev.env and deleting all objects except the tables you can then open the database in nav 2015 and convert it. now you have to import all nav 2015 objects from a clean nav2015 cronus database, where you have added the custom table fields from the nav 2009 database, so you do not loose any data.

    now a configured nav 2015 service, which is connected to the upgraded database, is needed. after that run the sync with option later and compile all objects. after that, import Upgrade601800.IT.2.fob for data upgrade step 2.

    if all runs fine, start the upgrade page, that needs a working windows client and run data upgrade step 2.

  • NavTech Profile Picture
    NavTech 2,382 on at
    RE: Data upgrade not starting

    I checked event viewer .It is giving error of codeunit 1. below is error

    Object of type CodeUnit with id 1 could not be found.

    I need to upgrade database from 2009 to 2016 . I have already compared ans merged all 2009 customisation into 2016 and then I started database upgrade .For this purpose I am following below approach.

    according to the document "Upgrading a Microsoft Dynamics NAV 2009 R2 or Microsoft Dynamics NAV 2009 SP1 Database to Microsoft Dynamics NAV 2015" there are upgrade objects on the NAV2015 CD "Upgrade601800.IT.1.fob" (NOT "Upgrade601800.US.fob") . Then followed all the step to transfer data deleted objects except tables.

    Then, the NAV2009 database is backed up and restored into a NAV2013 Environment.  This involves, as far as I understand, just opening up the database and letting the process run - a lengthy process because it changes collation and converts everything to Unicode.

    Then, the NAV2013 database is backed up and restored into a NAV2015 environment.  Again, you open the database and let the process run.  

    Then, run the "Synchronize Schema" again .

    Then import the ""Upgrade601800.US.fob" file to install the data upgrade objects.  Then, run the "Synchronize Schema" again and do the "Tools", "Data Upgrade" .

    I can not import merged object because I have merged them into 2016. Pls let me know how should I proceed.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Data upgrade not starting

    Check whether you have imported the codeunit required for data upgrade in databases.

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Data upgrade not starting

    check windows eventlog for detailled errors

    check if nav 2015 service is connected to database

    check if nav service account has db_owner access to database

    restart nav service, check if there are error messages according nav service start/database access in windows eventlog

    compile system tables (the last ~ 20 tables)

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans