question

JunYan-9122 avatar image
0 Votes"
JunYan-9122 asked KranthiPakala-MSFT commented

Copy data timeout after long queuing time

We randomly see copy data activity being queued until it reaches the timeout threshold, retry doesn't help. Does anybody know what could cause it, how to avoid?

83740-image.png


azure-data-factory
image.png (9.3 KiB)
· 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.

Thanks @KranthiPakala-MSFT. I need more instructions... How do I check if there is concurrency policy? I also checked the activity property, and I don't see any concurrency related setting. I am not sure if I am looking at the right place.

83866-image.png


0 Votes 0 ·
image.png (28.5 KiB)

Hi @junyan-9122,

Sorry for the delay in response. You can find the Concurrency property under General tab of your pipeline

84646-image.png

Also please confirm what version of SHIR is being used? Also providing queued pipeline runID as well as the activity runID would help us to take a deeper look into the issue.

Thanks

0 Votes 0 ·
image.png (45.5 KiB)

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @junyan-9122,

Welcome to Microsoft Q&A forum and thanks for your query.

This can happen for various reasons like hitting concurrency limits, service outages, network failures and so on.

For possible resolution details, please refer to this doc and see if that helps: Pipeline status is queued or stuck for a long time

83789-image.png

If it doesn't help, please do let us know what is Integration time being used on both source and Sink? If SHIR what is the version? Also please do share the queued pipeline runID so that we can double check with product team.

Let us know how it goes.

Thanks


image.png (47.6 KiB)
· 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.

Hi there,

As per the offline conversation with @JunYan-9122, this was one time issue and haven't seen this issue lately. Assuming that the issue could be related to Azure IR infrastructure.
Here is a troubleshooting document for copy activity performance, which would help to self analyze and mitigate such issue: Performance tuning tips


0 Votes 0 ·