Saleforce Timeout

gra...@eviltwin.me

unread,

Feb 24, 2016, 12:45:52 PM2/24/16

to COZYROC

Hi,

we are experiencing intermittent timeouts to SalesForce using the CozyRoc SSIS plugin, it gives the following error:

Message
SFDC Source failed the pre-execute phase and returned error code 0x80131509.

System.Net.WebException: The operation has timed out at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request) at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at CozyRoc.Sforce.Service.SforceService.queryAll(String queryString) at CozyRoc.SqlServer.SSIS.SforceSource.PreExecute() at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)

Is it simply timing out, we send all our salesforce requests serially.

Anyone else get his problem?

Kind regard, Graham.

Ivan Peev

unread,

Feb 24, 2016, 12:48:43 PM2/24/16

to COZYROC

Hi Graham,

Increase the Timeout parameter in the Salesforce connection manager and/or decrease the BatchSize parameter in the Salesforce Source component.

Bigyan Shrestha

unread,

Sep 29, 2023, 6:35:22 PM9/29/23

to COZYROC

Hi Ivan,

I do have similar issues. When I run from VS it runs successfully, but when I run from SQL Job agent, it fails with timeout error. Any idea?

Reply all

Reply to author

Forward