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

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

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.
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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