Data upgrade not starting

(0) Share

Report

Posted on by NavTech

2,390

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

I have the same question (0)

All responses (5)

Answers (2)

Suggested answer

keoma 32,729 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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

Was this reply helpful? Yes No
NavTech 2,390 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

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

Was this reply helpful? Yes No