question

MadhuBalan-1479 avatar image
0 Votes"
MadhuBalan-1479 asked KranthiPakala-MSFT commented

Copy activity failing while copying data from Salesforce to Azure Blob Storage

I'm trying to copy data from Salesforce service cloud to azure blob storage. It's a simple pipeline with only one copy activity. Datasets, Linked services, IR's are configured and test connection to Salesforce is successful. Preview data is also retrieving the expected data from the Salesforce Object.

But while running my pipeline with the copy activity which copies the data from Salesforce to Blob, the pipeline is failing with the error LOGIN_DURING_RESTRICTED_DOMAIN: cannot log in from current domain. It's bit surprising to see this error only when executing the pipeline and no where else. Please suggest if I'm missing anything here.

azure-data-factory
· 4
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 @MadhuBalan-1479,

Thanks for using Microsoft Q&A forum and posting your query.

To further analyze the issue could you please share below details:

  • Failed pipeline runID

  • Failed Activity runID

  • Integration runtime used on both source and sink?

  • Data factory region?

We look forward to your response.

Thanks







0 Votes 0 ·

Hi @KranthiPakala-MSFT, I am also experiencing the same error when running a copy activity from Salesforce to ADLS v2.

I am currently using Azure IR East US, the ADF is also East US.

I believe that the ADF IPs were added to Salesforce and I am able to test the connectivity to Salesforce fine with ADF.

I am currently running a foreach loop to lookup each Salesforce table and copy each table into ADLS.

However, the copy activity is running successfully for some runs and failing for some runs. The failures are not for a specific failure as each run of the pipeline will make random numbers of table to fail.

I am not sure if I am able to provide you the pipeline or activity IDs because this is for an external customer.

Please assist as this is urgent

0 Votes 0 ·

Hi @jackchen-3037,

Thanks for reaching out. As your issue is not consistent and happening randomly, I would highly recommend you to please file a support ticket and provide as much as information possible along with the failure error messages, so that a support engineer can take a deeper look into the issue. In case if you don't have a support plan please do let us know here.

Thank you

0 Votes 0 ·

Hi @MadhuBalan-1479,

We still have not heard back from you. Just wanted to check if you are still facing the issue or need assistance on this? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

0 Votes 0 ·

0 Answers