Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

MySQL Data truncation Error

When I run my job in TOS, I get a bunch of these error messages towards the end:

Data truncation: Out of range value for column 'odometer_meters_corrected' at row ...



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.

I was just wondering if anyone knew why this might be happening?

Labels (2)
2 Replies
TRF
Champion II
Champion II

Hi,
How is the column in the target MySQL table?
TRF
_AnonymousUser
Specialist III
Specialist III
Author

Thank you for the response.

You got me to double check and it turns out that the source is unsigned but the target is not.

😧