Azure Data Factory pipeline stuck in queued status until forever

Question

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??

Answer 1

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

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

Answer 2

I having the same issue, how you solved?