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: 
Anonymous
Not applicable

[resolved] "Data Truncation" Message

Hi,
Why the " Data Truncation" message Displayed while run the job ,even data moved to destination Table. can anyone help?
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,
Please see the document to know TalendHelpCenter:Exception Data truncation Data too long for column.
Please give us more information about your current exception scenario.
Best regards
Sabrina

View solution in original post

16 Replies
Anonymous
Not applicable
Author

sorry
not with those details - actually you did not provide any detail ...
describe your job (take a screenshot) and post the output that you are receiving
Anonymous
Not applicable
Author

Hi,
Please see the document to know TalendHelpCenter:Exception Data truncation Data too long for column.
Please give us more information about your current exception scenario.
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi Sabrina,
Thanks for Providing documents,the issue because of sending Data length too long . i resolved it
Regards,
Venkateswarlu.
Anonymous
Not applicable
Author

Hi,
Thanks for your feedback. Don't hesitate post your issue on forum.
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi Sabrina,
Sorry , while run the job same message is displaying as shown below , but data reached to destination table. what's happening internally.
connecting to socket on port 3736
connected
Data truncation
disconnected
Regards,
venkateswarlu.
Anonymous
Not applicable
Author

Hi,
Could you post your trouble screenshots into forum so that we can get your current job workflow. Is there any "Rejects" row from your DB output?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi,
Anonymous
Not applicable
Author

Hi,
Did you check the option "Die on error" to see if there is any other error message? Usually, If you are getting data truncation you will get rejects. But the input row is equal to output row(61 rows). The data in target table is normal? not clipped or truncated?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi Sabrina,
No i didn't check the Die-on error and no more error messages apart from that show message. And one more thing out of 61 rows, 51 rows moved to table remaining not stored but in the indication 61 rows moved(green symbol).
Thanks,
Venkateswarlu