Error Message: Invalid Server Host (Salesforce Connection)
When using the Salesforce Connection I am getting the error message below:
"Invalid Server Host"
Salesforce has sent out notices to their customers that some Salesforce Platform API legacy versions will be deprecated and no longer supported by Salesforce. As a result the COZYROC Salesforce Connection can no longer be used in versions prior to 1.6 SR-4. This could be the reason for the error message you are seeing. Please see the following link for more information from Salesforce: https://help.salesforce.com/s/articleView?id=000354473&type=1
As well on the COZYROC side, you can look at the "What's New" section in the Salesforce Connection documentation to determine what the highest version of Salesforce SOAP API that can be used for each version of COZYROC SSIS+.
You would need to designate a non deprecated version of the Salesforce Soap API at the end of the Server URL on the Advanced tab of the COZYROC Salesforce Connection as shown in the example here in this screen capture.
Book a Presales Call
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: "Invalid ..." or "Invalid Server Host"
Action: While dynamically changing a connection at run-time using expressions and variables in a ForEach Loop, the following error message is encountered. Error Message: "Invalid ..." Example: "Invalid server host". When using an expression and a ...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: unable to connect to remote server
Action: When I run my SSIS+ package for transferring data from Salesforce Source to Salesforce Destination I get the following error message: Error Message: Unable to connect to remote server Solution: The reason for ...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 ...