Rerun and cancel of tumbling window trigger immediately get "Failed to rerun/cancel" message.

Konstantin-9879 21 Reputation points
2021-12-09T11:17:16.347+00:00

We have tumbling window trigger "A" and tumbling window trigger "B". "B" depends on "A". "A" get failed status because DB was inaccessible some minutes. Now DB is online and we try to invoke rerun of "A", but after rerun we immediately get "Failed to rerun. InternalServerError executing request." message, while other triggers (depended on same DB and failed too) rerun succcessfully. "B" has "Waiting on dependency" state and when we try to cancel it (and remove "A" dependency from "B" after), we immediately get "Failed to cancel" message.
What we can do in this situation? Recreate all dependency graf of all our data pipline from scratch is pain.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,118 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,081 questions
{count} votes