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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2013-09-02 10:01 AM

[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)
Labels
849 Views
0 Likes
16 Replies
Anonymous
Not applicable
‎2013-09-03 07:10 AM
Author

Hi,
I suspect the remaining(10 rows) are rejected by your MSSQL DB.
Please unchecked option "Use Batch Size" in Advanced setting to link "Rejects" row. Let me know if there is any rejected row.
Best regards
Sabrina
250 Views
0 Likes
Anonymous
Not applicable
‎2013-09-03 07:38 AM
Author

Hi Sabrina,
I unchecked "Use Batch Size" and attached the screenshot for "Data Truncation". As per your screenshot i am not able use Row->reject (where Should i use 'Reject' ?).
Thanks,
Venkateswarlu.
250 Views
0 Likes
Anonymous
Not applicable
‎2013-09-04 12:30 AM
Author

Hi,
As per your screenshot i am not able use Row->reject (where Should i use 'Reject' ?).

The "Rejects" row should come from tmssqloutput(right click the tMSSqloutput component ).
Prerequisite: unchecked "Die on error" and "Use Batch Size" option.
Are you unable to get it? Which talend product build are you using, I will take a testing on it.

Best regards
Sabrina
250 Views
0 Likes
Anonymous
Not applicable
‎2013-09-04 01:38 AM
Author

Hi Sabrina
Presently i am using Version: 5.3.1. & Build id: r104014-20130618-0337 and it's already unchecked "Die on error" and "Use Batch Size" option. but same message getting.
Thanks,
Venkateswarlu.
250 Views
0 Likes
Anonymous
Not applicable
‎2013-09-04 03:32 AM
Author

Hi,
Presently i am using Version: 5.3.1. & Build id: r104014-20130618-0337 and it's already unchecked "Die on error" and "Use Batch Size" option. but same message getting.

There must be data truncation data in your ETL so you have got the message "Data Truncation" message. For now, what we can do is to find these missing 10 data by "Rejects" row.
I have made a testing on 5.3.1. & Build id: r104014, I can get the "Rejects" row. You can get it if you unchecked "Die on error" and "Use Batch Size" option. but same message getting.
Best regards
Sabrina
250 Views
0 Likes
Anonymous
Not applicable
‎2013-11-08 07:18 PM
Author

Hi Sabrina,
Iam using TOS 5.3.1. When I run my job I am getting Data Truncation even though the row is green in color.
Do you have any idea of what is happening?
250 Views
0 Likes
Anonymous
Not applicable
‎2013-11-09 01:49 AM
Author

Hi fadh
You can take a look at this KB article to know more about data truncate error,
https://community.talend.com/t5/Migration-Configuration-and/Data-truncation-error-Data-too-long-for-...
The length of some data exceeds the max length defined for the field in the target table.
Shong
250 Views
0 Likes