Tuesday, December 29, 2015

The table definition is invalid and can not be validated Error in Nav 2013 R2

In Microsoft Dynamics NAV 2013R2 when you try to add fields or update anything then you would encounter this Error(The table definition is invalid and can not be validated )..



As you can see Nav won't accept any changes to table and hence cannot be validated. To overcome this there is a simple Solution Many of you may already Know this...

There is a Option in TOOLS---->Options-->Prevent Data Loss From Table Changes. As this is Set to Yes you were not able to change the Fields/ change structure of table.

So Set Prevent Data Loss From Table Changes To NO.


You have to do this every time you change your table So Microsoft released a HotFix to Eliminate this problem..Click here to Redirect to HotFix.







Posted by at
Labels:

1 comment:

  1. Kz007August 24, 2020 at 6:52 PM

    I got this same error in NAV 2017. To resolve it, do the following:
    1. Compile the object with the "Synchronize Schema...LATER". This will add the New Field to the table
    2. Then Recompile the Object again, this time the "Synchronize Schema...Now - with validation"

    ReplyDelete

Subscribe to: Post Comments (Atom)