one field does not exist in Sql server table or view?

nebular
nebular Member Posts: 6
edited 2011-01-28 in Navision Attain
When I backup the database, navision give me a error:
The Lot N?on quote field on the sales line buffer table does not exist in the SQL Server table or view.

then backup stop.
has anyone an idea?

Comments

  • awarn
    awarn Member Posts: 261
    Was this field deleted from SQL Server and not Navision?
  • GoMaD
    GoMaD Member Posts: 313
    I've got the same problem, but the field isn't deleted from Navision. The field in my db is named on SQL level "Volume M³" and on Navision Level it's named "Volume my".

    I"ve tried changing the name in Navision to the SQL name, but that doesn't work (error as nebular mentioned).
    I can change the SQL name so that it matches the navision one, but still the same error.

    Anybody?
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!
  • DenSter
    DenSter Member Posts: 8,307
    Make sure that the collation of the original database is the same as the database that you are trying to restore into
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • ls
    ls Member Posts: 33
    I've the same problem on NAV 2009 SP1. Do you have any suggestion, please?

    ls
  • GoMaD
    GoMaD Member Posts: 313
    search for special characters in the column names
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!

Categories