topic Re: tSalesforceOutput - Error logging file in Talend Studio

tSalesforceOutput - Error logging file

Anonymous — Sat, 16 Nov 2024 10:30:52 GMT

Hi Community. Im trying to write big volume of data in Salesforce using tSalesforceOutput component and there is lot of data quality errors in the file. I dont want the job to die on each error so in component Advanced settings I uncheck the 'Die on error' and set the path for Error logging file. However the result file is in terrible format for me, I would like to have in spreadsheet one row for each error. Is that possible? many thanks for help

Re: tSalesforceOutput - Error logging file

Anonymous — Wed, 13 Jul 2016 09:55:17 GMT

Hi,

I uncheck the 'Die on error' and set the path for Error logging file.

Are you using Stats&Logs feature in job review or tLogcatcher component? Could you please give us more information about your error logging file?
Best regards
Sabrina

Re: tSalesforceOutput - Error logging file

Anonymous — Thu, 14 Jul 2016 15:49:43 GMT

Hi, thanks. Im on version 6.1.1 and what I have been using is in Advanced settings of tSalesforceOutput component. There is checkbox "Die on error" and "Error logging file" where you can set the path for the file to be saved. I dont know those features you mentioned. The error logging file looks like something below but my question is if the format could be somehow changed to have one error per row generated, not like this. Thank you

Status Code: INVALID_EMAIL_ADDRESS
RowKey/RowNo: 1
Fields: Email
Message: Primary Email: invalid email address: microsoft.com
--------------------------------------------------------------------------------
Status Code: INVALID_EMAIL_ADDRESS
RowKey/RowNo: 1
Fields: Email
Message: Primary Email: invalid email address: figuero@gmail.com&amp;gt;
--------------------------------------------------------------------------------
Status Code: INVALID_EMAIL_ADDRESS
RowKey/RowNo: 1
Fields: Email
Message: Primary Email: invalid email address: anna@well.com or anna.smith@aol.com
--------------------------------------------------------------------------------

Re: tSalesforceOutput - Error logging file

Anonymous — Thu, 14 Jul 2016 16:07:54 GMT

I'd recommend using tSalesforceOutputBulk and tSalesforceBulkExec