topic Re: [resolved] How to Capture Error data using Reject link and with TMap Component in Talend Studio

[resolved] How to Capture Error data using Reject link and with TMap Component

Anonymous — Sat, 16 Nov 2024 12:07:41 GMT

Hi
I am new to use Talend Open Studio Data for Data Integration. I need your suggestions in My Scenario, here is: I am trying to get data from salesforce and then transforming it into my Postgres Database. Source Data: salesforce>accounts and Targeted Table: salesforce_account (which is my database).
In this job, i am using tmap component.In tmap component i also enabled Die or Error option still i am not able to read data into errorreject table (I did add columns also)
on the other hand i enabled batch size option from advanced settings in salesforce_account (my database component) and then i added delimiter file to record the error data which is neither working.
Requirement:
1) need to record error data.
2) Also need suggestion if any thing needs to be added in expression for errorstackTrace in ErrorReject Table.
Please find the Images attached.
Thanks in Advance.

Re: [resolved] How to Capture Error data using Reject link and with TMap Component

Anonymous — Mon, 31 Dec 2012 07:41:42 GMT

Hi,
Die on error and reject link can not be used at the same time. Die on error means when the job encounter a error, the job will be stopped enforce , but reject link means when the job encounter a error, it will catch the error and then continue to do the next record. So if you want to use the reject link on tMap, don't check the option of "Die and error"

Best regards
Sabrina

Re: [resolved] How to Capture Error data using Reject link and with TMap Component

Anonymous — Mon, 31 Dec 2012 10:14:00 GMT

Thanks for the explanation my issue is resolved.

Re: [resolved] How to Capture Error data using Reject link and with TMap Component

Anonymous — Fri, 04 Jan 2013 02:22:19 GMT

Hi,
Welcome, and thanks for your feedback!
Best regards
Sabrina