"Invalid column name" when migrating to NAV2013 R2

Pachi

When migrating from NAV 2009 SP1 to 2013 R2 following steps defined in…

http://blogs.msdn.com/b/nav/archive/2013/11/22/upgrade-toolkit-for-upgrading-data-from-microsoft-dynamics-nav-2009-r2-and-microsoft-dynamics-nav-2009-sp1-to-microsoft-dynamics-nav-2013-r2.aspx?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+MicrosoftDynamicsNavTeamBlog+%28Microsoft+Dynamics+NAV+Team+Blog%29&PageIndex=2#comments

… and after convertig database to 2013 R2 and importing new and personalized objects, we get following error trying to open Windows Client:


The following SQL error was unexpected.

Invalid column name 'Queue Folder Path'.

Invalid column name 'Queue Folder UID'.

Invalid column name 'Storage Folder Path'.

Invalid column name 'Storage Folder UID'.

Invalid column name 'Autodiscovery E-Mail Address'.

Invalid column name 'Email Batch Size'.

Statement(s) could not be prepared.


All these fields are in table 5079 – Marketing Setup


We have tried to export a FOB file, delete Object Metadata table registers for T5079 but unsuccessfully.

Afterwards, following the same steps, we have released that SQL takes some time in updating fields in this table. Only after several minutes, SQL update this fields.

Afterwards, again, uploading other objects, SQL takes a long time (hours) to update fields… so we cannot continue. We have modified the following line in configsettings…

<add key="SqlCommandTimeout" value="00:30:00" />

… to setup several hours, but unsuccesfully.

Could anyone help us with some kind of orientation?

Thank you,

mohana_cse06

Did you try by setting "Prevent data loss from table changes" to No under Tools-->Options?

geordie

Did you compile the tables right after 2013 -> 2013 R2 conversion and object import, before connecting the service tier to the db?

Luc_VanDyck

I had the same issue today. Could solve it with installing Build 36281 of NAV 2013 R2 (through hotfix https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2934571).