Data Type mismatch Nav 2013 issue

This question has suggested answer(s)

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 ..

All Replies