Error codeunit not found while converting 2013 database in nav 2017

Brax007

Hello everyone,
i am currently upgrading data from nav 2013 to nav 2017.

I get this error while opening the 2013 database on nav 2017 (which contains only tables) that block me from converting :
Codeunit 33000250 does not exist.

this codeunit is not called in any table code ( i verfied by exporting the tables and searching for it).
can someone help me to pass this error?

thanks.

Slawek_Guzek

If you don't need the tables at all then you can delete them from the SQL.

First copy the table name list to Notepad/Excel. (only tables between 33 000 000 and 33 000 999)

Then issue the following in the SSMS:

DELETE dbo.[Object] WHERE Type in (0,1) and ID BETWEEN 33000000 AND 33000999
DELETE dbo.[Object Metadata] WHERE  [Object Type] = 1 and [Object ID] BETWEEN 33000000 AND 33000999
DELETE dbo.[Object Metadata Snapshot] WHERE  [Object Type] = 1 and [Object ID]= BETWEEN 33000000 AND 33000999

That should do the NAV side.

The last thing would be to drop all tables which have been deleted from Object table from the database

Slawek

Juhl

It's not a standard codeunit, so there must be an add on somewhere.
Check tables again, there must be something in the version list.

Brax007

thank you for your response. i have a problem finding the add on. Can you tell me how to do an intensive check on the tables?

Juhl

Check all tables that have been modified or have a non-standard entry in the version list. Do this manually. Start with fields over 50000.

But again in should pop up doing text search of all objects, like you tried.

Is the codeunit present in production database?

Brax007

No it's not present in the production db. i'm having problems finding the objects related to it so i can solve the problem.

Slawek_Guzek

Do you have in your database tables with between 200 000 and 99 000 000?

Brax007

yes i do. among them tables with between 33 000 000 and 33 000 999 wich was added by another integration company. i'm facing problems deleting completely those tables from the database.

Slawek_Guzek

If you don't need the tables at all then you can delete them from the SQL.

First copy the table name list to Notepad/Excel. (only tables between 33 000 000 and 33 000 999)

Then issue the following in the SSMS:

DELETE dbo.[Object] WHERE Type in (0,1) and ID BETWEEN 33000000 AND 33000999
DELETE dbo.[Object Metadata] WHERE  [Object Type] = 1 and [Object ID] BETWEEN 33000000 AND 33000999
DELETE dbo.[Object Metadata Snapshot] WHERE  [Object Type] = 1 and [Object ID]= BETWEEN 33000000 AND 33000999

That should do the NAV side.

The last thing would be to drop all tables which have been deleted from Object table from the database

Slawek

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]