Notifications

10 views

Issue

Symptoms


When you try to import a value (e.g.: 9999999999) more than 10 in the integer fields via Easy import, you may observe that the values is changing to 2,147,483,647

Cause


This is the limitation on the platform due to the limits for integers on SQL https://dev.mysql.com/doc/refman/8.0/en/integer-types.html

Resolution


You have to change the type of the field from integer to string in staging table. Also validate the mapping in the transformation map are correct.

 

Article Information

Last Updated:2019-08-02 20:47:14
Published:2019-05-22