Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.
Labels (4)
2 Replies
Anonymous
Not applicable
Author

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
TRF
Champion II
Champion II

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