Azure Data Factory Copy Activity is stuck in "Queued" status

andrucha 1 Reputation point
2020-10-29T14:54:49.107+00:00

Hello,

last week i have created simple Copy Activity data Pipeline to move data from On Premise SQL to Azure SQL. Everything worked fine and took between 10 and 20 seconds to execute. Unfortunately this week when i execute pipeline, status is shown as "In Progress". When i go inside, copy activity is stuck as "Queued". And it never gets executed (at least after 17 hours i canceled it xD). I have tried multiple times to execute it, but the same thing again. I also created one more pipeline with Copy Activity UI but the same result :/ I use SHIR for both source and destination linked services. Connection to both services is successful.

Location: westeurope. Pipeline activity run id: 75c15d8c-f252-4796-b354-8eea8598090b

What do you think could be a problem and how can i avoid it in the future? Tell me please if you need more information.

Thanks in advance!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,539 questions
{count} votes

1 answer

Sort by: Most helpful
  1. andrucha 1 Reputation point
    2020-10-30T11:41:19.077+00:00

    Hello,

    i wanted to give you an update. For now we have solved the issue. Our networking team needed to update some URL in network configuration for SHIR and some certificates in SHIR. But why it has worked earlier and this week we had an issue, stays unknown.

    Nevertheless thank you for your response. If we will have the issue in the future, i will inform you.

    Best regards


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.