[resolved] Data Truncation Error

One Star

[resolved] Data Truncation Error

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!
One Star

Re: [resolved] Data Truncation Error

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!
One Star

Re: [resolved] Data Truncation Error

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!
Community Manager

Re: [resolved] Data Truncation Error

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] Data Truncation Error

Thanks Shong for the text enclosure hint. Issue resolved.
Seven Stars

Re: [resolved] Data Truncation Error

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.