Hi Getting the below error when am trying to publish pipelines and tumbling triggers in Synapse analytics. Any pointers will be helpful. Error Notifications Error code: OK Inner error code: TumblingWindowTriggerStartTimeUpdateNotAllowed Message: Start time cannot be updated for Tumbling Window Trigger.null

Hi @Ronen Ariely , Thank you but those MS doc has steps for creating not the steps for creating but not for publishing. This issue got resolved now by deleting the trigger --> Publish --> Create new trigger --> Publish

Please follow the steps in this document: https://learn.microsoft.com/en-us/azure/data-factory/how-to-create-tumbling-window-trigger?tabs=synapse-analytics

Synapse analytics Start time cannot be updated for Tumbling Window Trigger.null

Accepted answer

Buchaiah B 101 Reputation points

2021-10-04T08:46:30.65+00:00

Hi @Ronen Ariely ,

Thank you but those MS doc has steps for creating not the steps for creating but not for publishing. This issue got resolved now by deleting the trigger --> Publish --> Create new trigger --> Publish
Please sign in to rate this answer.
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2021-10-04T10:05:46.237+00:00

Hi @Buchaiah B ,

Thank you for sharing your work around. Could you please mark it as accepted answer? Accepted answers helps community as well. Thank you.

Ronen Ariely 15,096 Reputation points

2021-10-04T16:48:45.06+00:00

You are most welcome and I am glad to hear to that solve the issue :-)

You can mark your last answer as the answer to the issue in order to close the thread

Buchaiah B 101 Reputation points

2021-10-04T18:23:22.283+00:00

Hi @Ronen Ariely ,

The solution was not there in the Microsoft URL that you gave.

But I resolved that using the below steps

DELETE Trigger --> PUBLISH Trigger --> CREATE Trigger --> PUBLISH Trigger.

I am just mentioning that so that if anyone refers to this thread for a solution then they don't have to go through that URL.

Thank you.

Ronen Ariely 15,096 Reputation points

2021-10-04T18:41:11.953+00:00

The solution was not there in the Microsoft URL that you gave.

I understood this, which why I asked you to mark your own response as answer and not my messages :-)
Sign in to comment

Synapse analytics Start time cannot be updated for Tumbling Window Trigger.null

1 additional answer