topic Re: rejected rows capture in Talend Studio

rejected rows capture

_AnonymousUser — Fri, 16 Nov 2012 06:34:29 GMT

Hi, I am New to talend.. please anyone help me on this scenario
- I have a job to transfer data from source table to target table and Iam using some talend input and output database components for example tMySqlInput and tMySqloutput. Iam interested in finding the rejected rows which are not processed by tMySqloutput component..
and how to transfer the data One by one record..

Thanks In advance
ranreddy

Re: rejected rows capture

Anonymous — Fri, 16 Nov 2012 07:12:38 GMT

Hi
The reject row can't be used together with the 'die on error' option and 'extend insert' option in advanced setting tab of tMysqlOutput component, uncheck these two option and then you can use the reject row. Right click on tMysqlOutput, select Row, and then Reject.

Re: rejected rows capture

_AnonymousUser — Fri, 16 Nov 2012 09:03:07 GMT

hi shong
thanks for ur rply..
How to send a mail these rejected record information.

Thanks,
ranreddy

Re: rejected rows capture

Anonymous — Fri, 16 Nov 2012 09:50:44 GMT

hi shong
thanks for ur rply..
How to send a mail these rejected record information.
Thanks,
ranreddy

To send a mail, you can use tSendMail component. You can output all the reject rows in a file and attach it in the mail or sent all the reject rows in the body part of the mail.

Re: rejected rows capture

_AnonymousUser — Fri, 16 Nov 2012 11:50:21 GMT

Thanks for ur help shong.
I am facing the problem here only, how to attach the record's all information in a file?

Thanks
Ranreddy

Re: rejected rows capture

Anonymous — Fri, 16 Nov 2012 11:54:11 GMT

As you already connected your flow to the output database component do it in the same way to drag the reject output flow from your output database component to a tFileOutputDelimited component. In the file component you should consider to set the option Add Header and choose a proper field delimiter and of course you have to choose the full file path.
It could be helpful to put an tMap between your last flow, because the reject output flow contains two additional field which contains the error message and the stacktrace. That can disturb your file structure.
In the tMap you can consider to not connecting this both special columns to the file output flow.

Re: rejected rows capture

_AnonymousUser — Fri, 16 Nov 2012 13:59:39 GMT

Thanks for your reply mr.Jlolling,

Is there any possible to send a mail with rejected records information like email content, i mean not like attached file?

Thanks,
Ranreddy

Re: rejected rows capture

Anonymous — Sat, 17 Nov 2012 05:07:56 GMT

Hi
Yes, you can send all the reject records in the email body. Link a reject flow from tMysqlOutput to a tJavaFlex, collect and concatenate all the reject records. for example:
tMysqlInput--(row1)main--tMysqlOutput--(row2)reject--tJavaFlex
|
onsubjobok
|
tSendMail
at the begin part of tJavaFlex, defing a string, eg:
String reject_record="";
at the main part of tJavaFlex,
s=s+row1.column1+";"+"row1.column2"+"\n";
at the end part of tJavaFlex, put the string to a list. eg:
globalMap.put("mykey",reject_records);
In the body part of tSendMail, get all the reject records from the list, for example:
"The reject records are:"+"\n"+(String)globalMap.get("mykey")
Shong

Re: rejected rows capture

Anonymous — Fri, 14 Feb 2014 21:57:57 GMT

Hi i am new too, how can i know, how many records were rejects.
tks
sssalvatierra

Re: rejected rows capture

Anonymous — Sat, 15 Feb 2014 15:49:35 GMT

Nearly all flow processing components provides a return value called NB_LINE. You can find them in the Outline view.
If you want only count the rejected rows you could use the tJavaRow component. This component does nothing if you do not add your own Java code but it counts the lines.

Re: rejected rows capture

_AnonymousUser — Mon, 04 Aug 2014 21:44:55 GMT

I have rejects set up to redirect bad data to an excel file. I have checked the option don't generate empty file clicked. My job is still creating an empty file. Please help what should i do to avoid this thank you
Thank You

Re: rejected rows capture

sasi8008 — Tue, 04 Oct 2016 07:24:08 GMT

Hi, How to create a joblet for this, in my project i have 200 jobs .

Re: rejected rows capture

Anonymous — Wed, 08 Mar 2017 19:40:29 GMT

I'm writing all the rejected data to a file and how do i need to send a mail of the that output file. Please help

Re: rejected rows capture

TRF — Thu, 09 Mar 2017 08:23:24 GMT

tSendMail with file attachment

Re: rejected rows capture

Anonymous — Thu, 09 Mar 2017 16:27:35 GMT

Can you please help on how to get the count of records using NB_LINE. Please explain how to use it.