Share via

ADF pipeline stuck showing stored procedure activity in progress

Nehadevi Rajput 5 Reputation points
2023-04-14T11:31:45.9666667+00:00

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.
11,600 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
    2023-04-17T16:07:32.0166667+00:00

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.