Too long "Queue" time using SAP ECC connector within Data Factory

Rubén Souto 6 Reputation points
2020-12-15T11:57:40.207+00:00

48346-image.png

Greetings:

It happens occasionally, "copy data" activity gets stucked in "Queue" state for a long time. I send an example.

What can I do to troubleshoot it? Is there a solution?

Thank you.

Regards.

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

1 answer

Sort by: Most helpful
  1. HarithaMaddi-MSFT 10,126 Reputation points
    2020-12-24T07:39:56.317+00:00

    Thanks @Rubén Souto for sharing the update. As per the document, when the processor and available RAM aren't well utilized, but the execution of concurrent jobs reaches a node's limits, scale up by increasing the number of concurrent jobs that a node can run. If the node capacity also exceeds i.e., when issue persists after increasing the limit, then scale-out approach as suggested i.e., to increase nodes is preferred.

    Looking forward for your update on the issue!