[resolved] how to catch rejects tmap

One Star

[resolved] how to catch rejects tmap

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

Accepted Solutions
Community Manager

Re: [resolved] how to catch rejects tmap

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

All Replies
Community Manager

Re: [resolved] how to catch rejects tmap

Hi
Can you upload some screenshots of job? You should find out the error is thrown on which component
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] how to catch rejects tmap

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

Re: [resolved] how to catch rejects tmap

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

Re: [resolved] how to catch rejects tmap

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

Re: [resolved] how to catch rejects tmap

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