topic Re: [resolved] error talend : For input string in Talend Studio

[resolved] error talend : For input string

Anonymous — Sat, 16 Nov 2024 11:35:27 GMT

Hello,
i want to load data from an excel file into a mysql database.
I have this problem "For input string : 169.36" (when the value of the colum is for example 147,00 there is no pb, but when it's for example 178.36) i got the error above.

here is a screenshot of my job

Thank you

Re: [resolved] error talend : For input string

Anonymous — Wed, 09 Jul 2014 15:46:06 GMT

This is common metadata issue..
when input column metadata does not matches with the defined metadata, this error will come...
Pl check metadata against the data for that particular record.
Vaibhav

Re: [resolved] error talend : For input string

Anonymous — Wed, 09 Jul 2014 15:49:15 GMT

thank you for your response Sir,
How can i view the metadata?

Re: [resolved] error talend : For input string

Anonymous — Wed, 09 Jul 2014 15:54:16 GMT

hi,
click on "schema" for in/output component or on any flow.
regards
laurent

Re: [resolved] error talend : For input string

Anonymous — Wed, 09 Jul 2014 16:24:01 GMT

i still have this issue , but when i don(t get this error anymore but when i insert the value 126.14 i get 12614, how can i solve this pb

Re: [resolved] error talend : For input string

Anonymous — Wed, 09 Jul 2014 16:34:52 GMT

be sure that all rows have the same structure.
as sanvaibhav said, it's a metadata problem. Your try to read some data with a wrong structure.
If you cannot find the wrong one, use tSchemaCompliancecheck against expected structure and catch reject + error that show yous where problem(s) 's occured.
hope it help
regards
laurent

Re: [resolved] error talend : For input string

Anonymous — Wed, 09 Jul 2014 16:47:36 GMT

hi,
For that value data type in job you may have given INT. but your getting DECIMAL values.
There should be proper DATA TYPE between your data and file component.
from file component uncheck "Die on error", and give reject flow to one temporary file. then all rejected rows will be captured in that file.
Regards,
Akki

Re: [resolved] error talend : For input string

_AnonymousUser — Wed, 15 Mar 2017 19:41:04 GMT

This is common metadata issue..
when input column metadata does not matches with the defined metadata, this error will come...
Pl check metadata against the data for that particular record.
Vaibhav

Thank you very much. I was looking around for any solution but with no lucky, however you gave me the key. In fact, the problem was the metadata where I had a column with decimal values, defined as Integer. After I've changed this column to Double the problem has gone.