Can't cancel a trigger waiting on dependency in azure-synapse-analytics

Meng Zhang 31 Microsoft Employee

The trigger is waiting on dependency with 0 pipelines, and the dependent trigger is succeeded.
When I tried to cancel it, it failed with no error message. How can I cancel it?

BhargavaGunnam-MSFT 26,496 Reputation points Microsoft Employee

2022-11-30T21:19:00.95+00:00

Hello @Meng Zhang ,

Welcome to the MS Q&A platform.

Are you using the tumbling window trigger with dependency?

Do you mean unable to stop the trigger or unable to cancel the pipeline run?

Could you please provide us with more details here?
BhargavaGunnam-MSFT 26,496 Reputation points Microsoft Employee

2022-12-03T01:29:12.63+00:00

Hello @Meng Zhang ,
I am checking to see if you got a chance to look into my above response.
Meng Zhang 31 Reputation points Microsoft Employee

2022-12-08T08:37:28.407+00:00
Hi @BhargavaGunnam-MSFT ,

Sorry for the late response.

Yes. The trigger is tumbling window trigger with dependency.

I want to cancel a trigger, but unable to do it. The trigger may rely on the triggers succeed, waiting on dependency or running,

Can you provide advice on how to fix it?

Here are some samples:
BhargavaGunnam-MSFT 26,496 Reputation points Microsoft Employee

2022-12-09T19:17:51.213+00:00

Hello @Meng Zhang ,

Thank you for the reply.

It seems the order you are trying to cancel for each downstream trigger is incorrect. You will need to check which one should be canceled first.

You can look at the trigger run waiting on dependencies to see the windows it depends on.

I hope this helps. Please let me know if you still have trouble canceling the 'waiting on dependency' triggers.

https://techcommunity.microsoft.com/t5/azure-data-factory-blog/cancel-and-rerun-tumbling-window-trigger-run/ba-p/1815699

1 answer

BhargavaGunnam-MSFT 26,496 Reputation points Microsoft Employee

2022-12-09T19:19:10.15+00:00

Hello @Meng Zhang ,

Thank you for the reply.

It seems the order you are trying to cancel for each downstream trigger is incorrect. You will need to check which one should be canceled first.

You can look at the trigger run waiting on dependencies to see the windows it depends on.

I hope this helps. Please let me know if you still have trouble canceling the 'waiting on dependency' triggers.

https://techcommunity.microsoft.com/t5/azure-data-factory-blog/cancel-and-rerun-tumbling-window-trigger-run/ba-p/1815699
Please sign in to rate this answer.
Meng Zhang 31 Reputation points Microsoft Employee

2022-12-12T07:22:58.377+00:00

Hi @BhargavaGunnam-MSFT ,

Thanks for your advice. But it still fails whatever I cancel EmailNotification_Trigger or Rule_DataFilter_DailyInfo_Trigger. What can I do now?

EmailNotification_Trigger:

Rule_DataFilter_DailyInfo_Trigger

BhargavaGunnam-MSFT 26,496 Reputation points Microsoft Employee

2022-12-12T14:53:03.33+00:00

Hello @Meng Zhang ,

Please correct me if my understanding is wrong. You tried to cancel the trigger that was stuck in "Waiting on dependency." in the order, but you still can't able to cancel them.

I am sure that the order must be causing the issue. If you still cannot able to cancel them in the order, I suggest opening a support case. So that the support engineer can help cancel the trigger from the backend; please let me know if you have any further questions.

Meng Zhang 31 Reputation points Microsoft Employee

2022-12-13T06:32:31.533+00:00

Hi @BhargavaGunnam-MSFT ,

You're right. I think I need support now. But how to open a support case?

BhargavaGunnam-MSFT 26,496 Reputation points Microsoft Employee

2022-12-13T16:29:19.697+00:00

Hello @Meng Zhang ,
Thank you. Please follow the below document to submit the support case. In case if you need any further assistance, please let me know.

https://learn.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request

BhargavaGunnam-MSFT 26,496 Reputation points Microsoft Employee

2022-12-14T22:25:29.353+00:00

Hello @Meng Zhang ,
I am checking to see if you need any further help here.
Sign in to comment