https://community.qlik.com/t5/Talend-Studio/MySQL-Data-truncation-Error/m-p/2323911#M93684 Hi,<BR />How is the column in the target MySQL table?<BR />TRF Mon, 30 Jan 2017 14:44:09 GMT TRF 2017-01-30T14:44:09Z https://community.qlik.com/t5/Talend-Studio/MySQL-Data-truncation-Error/m-p/2323910#M93683 <P>When I run my job in TOS, I get a bunch of these error messages towards the end:<BR /><BR /></P> <PRE>Data truncation: Out of range value for column 'odometer_meters_corrected' at row ...</PRE> <P><BR /><BR />The thing is, the tMap is transferring the data between two columns of exactly the same type: INT(11) in the source and INT(11) in the target.<BR /><BR />I was just wondering if anyone knew why this might be happening?</P> Mon, 30 Jan 2017 11:15:08 GMT https://community.qlik.com/t5/Talend-Studio/MySQL-Data-truncation-Error/m-p/2323910#M93683 _AnonymousUser 2017-01-30T11:15:08Z https://community.qlik.com/t5/Talend-Studio/MySQL-Data-truncation-Error/m-p/2323911#M93684 Hi,<BR />How is the column in the target MySQL table?<BR />TRF Mon, 30 Jan 2017 14:44:09 GMT https://community.qlik.com/t5/Talend-Studio/MySQL-Data-truncation-Error/m-p/2323911#M93684 TRF 2017-01-30T14:44:09Z https://community.qlik.com/t5/Talend-Studio/MySQL-Data-truncation-Error/m-p/2323912#M93685 Thank you for the response.<BR /><BR />You got me to double check and it turns out that the source is unsigned but the target is not.<BR /><BR /><span class="lia-unicode-emoji" title=":anguished_face:">😧</span> Mon, 30 Jan 2017 15:54:13 GMT https://community.qlik.com/t5/Talend-Studio/MySQL-Data-truncation-Error/m-p/2323912#M93685 _AnonymousUser 2017-01-30T15:54:13Z