CODEWITHSUNDEEP
azure-data-factory
Magnus Johannesson
Magnus Johannesson

Reputation: 432

Copy activity queued for a long time

I have a pipeline with a Copy activity which copies data from a folder in ADLS Gen2 with Parquet files to a table in Azure SQL Database. Sometimes the Copy activity is in status Queued for several minutes before the actual copy of data occurs and then succeeds. The Copy activity has a pre-copy script setting for the Sink that truncates the table before copying the data. Why is the Copy activity queued for a long time before copying the data? Can it be due to some lock in the database, i.e. that some query is reading from the table?

Upvotes: 2

Views: 6406

Answers (1)

Kranthi Pakala
Kranthi Pakala

Reputation: 1422

Below is similar issue with Azure IR, after looking at the logs internally, it is addressed as an issue occurred due to ADF related service outage in West Europe. Internal team has confirmed that the issue has been resolved.

Could you please re-run the pipeline and let us know if you still notice the issue.

Related MSDN case: copy activities on Azure IR has long queue wait times

Upvotes: 1

Related Questions