question

DasArjunCHVevey-0694 avatar image
0 Votes"
DasArjunCHVevey-0694 asked ·

ADF Pipeline activity staying longer in queue state

Hi..Earlier pipelines were running an average of 3min...Now same pipelineS and same data load taking hours to execute. I have tested procedures in SQL DB they are running fine. I think the issue might be with self-hosted IR. Please find the below IR's Report ID and check the logs.

lookup,stored procedure ,copyacitvty, log update procedure, procedures running for long time, also all these activity staying in queue for longer time then expected.


azure-data-factory
· 3
10 |1000 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 @dasarjunchvevey-0694,

Welcome to Microsoft Q&A forum and thanks for your query.

Could you please confirm what is the version of your SHIR? If it is not the latest version, could you please give a try upgrading it to latest version (5.3.7720.1) and see if that helps to resolve the issue? You can download the latest SHIR version from here: https://www.microsoft.com/en-us/download/details.aspx?id=39717

Also I wasn't able see the SHIR report ID in the original query, could you please share the SHIR report ID as well as the pipeline run ID which is having this issue?


We look forward to your response.

Thank you


0 Votes 0 ·

Hi @dasarjunchvevey-0694,

Following up to see if you have got a chance to see my previous comment, if so could you please confirm the details requested ?

Thank you

0 Votes 0 ·

Hi @dasarjunchvevey-0694,

We still have not heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thank you

0 Votes 0 ·

0 Answers