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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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!