Error: For input string: "31/01/99"

Anonymous — Sat, 16 Nov 2024 10:06:20 GMT

Hi,
I use Talend for Big Data, in executing my job i receive too errors.
`For input string: "31/01/99"
Data truncation: Data too long for column 'Company' at row 33
`
In input file ecxel the format of data is "dd/MM/yyy"
When i chose this format or "dd-MM-yyyy" in input and output schema i receive this error.
My output file it is a table MySQL.
About the second error, the type chosen is string.
I'm sure that you can help me.
Thank you

Re: Error: For input string: "31/01/99"

Anonymous — Fri, 03 Feb 2017 20:26:33 GMT

You are intending to write a date value in a column called "Company" ? I would say you read the wrong excel column or write into the wrong db column. Take care the Talend excel components depends on reading the data at a specific column and need to read all following columns until the last column you are need.

topic Re: Error: For input string: "31/01/99" in Talend Studio

Error: For input string: "31/01/99"

Re: Error: For input string: "31/01/99"