ADF : Operation on target XYZ_Trigger failed: Concurrent operations on a trigger are not allowed. trigger

Question

Hello Team,

While doing deployment through DevOps CICD pipeline we getting below error.
Error Message: Operation on target XYZ_Trigger failed: Concurrent operations on a trigger are not allowed. trigger: XYZ_Trigger

[error]HTTP Status Code: BadRequest

Note: This trigger is Event based trigger and it is in start mode. We made changes to other pipelines but getting issue for this trigger.

Please suggest to resolve this issue.

Answer 1

Krishna Tapse ,

Welcome to Microsoft Q&A platform and thanks for posting your query here.

The error message "Concurrent operations on a trigger are not allowed" indicates that there are multiple operations being performed on the same trigger at the same time, which is not allowed.

Deployment can fail if you try to deploy active triggers. To deploy the triggers, you need to stop them before deployment and then restart them after the deployment.

You can use powershell script to toggle the trigger during deployment .

For more details, kindly check these resources:
https://learn.microsoft.com/en-us/powershell/module/az.datafactory/stop-azdatafactoryv2triggerrun?view=azps-11.5.0

https://learn.microsoft.com/en-us/powershell/module/az.datafactory/start-azdatafactoryv2trigger?view=azps-11.5.0

https://microsoft-bitools.blogspot.com/2024/01/toggle-azure-synapse-triggers-during.html#:~:text=To%20turn%20of%20the%20Synapse,mainly%20use%20YAML%20for%20pipelines.

https://learn.microsoft.com/en-us/azure/data-factory/continuous-integration-delivery#best-practices-for-cicd

Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou