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 Production and test sandbox.
Error Message:
The underlying connection was closed: An unexpected error occurred on a send. (System.Web.Services)Additional information: 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. (System)
Solutions:
This error message is most likely caused by an internal firewall and/or change in network policy.More Information: SOAP API request - TLS Fingerprint Detection was considered by Security team as a threat and was blocked at the firewall layer ( Requests should be white listed ) .
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: 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 ...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 ...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: MALFORMED_QUERY: unexpected token: True
Action: While using the Salesforce Source, the following error message was returned. Error Message: 'MALFORMED_QUERY: unexpected token: True' Solution: MALFORMED_QUERY is a dead giveaway that the query sent to Salesforce was not in proper syntax. ...Error Message: Invalid Server Host (Salesforce Connection)
Action: When using the Salesforce Connection I am getting the error message below: Error Message: "Invalid Server Host" Solution: Salesforce has sent out notices to their customers that some Salesforce Platform API legacy versions will be deprecated ...