I cant connect to salesforce using ADF receiving error "name cannot be resolved"

Question

I cant connect to salesforce using ADF receiving error "name cannot be resolved"

Ahmed Nader 0

I have a data factory that I create with C# SDK including linked services, datasets and running the pipeline itself with its activities. The problem is when I start a pipeline run I receive the following error.

"

Operation on target copy for Customer failed: ErrorCode=SalesforceHttpRequestFailure,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Network exception in sending request to Salesforce. Error message: An error occurred while sending the request.,Source=Microsoft.DataTransfer.Runtime.SalesforceConnector,''Type=System.Net.Http.HttpRequestException,Message=An error occurred while sending the request.,Source=mscorlib,''Type=System.Net.WebException,Message=The remote name could not be resolved: 'microsoft.azure.management.datafactory.models.expression',Source=System,'

"

I provide for the pipeline run a parameter with the url of salesforce, and I am sure its correct, I searched all internet can't find a working solution for it.

Also I use the default azure integration runtime and I added the East US 2 IP ranges to the whitelist of IPs in salesforce.

appreciate your help.

Ahmed Nader 0 Reputation points

2023-04-27T15:47:19.5533333+00:00

is there anyone who can provide help on this issue ?!
KranthiPakala-MSFT 45,982 Reputation points Microsoft Employee

2023-04-28T23:10:52.15+00:00

@Ahmed Nader Thanks for using MS Q&A forum and posting your query.

Could you please confirm if you have verified that the test connection works fine and also were you able to preview the data after configuring the Salesforce dataset? Before triggering the pipeline, I recommend ensuring test connection and your were able to preview the data.

By looking at the error message it seems like a networking related issue. To narrow down the issue, I would recommend using a SHIR instead of Azure IR and whitelist SHIR IP to allow access to your Salesforce and once making sure that SHIR is able to establish the connection and able to preview the data, it confirms that the issue resides with Azure IR.

If Azure IR IP address is creating the issue, you may also give a try creating an Azure IR with managed Vnet enabled so that you will have specific IP address which you can use to whitelist in Salesforce and establish connection. The reason I would recommend trying this is that public Azure IR IP range keep on adding new IP address every week and may result in such issues in future hence would recommend to go for Azure IR in managed Vnet or you can also use SHIR.

Hope this info helps. Let us know how it goes.

Thank you
KranthiPakala-MSFT 45,982 Reputation points Microsoft Employee

2023-05-01T22:14:19.09+00:00

@Ahmed Nader Checking to see if the provided workaround was helpful. Do let us know if you have further questions.

Thank you

Ahmed Nader 0 Reputation points

2023-04-27T15:47:19.5533333+00:00

is there anyone who can provide help on this issue ?!
KranthiPakala-MSFT 45,982 Reputation points Microsoft Employee

2023-04-28T23:10:52.15+00:00

@Ahmed Nader Thanks for using MS Q&A forum and posting your query.

Could you please confirm if you have verified that the test connection works fine and also were you able to preview the data after configuring the Salesforce dataset? Before triggering the pipeline, I recommend ensuring test connection and your were able to preview the data.

By looking at the error message it seems like a networking related issue. To narrow down the issue, I would recommend using a SHIR instead of Azure IR and whitelist SHIR IP to allow access to your Salesforce and once making sure that SHIR is able to establish the connection and able to preview the data, it confirms that the issue resides with Azure IR.

If Azure IR IP address is creating the issue, you may also give a try creating an Azure IR with managed Vnet enabled so that you will have specific IP address which you can use to whitelist in Salesforce and establish connection. The reason I would recommend trying this is that public Azure IR IP range keep on adding new IP address every week and may result in such issues in future hence would recommend to go for Azure IR in managed Vnet or you can also use SHIR.

Hope this info helps. Let us know how it goes.

Thank you
KranthiPakala-MSFT 45,982 Reputation points Microsoft Employee

2023-05-01T22:14:19.09+00:00

@Ahmed Nader Checking to see if the provided workaround was helpful. Do let us know if you have further questions.

Thank you

I cant connect to salesforce using ADF receiving error "name cannot be resolved"

Activity