NAV2015 upgrade error - metatdata table 89 not found

davmac1 · 2015-03-29

Doing an upgrade from NAV2009 to NAV2015, I received an error:
The metadata object Table 89 was not found.
This is really strange for 2 reasons:
1) Table 89 is the BOM Journal Line which is deleted in NAV2009 at the end of step 1
2) I had converted earlier versions of the database without any problems.

I received this error at the end of the tools -> data upgrade in NAV2015.
There is no table 89, and there should be no table 89.
Does this mean the metadata got messed up in NAV2009?

NAV2015 - some of the upgrade looks like it is handled at the executable level and is not fixable by code.

postsaurav · 2015-03-29

Hey,

Just run Table Journal Line Dimension and filter for Table ID 89 and i hope you find some records.

If there are any delete them and try again the data migration process.

Hope this helps.

davmac1 · 2015-03-29

Thanks.
I have been deleting the BOM Journal Lines in the past. This time the user did it and I have no lines but 2 dimension entries.
Do you know of a safe way to make the resume work? It always starts too early for this problem and fails.
I have though of code to bypass all the conversion routines except the dimensions.
Have you experimented with this before?

davmac1 · 2015-03-29

To get around the last problem, I bypassed the code to update the data, and only updated the dimensions. Since it deleted the old dimensions after it processes them, the current upgrade logic was able to complete updating dimensions.

NAV2015 upgrade error - metatdata table 89 not found

Answers

Categories