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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Data Truncation with no description

Hi there, im quite new on talend and i have this job

0683p000009MFLK.png
and  of those 453 rows only 87 went to the sql data base, i got this error message 

0683p000009MFLZ.png
Does anybody know what does this mean i got data truncation before but there was an error describtion after the Data truncation message, thank you in advance for your help 

Labels (2)
2 Replies
Anonymous
Not applicable
Author

Hii,
Please check the tMysqlOutput component Length field. I guess, input data length is exceeding DB length field value. So, records got truncated.
Thanks,
Alok 
Anonymous
Not applicable
Author

hi alokdey11 i changed the length of some strings to some ridiculous lengths and there was no error message
thank you!