Import error message

deepblue

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?

andrejsm

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.

kriki

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.

deepblue

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

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.