for some reason the column data types are not set correctly.
to fix the problem, open the server behaviors panel:
Window -> Server Behaviors
In the server behaviors list, double click the Insert Record Server Behavior. on the second step of the insert record behavior, select each column, then select the proper data type from the data type list