topic Re: Handling Database Rejected Rows on Error. in Talend Studio

Handling Database Rejected Rows on Error.

_AnonymousUser — Mon, 29 Feb 2016 18:21:31 GMT

Hi,
What is the best way to handle and send an email with Rejected Rows on Error for tOracleOutput Component?
And
How to send RowsOnError as attachment?
How to send RowsOnError as Email Message body?
Can we raise an warn message and catch that warn and send an email?If so how transform Rejects to twarn?
Please let me know how to build it.
Appreciate your Help.
KK

Re: Handling Database Rejected Rows on Error.

Anonymous — Tue, 01 Mar 2016 02:53:16 GMT

Hi,

The 'Die on error' option can not be used with reject link together, if you want to use reject link, the 'die on error' option should be unchecked. You can send an email if the some rows are rejected. For example:
....tOracleOutput--reject--tFileOutputDelimited--runIf--tSendMail
It outputs the rejected rows to a file, this file can be attached in the mail if needed,
set the condition of runIf as:
((Integer)globalMap.get("tFileOutputDelimited_1_NB_LINE"))>0
If you want to send rejects rows as email Message body, you should pass rejects rows into context value by using tJavaRow firstly, and then getting the context value in Message body of tSendMail.
Here is a related forum for this scenario, please refer to: https://community.talend.com/t5/Design-and-Development/resolved-Sending-the-content-of-tfileoutputdelimited-to/td-p/73173
Feel free to let us know if it is OK with you.
Best regards
Sabrina

Re: Handling Database Rejected Rows on Error.

Anonymous — Tue, 01 Mar 2016 07:26:55 GMT

Unless the reject file is so large that it would be impractical to Email it, I always send it as an attachment (.csv) which is more useful than having it in the Email body.