ADF pipeline stuck showing stored procedure activity in progress

Nehadevi Rajput 0 Reputation points

Pipeline stored procedure activity is in progress. Regularly its taking 57 Seconds to execute now its showing in progress for 4 hours

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

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,286 Reputation points Microsoft Employee

    Hi Nehadevi Rajput,

    Thank you for posting query in Microsoft Q&A Platform.

    Kindly check below and see if that helps.

    • Is any previous execution of pipeline is still progress? If yes, cancel that see.
    • Is any lock in database objects that making stored procedure to wait? Please check once.
    • Is that any compute or network related issues with database?

    Hope this helps. Please let me know how it goes.

    Please consider hitting Accept Answer button. Accepted answers help community as well.