Azure Data Factory pipeline stuck in queued status until forever

Matthias Delafontaine 16 Reputation points
2022-10-25T09:24:36+00:00

I have an Azure Data Factory pipeline stuck in queued status for almost 10 hours now: it won't start the first activity (stored procedure).
It is the only pipeline running at this time and is not being blocked by concurrency limits.
No service health issues to be found. What are we doing wrong??

253828-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,933 questions
0 comments No comments
{count} vote

2 answers

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,432 Reputation points Microsoft Employee
    2022-10-26T00:37:28.783+00:00

    Hello @Matthias Delafontaine ,

    Thanks for the question and using MS Q&A platform.

    The root cause of this issue is broader and could be any of the following scenarios resulted in it. Please refer to below doc and see if you would be able to troubleshoot further, incase if it doesn't help, would recommend filing a support ticket for deeper investigation and incase if you don't have a support plan please let me know here.

    Related doc: Troubleshoot - Pipeline status is queued or stuck for a long time

    254086-image.png

    In case if you are using SHIR is your activity, then I would recommend changing it to Azure IR and see if that makes a difference. Please also troubleshoot SHIR logs and see if you can find any leads.

    Let us know how it goes.

    Thanks


  2. Antônio Farias 40 Reputation points
    2024-05-01T13:51:21.2+00:00

    I having the same issue, how you solved?

    0 comments No comments