When synchronizing or executing a NAV data source, the following error message may appear.
"The given value of type String from the data source cannot be converted to type nvarchar of the specified target column."
When using the NAV Adapter data source type, this error message has been tied to the value set for the 'Option Field Text Length' in the Navision Enhancements Settings.
To change this value, right-click on your NAV data source and select Enhancements > Navision Enhancements Settings as shown below:
In the window that opens, adjust the 'Option Field Text Length' to a value large enough for your existing Option Field values. Click OK to continue.The currently supported maximum value is 4000 characters. Please visit our support site for assistance if you have option values that exceed this.
After adjusting the Option Field Text Length, you will need to synchronize the data source objects for the updated length value to be applied to the corresponding tables within your staging database. To do so, right-click on your NAV data source and select 'Synchronize Objects'.If the data source has not been previously synchronized, this will be displayed as 'Read Objects' instead of 'Synchronize Objects'
The last step to push these changes to your entire project is to Deploy and Execute the tables and objects that have been modified. To do so, right-click on your Project name (top-most node of your project) and select Deploy and Execute > Deploy and Execute Modified Objects
In the ensuing window, simply click Start to begin the process.