Database Testing Error - "Urgent"

supportnav
supportnav Member Posts: 34
edited 2009-03-03 in NAV/Navision Classic Client
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????

Answers

  • DaveT
    DaveT Member Posts: 1,039
    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
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • supportnav
    supportnav Member Posts: 34
    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
    DaveT Member Posts: 1,039
    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.
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • supportnav
    supportnav Member Posts: 34
    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
    DenSter Member Posts: 8,307
    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.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • DaveT
    DaveT Member Posts: 1,039
    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.
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • DenSter
    DenSter Member Posts: 8,307
    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.
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories