Import error message

deepblue
deepblue Member Posts: 152
edited 2006-03-08 in NAV/Navision Classic Client
hello,

During the process of Upgrade of Navision 2.60 towards Navision 4.00, I must import the fob file created by merge and compare. During the importation this error message appears and the importation stops.
"You cannot remove or modify the type of the field “N°” (in the table G/L Account) before the value of the field is reduced to 0 or '' in all the records. This message was displayed because a nonnull value was found in the N°='100000' record of the company…"

what should I do?

Comments

  • andrejsm
    andrejsm Member Posts: 122
    It looks like you skiped some steps in upgrade process. Usualy it is necessary to move data from tables to temporary tables. And then after tables update, move data back. If you didn't do it system could not modify table field property, if table have data.
    Andrejs Muraskins
  • kriki
    kriki Member, Moderator Posts: 9,121
    It is also possible that in your old version you had some new customized fields that you forget to port into the new version.

    Or also : it is possible Navision-Tunisia (or whoever makes your standard country version changed the type of the field from text to code or code to text.
    FIX : make a dataport to export the records and delete the records from the DB. Then import your objects and then import the records.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • deepblue
    deepblue Member Posts: 152
    I've tried to make a dataport to export the records and delete the records from the DB. But when I try to delete the records from G/L Account two error messages saying "Tabledata 403 doesn't exist" and "Tabledata 5121 doesn't exist" appear. :(

    thanks for help!!!
  • kriki
    kriki Member, Moderator Posts: 9,121
    deepblue wrote:
    I've tried to make a dataport to export the records and delete the records from the DB. But when I try to delete the records from G/L Account two error messages saying "Tabledata 403 doesn't exist" and "Tabledata 5121 doesn't exist" appear.
    Delete the records with C/AL code, so the triggers aren't fired. Create a form on the table (no need to save it) and in the OpOpenForm, you just put 
    DELETEALL(FALSE);
    Run the form and you won't see a record because they were just deleted.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories