ADF's File Exists Trigger does reads the files but doesn't fire off Switch activity in pipeline, any idea?

WarrenL 20 Reputation points
2023-03-27T17:02:25.2033333+00:00

So our ADF V2 File exists trigger we setup was able read the input files but doesn't fire off the linked Switch activity. Specifically, in our case, it correctly read the file "Mashgin_Order_Items_20221001.csv" from the Azure Blob storage (StorageV2) but doesn't take the next step in processing it by call the Switch activity as we expecting it to. Any idea on how to troubleshoot that? It eventually timeout after the 2 hr wait window we set. Below is a snippet of the JSON for the Switch.

User's image

User's image

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

Accepted answer
  1. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2023-03-28T09:45:21.36+00:00

    Hi WarrenL,

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

    It seems your pipeline execution is not coming out of until activity. Until Activity executes a set of activities in a loop until the condition associated with the activity evaluates to true. If an inner activity fails, the Until activity does not stop. You can specify a timeout value for the until activity.
    So kindly make sure the condition inside until activity gets true once you find your file. So that it breaks loop there and move execution to Switch Activity.

    Click here to know more about Until Activity.

    Hope this helps. Please let me know if any further queries.


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

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful