web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Dynamics NAVAX / The given value of type Str...

The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.

Munib Profile Picture Munib 2,500

If you are upgrading to a later cumulative update and try to import a model you may get this error if you haven’t followed the steps.

2014-02-10_1309

You have to run the powershell command before you start the imports. This updates the model store schema to accept new models.

Initialize-AXModelStore

I wanted to find out what was changed in SQL. So, I ran an SQL trace to see which table caused the problem. Then I found that the ModifiedBy and CreatedBy fields where extended from 5 characters to 8 characters.

Before (CU6) After (CU7)
2014-02-10_1310 2014-01-27_1054

This was originally posted here.

Comments

*This post is locked for comments