Error when trying to copy from Salesforce to an Azure table using Data Factory

Question

Error when trying to copy from Salesforce to an Azure table using Data Factory

Hi,

I'm trying to copy a table from Salesforce using the Azure Data Factory connector and I'm receiving this error. I'm not using the token. I included the IP addresses in Salesforce's whitelist. Connection test passed.

ErrorCode=SalesforceOdbcPropertyInsufficientToRead,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Odbc properties insufficient to read: Invalid URI: The hostname could not be parsed.,Source=Microsoft.DataTransfer.Runtime.SalesforceConnector,'

Any idea what could be happening?

Thanks

HarithaMaddi-MSFT 10,081 Reputation points

2020-11-27T15:03:45.803+00:00

Hi @Adalberto García Espinosa ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

Please suggest if this document is referred and if issue persists by following all the steps as suggested, In order to investigate further, can you please share data factory name, region and pipeline run id that failed. If using SHIR, please share report id as below.

In the integration runtime configuration manager, please click on diagnostics icon, reproduce the error and then click on ‘Send logs’.

You will be able to see report id, please share that with us to enable viewing logs.

Looking forward for your response!
Adalberto García Espinosa 86 Reputation points

2020-11-27T18:56:50.297+00:00

PIPELINE: TEST_DE_ERROR
Pipeline run ID: 14ab19a9-d909-40e2-be5c-9273bdb9f8a8
Region: South Central US

The Integration Runtime is the Azure. I don't know how to access the configuration manager.
HarithaMaddi-MSFT 10,081 Reputation points

2020-11-30T06:15:11.653+00:00

Thanks @Adalberto García Espinosa for sharing the details. I will work with the product team and will get back to you as soon as I hear from them.

Thanks for your patience!

HarithaMaddi-MSFT 10,081 Reputation points

2020-11-27T15:03:45.803+00:00

Hi @Adalberto García Espinosa ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

Please suggest if this document is referred and if issue persists by following all the steps as suggested, In order to investigate further, can you please share data factory name, region and pipeline run id that failed. If using SHIR, please share report id as below.

In the integration runtime configuration manager, please click on diagnostics icon, reproduce the error and then click on ‘Send logs’.

You will be able to see report id, please share that with us to enable viewing logs.

Looking forward for your response!
Adalberto García Espinosa 86 Reputation points

2020-11-27T18:56:50.297+00:00

PIPELINE: TEST_DE_ERROR
Pipeline run ID: 14ab19a9-d909-40e2-be5c-9273bdb9f8a8
Region: South Central US

The Integration Runtime is the Azure. I don't know how to access the configuration manager.
HarithaMaddi-MSFT 10,081 Reputation points

2020-11-30T06:15:11.653+00:00

Thanks @Adalberto García Espinosa for sharing the details. I will work with the product team and will get back to you as soon as I hear from them.

Thanks for your patience!

Answer 1

HarithaMaddi-MSFT 10,081

Hi @Adalberto García Espinosa ,

I got an update from Product team that the value of "environmentUrl" property specified when creating Salesforce linked service is invalid. They can see from the logs that the exception indicating malformed URI was thrown. Please double check its validity by referencing this document.

Please let us know if it helps in resolving the issue.

-----

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
Want a reminder to come back and check responses? Here is how to subscribe to a notification.

HarithaMaddi-MSFT 10,081 Reputation points

2020-12-02T07:42:11.23+00:00

Hi @Adalberto García Espinosa ,

We have not received a response from you. Please suggest if above suggested approach is helpful. Otherwise, let us know and we will continue to engage with you on the query.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community member
Adalberto García Espinosa 86 Reputation points

2020-12-02T19:53:08.163+00:00

Thanks. It worked

Error when trying to copy from Salesforce to an Azure table using Data Factory

0 additional answers

Activity