Data Type mismatch Nav 2013 issue

saurabhabh

Hi guys ,

Recently i upgraded Nav2009 R2 to nav 2013 and when i try to access my pages which in turn access the tables it gives me error saying that the value contained in the SQL server is incompatible with the data type of the table created in Navision. But this was working perfectly fine in Nav 2009 R2.

what is wierd is that it is showing that the small int and the integer datatypes as mismatch. Not able to understand why it should happen.

Please see the attached file for the complete error.

Hoping for a quick reply .. :-)

saurabhabh

In some post i read that Nav 2013 is more compatible with the SQL server 2013 . So i tried that as well Still its giving the Same error. If i change the SQL Data type from 'tinyint' to 'integer' it works fine. But i dont want to make this change as it would cause me a lot of databse redesigning. Also according to microsoft (http://msdn.microsoft.com/en-in/library/dd338749(v=nav.70).aspx ) tinyint is compatible with integer data type of Nav. I am unable to understand why it is giving compatibility issue.