question

AdalbertoGarcaEspinosa-7187 avatar image
0 Votes"
AdalbertoGarcaEspinosa-7187 asked AdalbertoGarcaEspinosa-7187 commented

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

azure-data-factory
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AdalbertoGarcaEspinosa-7187,

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.

43373-image.png

Looking forward for your response!


0 Votes 0 ·
image.png (132.5 KiB)

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.

1 Vote 1 ·
HarithaMaddi-MSFT avatar image HarithaMaddi-MSFT AdalbertoGarcaEspinosa-7187 ·

Thanks @AdalbertoGarcaEspinosa-7187 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!

0 Votes 0 ·

1 Answer

HarithaMaddi-MSFT avatar image
0 Votes"
HarithaMaddi-MSFT answered AdalbertoGarcaEspinosa-7187 commented

Hi @AdalbertoGarcaEspinosa-7187,

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.



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AdalbertoGarcaEspinosa-7187,

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

0 Votes 0 ·