Database Testing Error - "Urgent"

supportnav

I'm Going to do upgrade process for navision 4 database to navision 5..

Before start upgrade process..
I tested the Navision 4 customized database(Native) with maximum, its got completed except "Test Field relationship between table" option.

While doing the test its showing error as " The type of the constant must not compatible with that of the code field and length of the constant must not exceed the length of the field"

Here i attached the error screen shot..

how to solve this one???

If I ignore this error means, whether it will create any problem while doing upgrade????

DaveT

Hi,
This looks like a design proble with one of the tables. It's linking incorrectly to the Responsibility Centre table.
Firstly try compiling all table objects
Examine modified tables
If all else fails the export to text and search for table 5714

supportnav

Hi Dave,
I Compiled all tables(as well as all object also) I'm not get any error except 6215 table which is showing as "Could not load the selected Library".

And also exported to text and tried with Developer Toolkit for that particular field (Code field in 5714) and table.
but still not able to solve problem.

Request all to help me out for the same.

DaveT

Hi,

I don't think the problem is on the table but a lookup to this table. Export all tables and search for TableRelation="Responsibility Centre" and the check the tables found.

supportnav

Hi,

After searching with all objects for TableRelation, I got some tables as well forms also, I checked those table datas and coding no conflicts has found.

DenSter

Turn on the debugger and run the process again. It will break right where it errors out, you will find what code is executed, and you can make the necessary adjustments.

DaveT

Hi Danial

the debugger will not pick this up as its not firing any C/AL code

Hi Supportnav,

Can you check your table objects again - I am able to recreate this error message by setting the table relation of a decimal field to the Responsibility Centre and then testing the database.

DenSter

Export all tables into one big text file, and search for TableRelation="Responsibility Center"

You could also create a DTK database and do a where used on the responsibility center code field.