question

MiloGregor-9270 avatar image
0 Votes"
MiloGregor-9270 asked KranthiPakala-MSFT edited

Data Factory: Pipeline Copy activity stays in the "Queued" status

Hi
I have a problem with the Copy activity in Azure Data Factory. We have:
- ADF is in West Europe region
- copy activity that copies data from DB2 to Azure SQL (using simple SQL select)
- it is running on self-hosted integration runtime
- sample run ID is e1996019-3fea-4e69-9834-a30822eb8d2a

This week, when I start the pipeline the processing stops at the copy activity. Here It stays "forever" (I always cancel the pipeline after several hours) in the "Queued" status without any error message. When I try to "Preview data" via ADF interface, I can read the data. This problem has not been reported sometimes before this week.

How can I fix / debug this problem?





azure-data-factory
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.

1 Answer

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

Hi @milogregor-9270,

Welcome to Microosft Q&A forum and thanks for reaching out.

Since you mentioned that the issue started happening recently, I strongly suspect that it could be related to recent issue with SHIR as discussed in below two threads :

  1. Azure Data Factory Pipeline Activities Stuck In Queued status

  2. Data Factory activities stuck in Queued

81565-image.png

Could you please try updating your SHIR to latest version and see if the helps to resolve your issue. Here is the for downloading later IR version: Integration runtime download

81579-image.png

Let us know how it goes.

Thank you



Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.



image.png (72.9 KiB)
image.png (14.7 KiB)
· 5
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 @milogregor-9270,

Just checking in to see if the above suggestion was helpful. If this answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thanks

0 Votes 0 ·

Hi @KranthiPakala-MSFT

Yes, there is a problem with integration runtime. But for now it is not fixed, because customer have some problems with local firewall.

Thanks

0 Votes 0 ·

Hi @milogregor-9270,

Thanks for the update. Please feel free to open a new thread if it is not relevant to Integration Runtime upgrade issue.

0 Votes 0 ·
Show more comments