Azure Data Factory event storage trigger doesn't run when another pipeline upload new file

Juszcze, Krzysztof 6 Reputation points
2021-06-08T09:34:33.207+00:00

I'm using Azure Data Factory and I have a pipeline that creates a file in Blob Storage Account. Storage Account is StorageV2 (general purpose v2).

I have a second pipeline that is subscribing to Storage Event. When I'm adding the file to the specified container manually then trigger runs pipeline. However, when I run the first pipeline and the file is added to the blob automatically, the trigger doesn't run.

How can I resolve this problem? Maybe there is better solution for scenario like that.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
Azure Event Grid
Azure Event Grid
An Azure event routing service designed for high availability, consistent performance, and dynamic scale.
454 questions
{count} votes

6 answers

Sort by: Most helpful
  1. HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator
    2021-06-09T23:57:31.11+00:00

    Hello @Juszcze, Krzysztof
    Thanks for the ask and using the Microsoft Q&A platform .
    I did tried the setup and it works for me . Let me share my implementation and then you can compare with yours .

    103968-image.png

    This is the setup for the trigger

    103969-image.png

    In my case the trigger is firing as exptected .

    103897-image.png

    Please do let me know how it goes .
    Thanks
    Himanshu
    Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

    1 person found this answer helpful.
    0 comments No comments

  2. Juszcze, Krzysztof 6 Reputation points
    2021-06-17T07:17:17.76+00:00

    Hello @HimanshuSinha-msft .

    Yes, my trigger is listening the container test-trigger-sink and this is a container where I copy the data exactly.
    I've created a generic data set and it looks like that under the hood:
    106494-testtrigger-dataset.png

    This concatenate "test-trigger-" with "sink".

    106420-file-path.png

    And the copy activity works well, the file is added to the container:

    106350-uploaded-file.png

    I think it's a problem with the event storage trigger which is not run in my second pipeline when the file is upload by another pipeline.
    Above it's only a reproduced situation from my project solution where it's also doesn't work.
    It looks for me like a bug in ADF or there is some configuration that stopped fire the trigger if the file is upload by pipeline.

    1 person found this answer helpful.

  3. michael donahue 11 Reputation points
    2022-05-19T17:52:01.197+00:00

    I am having a similar issue. The trigger executes successfully when I manually upload a file to the storage account, however, when a file is uploaded to the storage account from using the ftp protocol the trigger is never prompted. I downloaded the file to my local, deleted the file from the storage account then manually uploaded the exact same file to the storage account and the trigger works fine. Very Disappointing. FWIW, I have confirmed the storage account is ADLS Gen2 and Hierarchical namespace is enabled.

    1 person found this answer helpful.

  4. Juszcze, Krzysztof 6 Reputation points
    2021-06-10T07:00:29.77+00:00

    Thanks, for the answer @HimanshuSinha-msft . However, your implementation doesn't reflect my situation. I'm talking about a situation when the file is added to a container by activity in Azure Data Factory (ex. Copy Activity).

    1. I've created a simple copy activity that uploads a file in the container 104113-copyactivity.png
    2. Next, I've created a storage event trigger 104065-triggerconfig.png
    3. Then, I've created a second activity that is listening to the trigger 104106-triggeredactivity.png
    4. I run the activity of point 1. and the file is created in the container but the trigger not run. When I upload a file from Azure Portal or Azure CLI to a container then the trigger runs the activity (from point 3).

  5. Vijay Gareepalli [External] 1 Reputation point
    2022-10-27T23:21:43.657+00:00

    specify file extension for the property "blob path ends with" like .csv or .txt.

    0 comments No comments

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.