topic Re: [resolved] Data Truncation Error in Talend Studio

[resolved] Data Truncation Error

Anonymous — Sat, 16 Nov 2024 13:31:46 GMT

Hello,
I received lines of "Data Truncation" messages when I tried to import data from csv into table. Image attached.
Can someone help me troubleshoot which column it is causing this? "Data Truncation" is very vague right now, and no records are imported even though from the Job run, it says 200 rows read.
Your helps is appreciated!

Re: [resolved] Data Truncation Error

Anonymous — Tue, 02 Mar 2010 00:34:06 GMT

After changing field separator, I received the following warning, and thus, no rows inserted.
For input string: ""1333""
Is there a reason why Job still completed successfully even though there's such warning and data wasn't imported?
Is there a way to trigger java exception when import validation fails or no rows are imported?
Thanks!

Re: [resolved] Data Truncation Error

Anonymous — Tue, 02 Mar 2010 01:42:49 GMT

Additional Question - If column separator is comma, but each field is has quoted identifier around it(ie "http://talend.org,Story=rss"), what should I include in the Text enclosure or Escape char?
I used "''''"", but received Error Message - "Invalid character constant"
Thanks in advanced!

Re: [resolved] Data Truncation Error

Anonymous — Tue, 02 Mar 2010 01:58:12 GMT

Hello
Do you do 'create table' action on tOracleOutput? Can you upload some screenshot of tOracleOutput?
About the double quote, you need check the 'csv' option, set the escape char as """, text enclosure """
Best regards
shong

Re: [resolved] Data Truncation Error

Anonymous — Tue, 02 Mar 2010 18:59:15 GMT

Thanks Shong for the text enclosure hint. Issue resolved.

Re: [resolved] Data Truncation Error

alevy — Fri, 05 Mar 2010 01:58:18 GMT

Hi captainlaw. FYI, you can link a rejects flow from your tMSSqlOutput component, which will contain a detailed error message as to which field caused the problem in MSSQL.