question

PrashantSingh-1638 avatar image
0 Votes"
PrashantSingh-1638 asked HimanshuSinha-MSFT commented

Azure Data Factory - Copy activity from Data Lake to Synapse staying in Queued status

Hi,

We have an Azure Data Factory pipeline to copy data from Azure Data Lake to Synapse Table. The copy command is continuously getting stuck in the"Queued" status. This pipeline is using AutoResolve Azure Integration runtime in East US. Everything was working fine still this Saturday 9th Oct 21, and suddenly from Sun 10th Oct 21, all our production loads are now stuck as the status is not moving out from "Queued". We have tried all combination but not sure of the issue since we are not able to see any log while the status is "Queued".

Any help will be appreciated to understand the issue.

Regards
Prashant

azure-data-factoryazure-synapse-analyticsazure-data-lake-storage
· 1
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.

Hello @PrashantSingh-1638 ,
Since it was woirking fine before and not working as expected now , I think if you have a support plan you may file a support ticket, else could you please send an email to azcommunity@microsoft.com with the below details, so that we can create a one-time-free support ticket for you to work closely on this matter.
Subscription ID:
Subject : Attn Himanshu
Please let me know once you have done the same.

Thanks
Himanshu

0 Votes 0 ·

1 Answer

PrashantSingh-1638 avatar image
0 Votes"
PrashantSingh-1638 answered HimanshuSinha-MSFT commented

Hi Himanshu,

Thanks for your reply. We have raised a support ticket and got a response that there was some internal issue with the integration runtime and they suggested to create a new Integration runtime which then worked fine. Finally seems there was a problem with internal integration runtime which was not kicking off the copy activity. We are awaiting a root cause now to understand the issue and see how we can avoid in future.

Regards
Prashant

· 1
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.

Thanks @PrashantSingh-1638 ,
Can you please share SR# please ?
Thanks
Himanshu

0 Votes 0 ·