ADF Pipeline activity staying longer in queue state

Das,Arjun,CH-Vevey 1

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.

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2021-03-02T06:31:51.433+00:00

Hi @Das,Arjun,CH-Vevey ,

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
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2021-03-03T06:13:14.427+00:00

Hi @Das,Arjun,CH-Vevey ,

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
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2021-03-04T19:37:22.32+00:00

Hi @Das,Arjun,CH-Vevey ,

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