topic Re: [resolved] how to catch rejects tmap in Talend Studio

[resolved] how to catch rejects tmap

Anonymous — Sat, 16 Nov 2024 12:39:35 GMT

Hello,
I searched the forum and I have read a lot of postings but I don´t understand how to catch the rejects
when using tmap.
I use two database connectons (tAS400Input) and tMap to create a new csv file (tOutputDelimited).
In the Start (Job....) I see :
Run Job ..... at
connecting to socket on port
connected
For input string: "....." <- this line comes each time a semicolon was used in a field where it should not be used
How can I write this lines in a csv file or tLogRow
I have seen that it´s possible to make "links" with rejects instead of Main or Lookup
hope someone can help me.
Greetings

Re: [resolved] how to catch rejects tmap

Anonymous — Tue, 27 Sep 2011 09:23:29 GMT

Hi
Can you upload some screenshots of job? You should find out the error is thrown on which component
Best regards
Shong

Re: [resolved] how to catch rejects tmap

Anonymous — Tue, 27 Sep 2011 13:28:12 GMT

I double checked and have to give you more details about my job.
I´m exporting data from our AS400 system, the data are written in a csv file.
Then I use these csv files as Inputfiles (tFileInputDelimited) and there I get the error
because there are semicolons in a field because a users used them to seperate text.
Now the programm understands the semicolon as seperator for fields.
For example:
if I have a table with 5 column (name,address,description,phone)
and someone write a semicolon in the the description it will end up in
5 column because semicolon is used to seperate fields and the field phone will be filled with
a part of the description.
At the attached screenshot you can see the Output that I want in an Errorlogfile.
Can I get an error log with tMap and tLogRow?
Who and where do I use tLogRow to get the wrong rows?

Re: [resolved] how to catch rejects tmap

Anonymous — Wed, 28 Sep 2011 09:44:02 GMT

Hi
The error occurs on tFileInputDelimited component, not tMap! You can get the reject rows from tFileInputDelimited by unchecking the box 'die on error', for example:
tFileInputDelimited--main---other components
--reject--tLogRow
If you check the box 'die on error' on tFileInputDelimited, the job will throw the exception and stop once it meets an error.
Best regards
Shong

Re: [resolved] how to catch rejects tmap

Anonymous — Thu, 29 Sep 2011 07:13:33 GMT

Thank you very much.
Bevore I tried 100 times but I didn´t get the reject entry but now I see it.

Re: [resolved] how to catch rejects tmap

Anonymous — Fri, 30 Sep 2011 07:46:34 GMT

Thank you very much.
Bevore I tried 100 times but I didn´t get the reject entry but now I see it.

Cool, thanks for your feedback!
Best regards
Shong