topic SocketTimeoutException: Read timed out when exporting Salesforce Data in Talend Studio

SocketTimeoutException: Read timed out when exporting Salesforce Data

_AnonymousUser — Sat, 16 Nov 2024 12:24:28 GMT

Hello,
I have this problem when I try to run the Main job who contains other subjobs to export Salesforce data to Oracle database, it work fine if I run each subjob separately!
But unfortunately when i run the main job it doesn't seem to work! this link contains the error log : http://pastebin.com/3ngCqfBg
The Data we are trying to export from Salesforce to Oracle :
Tasks 374 783
Leads 217 555
Mouvements 31 086
Contacts 27 664
Accounts 25 256
Opportunities 22 288
Contracts 7 256
Thank you!

Re: SocketTimeoutException: Read timed out when exporting Salesforce Data

Anonymous — Mon, 06 Feb 2012 05:08:09 GMT

Hi
Do you have several tSalesforceInput components using the same account to connect to the server at the same time when you execute the master job?
Regards,
Pedro

Re: SocketTimeoutException: Read timed out when exporting Salesforce Data

_AnonymousUser — Mon, 06 Feb 2012 09:33:20 GMT

Hi Pedro, thank you for your response,
my Main job has one tSalesforceInput (to get a specific parameter from Salesforce) and for each Subjob I have an other tSalesforceInput and the subjobs are running successively (the link between each job is : onSubjobOk).
and if I run the Main Job with 1000 rows limit it works perfectly!
this a link to the screen shot of the main job : http://img843.imageshack.us/img843/2649/talend.png
Thank you in advance!

Re: SocketTimeoutException: Read timed out when exporting Salesforce Data

Anonymous — Mon, 06 Feb 2012 09:48:14 GMT

Hi
Do all tSalesforceInput components use the same username?
Have you tried to use tSalesforceConnection?
Regards,
Pedro

Re: SocketTimeoutException: Read timed out when exporting Salesforce Data

_AnonymousUser — Mon, 06 Feb 2012 10:22:41 GMT

yes all the tSalesforceInput use the same Salesforce account, and yes each subjob has his owen tSalesforceConnection.
best regards,