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

Question

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

Buchaiah B 101

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

0 comments

Answer accepted by question author

Buchaiah B 101

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

ShaikMaheer-MSFT 38,631 Reputation points Microsoft Employee Moderator

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,221 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,221 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 :-)

1 additional answer

Your answer

ShaikMaheer-MSFT 38,631 Reputation points Microsoft Employee Moderator

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,221 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,221 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 :-)

Answer 1

Ronen Ariely 15,221

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

0 comments

Share via

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

1 additional answer

Your answer