Talend job was failed to load data from SQL to Salesforce on randomly

Anonymous — Sat, 16 Nov 2024 09:56:18 GMT

Hi All,
Need your help in fixing the issue, we have scheduled a job in talend to transfer data from sql to salesforce.com.
On different permutations, data was loading.
example notifiaction mail : on 2017/04/04
Integration import started time: 2017-04-04 03:00:01
Integration import completed time: 2017-04-04 04:38:13
Integration import duration: 5891 seconds 434 milliseconds
During integration process, have system error happen. Please review LogCatcher_040417030002.csv file in attachment for detail.
Populating Account data from ODS database is Success
Total successful imported Accounts: 117376
Total failed imported Accounts: 0
Sending the job status of Account back to ODS database is Success
Populating Policy Motor data from ODS database is Success
Total successful imported Policy Motors: 0
Total failed imported Policy Motors: 0
Sending the job status of Policy Motor back to ODS database is Success
Populating Policy Health data from ODS database is Success
Total successful imported Policies Health: 1130
Total failed imported Policies Health: 0
Sending the job status of Policy Health back to ODS database is Success
Populating Policy Other data from ODS database is Success
Total successful imported Policies Other: 229
Total failed imported Policies Other: 0
Sending the job status of Policy Other back to ODS database is Success
Populating Policy-Member data from ODS database is Success
Total successful imported Policy-Members: 123
Total failed imported Policy-Members: 0
Sending the job status of Policy-Member back to ODS database is Success
Populating Policy Addon data from ODS database is Success
Total successful imported Policy Addon: 0
Total failed imported Policy Addon: 32635
Sending the job status of Policy Addon back to ODS database is Success
Populating Claim Motor data from ODS database is Success
Total successful imported Claim Motors: 0
Total failed imported Claim Motors: 12094
Sending the job status of Claim Motor back to ODS database is Success
Populating Claim Health data from ODS database is Success
Total successful imported Claim Health: 83
Total failed imported Claim Health: 0
Sending the job status of Claim Health back to ODS database is Success
Populating Claim Other data from ODS database is Success
Total successful imported Claim Other: 8
Total failed imported Claim Other: 0
Sending the job status of Claim Other back to ODS database is Success
example notifiaction mail : on 2017/04/03
Integration import started time: 2017-04-03 03:00:01
Integration import completed time: 2017-04-03 04:08:58
Integration import duration: 4136 seconds 774 milliseconds
During integration process, have system error happen. Please review LogCatcher_030417030001.csv file in attachment for detail.

Populating Account data from ODS database is Success
Total successful imported Accounts: 110381
Total failed imported Accounts: 0
Sending the job status of Account back to ODS database is Success

Populating Policy Motor data from ODS database is Success
Total successful imported Policy Motors: 130800
Total failed imported Policy Motors: 2
Sending the job status of Policy Motor back to ODS database is Success

Populating Policy Health data from ODS database is Success
Total successful imported Policies Health: 1236
Total failed imported Policies Health: 0
Sending the job status of Policy Health back to ODS database is Success

Populating Policy Other data from ODS database is Success
Total successful imported Policies Other: 214
Total failed imported Policies Other: 0
Sending the job status of Policy Other back to ODS database is Success

Populating Policy-Member data from ODS database is Success
Total successful imported Policy-Members: 0
Total failed imported Policy-Members: 0
Sending the job status of Policy-Member back to ODS database is

We have 9 objects which are mapped to get the data from sql. Please provide your suggestions to get it resolved on priority.
Thanks for your help in advance.

Re: Talend job was failed to load data from SQL to Salesforce on randomly

Anonymous — Wed, 05 Apr 2017 08:27:32 GMT

Hi,
Could you please indicate what's talend build version you are using?
The attachment you provided is not available on forum. Could you please take a look at it?
Best regards
Sabrina

Re: Talend job was failed to load data from SQL to Salesforce on randomly

TRF — Wed, 05 Apr 2017 09:14:55 GMT

Hi,
Not enough information to help you.
Share your log files (LogCatcher_xxxxxxxxxxxxx.csv), any information about the errors and details about the job.
Regards,
TRF

topic Re: Talend job was failed to load data from SQL to Salesforce on randomly in Talend Studio

Talend job was failed to load data from SQL to Salesforce on randomly

Re: Talend job was failed to load data from SQL to Salesforce on randomly

Re: Talend job was failed to load data from SQL to Salesforce on randomly