Options

Another user has changed the definition of the Field table

rcverbeekrcverbeek Member Posts: 32
edited 2014-07-17 in NAV Three Tier
Hi,

We sometimes get the following error in Dynamics NAV:

Another user has changed the definition of the Field table after the activity was started.

Does anybody knows what this means. What is the "Field" table?

Our settings are:
Microsoft Dynamics NAV 2009R2
Version 6.0.32012.0
Using the RTC

Thank you in advance!

Comments

  • Options
    tinoruijstinoruijs Member Posts: 1,226
    Could be a table is changed and you need to logout and login in NAV again.
    Or another user modified the same record.
    Or wrong modifications.
    Are there regular updates of objects in your NAV?

    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Options
    Borrachon2013Borrachon2013 Member Posts: 5
    Hello,

    Just encountered the same error.
    Allthough everyting mentioned above here could be the cause, I found another one:
    In both the Form and the Table the same (REC) Global Variable was created (in this case, 2 times 'Cust' for Customer).

    Then Navison has 2 copies of a Table with the same name. This causes an error sometimes, as navision checks whether you still have the latest version of the record.

    The Field Table ia a visual table with all the Information about Tables and fields in the database. If you use change log, navision checks if the definitio of the field you workin' on is the same as in this visual Table. If someone has changed this definition whlie you were workin, you get the same error.

    Hop that I've been of some help,

    Raymond
    Simple is simply the best
  • Options
    rcverbeekrcverbeek Member Posts: 32
    Hi Tino, Raymond,

    Thanks for your replies. Its good to know what the 'Field' table actually means. We kept receiving the error after closing and reopening the RTC client.

    We will be looking into the duplicate record name, this is a tangible enough clue!

    Roeland
  • Options
    einsTeIn.NETeinsTeIn.NET Member Posts: 1,050
    Actually the Field table is a virtual table that shows all fields available in the database across the different tables.

    If the definition of a certain table is changed during you're working on the data of exactly that table, you should get another error (something like: The Definition of Table xyz has changed after your activity started. Please enter your values again.).

    The definition of table Field should never change as it is some kind of system created table. No one (apart from Microsoft) should be able to change the definition of that table. Of course, you're able to change the content of the table (e.g. by changing the fields of some table), but the definition (how that table is constructed) shouldn't change.

    In RTC we have another table called Object Metadata that provides the definition of every table to the RTC. That way the RTC knows how the data is structured that is entered into a certain table. If the Object Metadata record, that represents the Field table, is corrupt then you would get exactly that error message referring to the Field table. You need to figure out why that record gets corrupted.

    Sometimes it's just the NAV client itself that corrupts his own data. In that case your issue could be solved by a hotfix.
    "Money is likewise the greatest chance and the greatest scourge of mankind."
Sign In or Register to comment.