Failed to save changes to table with Synchronise schema option "Now - with validation"

cecil.chen@live.com

I got an error "Unable to process table changes" when I tried to save a change to my table definition in Microsoft Dynamic NAV 2016 Development Environment.

Save screen


Error Screen




I have a two-tier setup for running Microsoft Dynamic NAV 2016:

Machine 1 (Windows 2012 VM running on my local machine with host only network adaptor):

• Windows Authentication
• Microsoft Dynamic NAV 2016 server
• MS SQL 2014 server

Machine 2 (My local machine):

• In AD Domain
• Microsoft Dynamic NAV 2016 Client
• Microsoft Dynamic NAV 2016 Development Environment
  

I am very sure that all the firewall is turned off and everything is running correctly. My NAV development environment on my machine 2 is able to connect to the database server using Database Server Authentication.

Once I got the error, I went back to my machine 1 and check the event log. It shows following error message:





Does anyone have any clue on this error?

postsaurav

Hi @cecil.chen@live.com ,

Try These Steps -
1. Check that your user id is set as db_owner in SQL Database.
2. Run Developer Environment as administrator.

Let us know how it goes.

saravanans87

Check the Permissions for Service Account if you are using and also look for NT AUTHORITY\NETWORK SERVICE if you are using network service.

cecil.chen@live.com

Thanks for the reply.

The user on database was set up correctly.

I installed a NAV development environment on Machine 1. I had no problem on saving any change of the tables.

The problem just happened from the NAV development environment running on Machine2.

rsaritzky

This message also appears when your change of the table could result in a loss of data. For example, if you changed the length of a field from 50 to 30, you will lose data. Or if you remove a field. NAV requires you to either build some code that "handles" the change, or use the "Force" option (use with caution!).

Can you describe what change to the table you did? Perhaps that will explain it.

Ron