NAV2015 Data Upgrade "Object ID Not Found" during processing

rsaritzky

Hi all,

I've got a database that I'm upgrading from NAV2009 to NAV2016. So far, I have
1. Upgraded from NAV2009 to NAV2013, running the "Step 1" upgrade process that stores data in the temp upgrade tables.
2. Opened the database in NAV2015

The database has 4 companies.

Now I'm running the "Data Upgrade" process. It reports an error "Object ID Not found" in only one of the steps, for "Company 1" (out of 4). The other companies all process OK. Here's the detailed output from Get-NAVDataUpgrade. The error message is in the second block (Session ID 4969, Codeunit 104055):

SessionId    : 22
CodeunitId   : 104051
FunctionName : CheckPreconditions
CompanyName  : <Company 1>
StartTime    : 3/29/2016 5:00:49 PM
Duration     : 00:00:00.1406200
State        : Completed
Error        :

SessionId    : 4969
CodeunitId   : 104055
FunctionName : StartUpgrade
CompanyName  : <Company 1>
StartTime    : 3/30/2016 12:33:34 PM
Duration     :
State        : FailedPendingResume
Error        : Object ID not found.

SessionId    : 24
CodeunitId   : 104051
FunctionName : CheckPreconditions
CompanyName  : <Company 2>
StartTime    : 3/29/2016 5:00:49 PM
Duration     : 00:00:00.1562444
State        : Completed
Error        :

SessionId    : 29
CodeunitId   : 104055
FunctionName : StartUpgrade
CompanyName  : <Company 2>
StartTime    : 3/29/2016 5:00:49 PM
Duration     : 00:00:16.5935582
State        : Completed
Error        :

SessionId    : 25
CodeunitId   : 104051
FunctionName : CheckPreconditions
CompanyName  : <Company 3>
StartTime    : 3/29/2016 5:00:49 PM
Duration     : 00:00:00.1406200
State        : Completed
Error        :

SessionId    : 27
CodeunitId   : 104055
FunctionName : StartUpgrade
CompanyName  : <Company 3>
StartTime    : 3/29/2016 5:00:49 PM
Duration     : 00:15:32.3687797
State        : Completed
Error        :

SessionId    : 23
CodeunitId   : 104051
FunctionName : CheckPreconditions
CompanyName  : <Company 4>
StartTime    : 3/29/2016 5:00:49 PM
Duration     : 00:00:00.1406200
State        : Completed
Error        :

SessionId    : 28
CodeunitId   : 104055
FunctionName : StartUpgrade
CompanyName  : <Company 4>
StartTime    : 3/29/2016 5:00:49 PM
Duration     : 00:00:44.2494866
State        : Completed
Error        :

It appears that Codeunit 104055 (UPG6080.StartUpgrade) ran through all its steps, because the last thing that it does is run the following:

IF IsLastCompanyInDatabase THEN
  MarkUpgradeToolkit.MarkTablesForDeletion;

This changes the version tag of all the upgrade objects and other objects to be deleted - and it has done that.

Any ideas from anyone?

Thanks

Ron

postsaurav

It seems a missing object which upgrade routine is looking for.

Check -
1. Do you have addon in the database in NAV 2009. If yes do you have them in 2015.
2. Do you have some custom tables in 2009 which are not there is 2015.
3. Are all your objects in database are compiled. If not compile them and resume the process.

** I always suggest to run the data migration serial not parallel. That will help you in such situation and also in some case it is found that parallel approach locks down the tables.

swpolo

Nav 2015 upgrade step is not possible to debug, so we can only imagine what the real problem is.
This problem could be the object compilation issue and it could be data issue. In some NAV tables there is relations to objects stored as data field. As example table 77 Report Selection.
Check if all objects were transformed to the latest version.

Otherwise it needs deep analysis for such issues.

rsaritzky

swpolo - You mentioned Table 77. The table contains references to some custom reports that are not in the database (the reports are being converted to 2016 so I don't have a 2015 version available). Are you saying that these objects must exist?

Ron

rsaritzky

Suarav,

You ask some good questions:
1. We have addons, and the 2015 database has all the objects migrated from 2009, although there may have been a step where the addon upgrade (Chargelogic) deleted some objects. But there should be no code references to those deleted objects.

2. All our custom tables are in the 2015 database

3. All the objects are compiled.

rsaritzky

Update - there are a handful of Page objects that aren't compiled, but everything else is compiled. I didn't think this would be an issue during the Data upgrade. Is it?

Ron

swpolo

Ron,
1)NAV 2015 cannot find reference if object is not compiled. So it also could be an issue.

2) I mentioned Table 77 only as example. There is not only this table which contains such data.
So when toolkit goes through procedures and finds table like this it tries to refer to this object and cannot catch it.
You should first find such tables and check their data.
This is not trivial task because there is no information on how to find such tables.