Error Message: The operation has timed out.
Action:
When retrieving data using one Salesforce Connection, the package execution succeeds. However if I try to use 3 or more simultaneous Salesforce connections, the following error message is received.
Error Message:
An error occurred with the following error message: "The operation has timed out".
Solution:
The returned error message is misleading. By default the .NET framework is configured to allow maximum of 2 simultaneous connections to the same web site. The default configuration can be modified, by including under the element in your DTExec.exe.config and DtsDebugHost.exe.config files:
<configuration>...<system.net><connectionManagement><addaddress="*"maxconnection="100"/></connectionManagement></system.net></configuration>The upper configuration will increase the limit to 100 simultaneous connections. Set this limit according to your needs. If you use 64bit system, you have to include the same setting in both "Program Files" and "Program Files (x86)" folders.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Error Message: The operation has timed out.
Action: When moving data into a SharePoint list using the SharePoint Destination component, the following error intermittently occurs. Error Message: The operation has timed out. Solution: Try increasing the timeout parameter in the Sharepoint ...Error Message: Salesforce Connection Manager: The operation has timed out.
Action: When manually executing SSIS+ package that includes Salesforce Connection Manager component I don't get any errors. But when I execute the package via SQL Server Agent I get the following error message: Error Message: The operation has timed ...Error Message: The underlying connection was closed: An unexpected error occurred on a send. (System.Web.Services)
Action: My Salesforce connections have suddenly started giving errors. Attached is the error message I am recieving on testing the connections . Please note the connections were working fine until yesterday and I am getting same issue for both ...Error Message: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
Action: We migrated our COZYROC connector to a new server. Since then we get a timeout when trying to retrieve a large table and the following error message. Error Message: 'Unable to read data from the transport connection: A connection attempt ...Error Message: An existing connection was forcibly closed by the remote host
Action When making a request to a service connection, the following error message was returned. Error Message Error Message: An existing connection was forcibly closed by the remote host Solution The error message can be somewhat generic across ...