Hello all,

This may seem an easy topic but I still have my doubts. My part of the world is Western Europe and we use CET, which is now UTC + 1 hour. Next Sunday, we jump to DST and it will be UTC + 2 hours.

I am asking myself the question whether we need to update chores given this change in timings.

What you actually require is that a chore, running now at 6 AM LOCAL time, remains at 6 AM local time in DST.

PAW and Architect have different settings, where Architect allows the choice of Local or UTC. PAW does not offer a choice.

What is strange: when I create 2 new chores in Architect and set them to 6 AM, one with Local, one with UTC, they show the same when refreshed in PAW !

Does anyone have a clear and correct guide on this ? What to do, if anything ? What to do end of October when leaving DST and going back to normal ?

Create the chore in PAW (with no choice), or create in Architect (then, how ?). Creating a chore in the NEW (DST) time on Sunday morning to force them in the, then active, timing ?

Many thanks,

Wim

------------------------------
Wim Gielis
------------------------------

Hello,

Through an IBM support ticket, my gut feeling was confirmed. Chores run on UTC, not local time.

This has implications for potentially all chores and the upcoming Easter weekend we might face issues. A warned man counts as two.

No willingness at IBM to change this behaviour. An idea was loaded 3 years ago, it's not under consideration and we need to use IBM Cognos Command Center.

Best regards,

Wim

Hello all,

This may seem an easy topic but I still have my doubts. My part of the world is Western Europe and we use CET, which is now UTC + 1 hour. Next Sunday, we jump to DST and it will be UTC + 2 hours.

I am asking myself the question whether we need to update chores given this change in timings.

What you actually require is that a chore, running now at 6 AM LOCAL time, remains at 6 AM local time in DST.

PAW and Architect have different settings, where Architect allows the choice of Local or UTC. PAW does not offer a choice.

What is strange: when I create 2 new chores in Architect and set them to 6 AM, one with Local, one with UTC, they show the same when refreshed in PAW !

Does anyone have a clear and correct guide on this ? What to do, if anything ? What to do end of October when leaving DST and going back to normal ?

Create the chore in PAW (with no choice), or create in Architect (then, how ?). Creating a chore in the NEW (DST) time on Sunday morning to force them in the, then active, timing ?

Many thanks,

Wim

------------------------------
Wim Gielis
------------------------------

Hoi Wim,

Realize we just hit 24 hours before we change to DST but TM1 does support what you are asking for. It is correct that TM1 has always stored the start time in UTC (to be independent of local system settings) but at the same time has a DSTSensitive property/flag which, when set to true, will cause the start time to be offset accordingly and as such result in the start time remaining the same in local time.

If PA doesn't allow you to set this property/flag (which they should add/fix) than I'd quickly download Arc from our friends at Cubewise and use it to check that Daylight Savings Sensitive check-box there. Obviously you can also quickly PATCH the chore using the REST API and pass `{"DSTSensitive": true}`as the payload as well.

Happy Easter!

------------------------------
Hubert Heijkers
STSM, Program Director TM1 Functional Database Technology and OData Evangelist

Original Message:
Sent: Wed March 27, 2024 08:38 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello,

Through an IBM support ticket, my gut feeling was confirmed. Chores run on UTC, not local time.

This has implications for potentially all chores and the upcoming Easter weekend we might face issues. A warned man counts as two.

No willingness at IBM to change this behaviour. An idea was loaded 3 years ago, it's not under consideration and we need to use IBM Cognos Command Center.

Best regards,

Wim

------------------------------
Wim Gielis

Original Message:
Sent: Mon March 25, 2024 06:53 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello all,

This may seem an easy topic but I still have my doubts. My part of the world is Western Europe and we use CET, which is now UTC + 1 hour. Next Sunday, we jump to DST and it will be UTC + 2 hours.

I am asking myself the question whether we need to update chores given this change in timings.

What you actually require is that a chore, running now at 6 AM LOCAL time, remains at 6 AM local time in DST.

PAW and Architect have different settings, where Architect allows the choice of Local or UTC. PAW does not offer a choice.

What is strange: when I create 2 new chores in Architect and set them to 6 AM, one with Local, one with UTC, they show the same when refreshed in PAW !

Does anyone have a clear and correct guide on this ? What to do, if anything ? What to do end of October when leaving DST and going back to normal ?

Create the chore in PAW (with no choice), or create in Architect (then, how ?). Creating a chore in the NEW (DST) time on Sunday morning to force them in the, then active, timing ?

Many thanks,

Wim

------------------------------
Wim Gielis
------------------------------

Thanks Hubert. With this REST API call I was able to PATCH the chores, so all good.

I agree, that checkbox in the interface would be useful. Including a multi-select of more than 1 chore and applying the action of, in this case, the DST sensitivity.

------------------------------
Wim Gielis

Original Message:
Sent: Fri March 29, 2024 09:18 PM
From: Hubert Heijkers
Subject: Chores and Daylight Savings Time (DST)

Hoi Wim,

Realize we just hit 24 hours before we change to DST but TM1 does support what you are asking for. It is correct that TM1 has always stored the start time in UTC (to be independent of local system settings) but at the same time has a DSTSensitive property/flag which, when set to true, will cause the start time to be offset accordingly and as such result in the start time remaining the same in local time.

If PA doesn't allow you to set this property/flag (which they should add/fix) than I'd quickly download Arc from our friends at Cubewise and use it to check that Daylight Savings Sensitive check-box there. Obviously you can also quickly PATCH the chore using the REST API and pass `{"DSTSensitive": true}`as the payload as well.

Happy Easter!

------------------------------
Hubert Heijkers
STSM, Program Director TM1 Functional Database Technology and OData Evangelist

Original Message:
Sent: Wed March 27, 2024 08:38 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello,

Through an IBM support ticket, my gut feeling was confirmed. Chores run on UTC, not local time.

This has implications for potentially all chores and the upcoming Easter weekend we might face issues. A warned man counts as two.

No willingness at IBM to change this behaviour. An idea was loaded 3 years ago, it's not under consideration and we need to use IBM Cognos Command Center.

Best regards,

Wim

------------------------------
Wim Gielis

Original Message:
Sent: Mon March 25, 2024 06:53 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello all,

This may seem an easy topic but I still have my doubts. My part of the world is Western Europe and we use CET, which is now UTC + 1 hour. Next Sunday, we jump to DST and it will be UTC + 2 hours.

I am asking myself the question whether we need to update chores given this change in timings.

What you actually require is that a chore, running now at 6 AM LOCAL time, remains at 6 AM local time in DST.

PAW and Architect have different settings, where Architect allows the choice of Local or UTC. PAW does not offer a choice.

What is strange: when I create 2 new chores in Architect and set them to 6 AM, one with Local, one with UTC, they show the same when refreshed in PAW !

Does anyone have a clear and correct guide on this ? What to do, if anything ? What to do end of October when leaving DST and going back to normal ?

Create the chore in PAW (with no choice), or create in Architect (then, how ?). Creating a chore in the NEW (DST) time on Sunday morning to force them in the, then active, timing ?

Many thanks,

Wim

------------------------------
Wim Gielis
------------------------------

Thank you for the ask/info,

We'd add the option to select DST to the Workbench,

Best regards,

Thanks Hubert. With this REST API call I was able to PATCH the chores, so all good.

I agree, that checkbox in the interface would be useful. Including a multi-select of more than 1 chore and applying the action of, in this case, the DST sensitivity.

------------------------------
Wim Gielis

Original Message:
Sent: Fri March 29, 2024 09:18 PM
From: Hubert Heijkers
Subject: Chores and Daylight Savings Time (DST)

Hoi Wim,

Realize we just hit 24 hours before we change to DST but TM1 does support what you are asking for. It is correct that TM1 has always stored the start time in UTC (to be independent of local system settings) but at the same time has a DSTSensitive property/flag which, when set to true, will cause the start time to be offset accordingly and as such result in the start time remaining the same in local time.

If PA doesn't allow you to set this property/flag (which they should add/fix) than I'd quickly download Arc from our friends at Cubewise and use it to check that Daylight Savings Sensitive check-box there. Obviously you can also quickly PATCH the chore using the REST API and pass `{"DSTSensitive": true}`as the payload as well.

Happy Easter!

------------------------------
Hubert Heijkers
STSM, Program Director TM1 Functional Database Technology and OData Evangelist

Original Message:
Sent: Wed March 27, 2024 08:38 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello,

Through an IBM support ticket, my gut feeling was confirmed. Chores run on UTC, not local time.

This has implications for potentially all chores and the upcoming Easter weekend we might face issues. A warned man counts as two.

No willingness at IBM to change this behaviour. An idea was loaded 3 years ago, it's not under consideration and we need to use IBM Cognos Command Center.

Best regards,

Wim

------------------------------
Wim Gielis

Original Message:
Sent: Mon March 25, 2024 06:53 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello all,

This may seem an easy topic but I still have my doubts. My part of the world is Western Europe and we use CET, which is now UTC + 1 hour. Next Sunday, we jump to DST and it will be UTC + 2 hours.

I am asking myself the question whether we need to update chores given this change in timings.

What you actually require is that a chore, running now at 6 AM LOCAL time, remains at 6 AM local time in DST.

PAW and Architect have different settings, where Architect allows the choice of Local or UTC. PAW does not offer a choice.

What is strange: when I create 2 new chores in Architect and set them to 6 AM, one with Local, one with UTC, they show the same when refreshed in PAW !

Does anyone have a clear and correct guide on this ? What to do, if anything ? What to do end of October when leaving DST and going back to normal ?

Create the chore in PAW (with no choice), or create in Architect (then, how ?). Creating a chore in the NEW (DST) time on Sunday morning to force them in the, then active, timing ?

Many thanks,

Wim

------------------------------
Wim Gielis
------------------------------

Hi @Svetlana Pestsova, @Hubert Heijkers

That would be very good, thanks. But, unfortunately, I don't have the impression that the DST setting is honoured.

To give a bit more context, I have a daily chore that sends an email to myself. In local times, please find below the timings (I deleted some emails but the pattern is clear):

All chores are DSTSensitive = True.

The server message log is shown too. It's in UTC timings. To prove the latter, I ran a process manually just now (3.36 PM local time) and it is registered as 1.26 PM.

I have no clue what I should still do to get consistent local timings.

Thanks,

Wim

Thank you for the ask/info,

We'd add the option to select DST to the Workbench,

Best regards,

Thanks Hubert. With this REST API call I was able to PATCH the chores, so all good.

I agree, that checkbox in the interface would be useful. Including a multi-select of more than 1 chore and applying the action of, in this case, the DST sensitivity.

------------------------------
Wim Gielis

Original Message:
Sent: Fri March 29, 2024 09:18 PM
From: Hubert Heijkers
Subject: Chores and Daylight Savings Time (DST)

Hoi Wim,

Realize we just hit 24 hours before we change to DST but TM1 does support what you are asking for. It is correct that TM1 has always stored the start time in UTC (to be independent of local system settings) but at the same time has a DSTSensitive property/flag which, when set to true, will cause the start time to be offset accordingly and as such result in the start time remaining the same in local time.

If PA doesn't allow you to set this property/flag (which they should add/fix) than I'd quickly download Arc from our friends at Cubewise and use it to check that Daylight Savings Sensitive check-box there. Obviously you can also quickly PATCH the chore using the REST API and pass `{"DSTSensitive": true}`as the payload as well.

Happy Easter!

------------------------------
Hubert Heijkers
STSM, Program Director TM1 Functional Database Technology and OData Evangelist

Original Message:
Sent: Wed March 27, 2024 08:38 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello,

Through an IBM support ticket, my gut feeling was confirmed. Chores run on UTC, not local time.

This has implications for potentially all chores and the upcoming Easter weekend we might face issues. A warned man counts as two.

No willingness at IBM to change this behaviour. An idea was loaded 3 years ago, it's not under consideration and we need to use IBM Cognos Command Center.

Best regards,

Wim

------------------------------
Wim Gielis

Original Message:
Sent: Mon March 25, 2024 06:53 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello all,

This may seem an easy topic but I still have my doubts. My part of the world is Western Europe and we use CET, which is now UTC + 1 hour. Next Sunday, we jump to DST and it will be UTC + 2 hours.

I am asking myself the question whether we need to update chores given this change in timings.

What you actually require is that a chore, running now at 6 AM LOCAL time, remains at 6 AM local time in DST.

PAW and Architect have different settings, where Architect allows the choice of Local or UTC. PAW does not offer a choice.

What is strange: when I create 2 new chores in Architect and set them to 6 AM, one with Local, one with UTC, they show the same when refreshed in PAW !

Does anyone have a clear and correct guide on this ? What to do, if anything ? What to do end of October when leaving DST and going back to normal ?

Create the chore in PAW (with no choice), or create in Architect (then, how ?). Creating a chore in the NEW (DST) time on Sunday morning to force them in the, then active, timing ?

Many thanks,

Wim

------------------------------
Wim Gielis
------------------------------

Hoi Wim,

You got all these shores set to DSTSensitive now but you did update them on Saturday to become like that right? Before that they were not DSTSensitive correct? Did you restart the server since those updates of these DSTSensitive flags?

I'm asking because, trying to understand all the logic around it, I've gotten suspicious of the fact that this DSTSensitive flag, whilst correctly set on the Chore, might not get updated on the scheduler thread on which I see that value being cached. 

Hi @Svetlana Pestsova, @Hubert Heijkers

That would be very good, thanks. But, unfortunately, I don't have the impression that the DST setting is honoured.

To give a bit more context, I have a daily chore that sends an email to myself. In local times, please find below the timings (I deleted some emails but the pattern is clear):

All chores are DSTSensitive = True.

The server message log is shown too. It's in UTC timings. To prove the latter, I ran a process manually just now (3.36 PM local time) and it is registered as 1.26 PM.

I have no clue what I should still do to get consistent local timings.

Thanks,

Wim

Thank you for the ask/info,

We'd add the option to select DST to the Workbench,

Best regards,

Thanks Hubert. With this REST API call I was able to PATCH the chores, so all good.

I agree, that checkbox in the interface would be useful. Including a multi-select of more than 1 chore and applying the action of, in this case, the DST sensitivity.

------------------------------
Wim Gielis

Original Message:
Sent: Fri March 29, 2024 09:18 PM
From: Hubert Heijkers
Subject: Chores and Daylight Savings Time (DST)

Hoi Wim,

Realize we just hit 24 hours before we change to DST but TM1 does support what you are asking for. It is correct that TM1 has always stored the start time in UTC (to be independent of local system settings) but at the same time has a DSTSensitive property/flag which, when set to true, will cause the start time to be offset accordingly and as such result in the start time remaining the same in local time.

If PA doesn't allow you to set this property/flag (which they should add/fix) than I'd quickly download Arc from our friends at Cubewise and use it to check that Daylight Savings Sensitive check-box there. Obviously you can also quickly PATCH the chore using the REST API and pass `{"DSTSensitive": true}`as the payload as well.

Happy Easter!

------------------------------
Hubert Heijkers
STSM, Program Director TM1 Functional Database Technology and OData Evangelist

Original Message:
Sent: Wed March 27, 2024 08:38 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello,

Through an IBM support ticket, my gut feeling was confirmed. Chores run on UTC, not local time.

This has implications for potentially all chores and the upcoming Easter weekend we might face issues. A warned man counts as two.

No willingness at IBM to change this behaviour. An idea was loaded 3 years ago, it's not under consideration and we need to use IBM Cognos Command Center.

Best regards,

Wim

------------------------------
Wim Gielis

Original Message:
Sent: Mon March 25, 2024 06:53 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello all,

This may seem an easy topic but I still have my doubts. My part of the world is Western Europe and we use CET, which is now UTC + 1 hour. Next Sunday, we jump to DST and it will be UTC + 2 hours.

I am asking myself the question whether we need to update chores given this change in timings.

What you actually require is that a chore, running now at 6 AM LOCAL time, remains at 6 AM local time in DST.

PAW and Architect have different settings, where Architect allows the choice of Local or UTC. PAW does not offer a choice.

What is strange: when I create 2 new chores in Architect and set them to 6 AM, one with Local, one with UTC, they show the same when refreshed in PAW !

Does anyone have a clear and correct guide on this ? What to do, if anything ? What to do end of October when leaving DST and going back to normal ?

Create the chore in PAW (with no choice), or create in Architect (then, how ?). Creating a chore in the NEW (DST) time on Sunday morning to force them in the, then active, timing ?

Many thanks,

Wim

------------------------------
Wim Gielis
------------------------------

Hello Hubert,

Thanks. I can confirm that what I showed, was done before the DST switch.

However, no model restart was done. It did not occur to me that that was needed/a good test to try.

There aren't many chances in a year to test this behaviour, unless we change the server clock or something like that ?

All the best,

Wim

Hoi Wim,

You got all these shores set to DSTSensitive now but you did update them on Saturday to become like that right? Before that they were not DSTSensitive correct? Did you restart the server since those updates of these DSTSensitive flags?

I'm asking because, trying to understand all the logic around it, I've gotten suspicious of the fact that this DSTSensitive flag, whilst correctly set on the Chore, might not get updated on the scheduler thread on which I see that value being cached. 

Hi @Svetlana Pestsova, @Hubert Heijkers

That would be very good, thanks. But, unfortunately, I don't have the impression that the DST setting is honoured.

To give a bit more context, I have a daily chore that sends an email to myself. In local times, please find below the timings (I deleted some emails but the pattern is clear):

All chores are DSTSensitive = True.

The server message log is shown too. It's in UTC timings. To prove the latter, I ran a process manually just now (3.36 PM local time) and it is registered as 1.26 PM.

I have no clue what I should still do to get consistent local timings.

Thanks,

Wim

Thank you for the ask/info,

We'd add the option to select DST to the Workbench,

Best regards,

Thanks Hubert. With this REST API call I was able to PATCH the chores, so all good.

I agree, that checkbox in the interface would be useful. Including a multi-select of more than 1 chore and applying the action of, in this case, the DST sensitivity.

------------------------------
Wim Gielis

Original Message:
Sent: Fri March 29, 2024 09:18 PM
From: Hubert Heijkers
Subject: Chores and Daylight Savings Time (DST)

Hoi Wim,

Realize we just hit 24 hours before we change to DST but TM1 does support what you are asking for. It is correct that TM1 has always stored the start time in UTC (to be independent of local system settings) but at the same time has a DSTSensitive property/flag which, when set to true, will cause the start time to be offset accordingly and as such result in the start time remaining the same in local time.

If PA doesn't allow you to set this property/flag (which they should add/fix) than I'd quickly download Arc from our friends at Cubewise and use it to check that Daylight Savings Sensitive check-box there. Obviously you can also quickly PATCH the chore using the REST API and pass `{"DSTSensitive": true}`as the payload as well.

Happy Easter!

------------------------------
Hubert Heijkers
STSM, Program Director TM1 Functional Database Technology and OData Evangelist

Original Message:
Sent: Wed March 27, 2024 08:38 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello,

Through an IBM support ticket, my gut feeling was confirmed. Chores run on UTC, not local time.

This has implications for potentially all chores and the upcoming Easter weekend we might face issues. A warned man counts as two.

No willingness at IBM to change this behaviour. An idea was loaded 3 years ago, it's not under consideration and we need to use IBM Cognos Command Center.

Best regards,

Wim

------------------------------
Wim Gielis

Original Message:
Sent: Mon March 25, 2024 06:53 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello all,

This may seem an easy topic but I still have my doubts. My part of the world is Western Europe and we use CET, which is now UTC + 1 hour. Next Sunday, we jump to DST and it will be UTC + 2 hours.

I am asking myself the question whether we need to update chores given this change in timings.

What you actually require is that a chore, running now at 6 AM LOCAL time, remains at 6 AM local time in DST.

PAW and Architect have different settings, where Architect allows the choice of Local or UTC. PAW does not offer a choice.

What is strange: when I create 2 new chores in Architect and set them to 6 AM, one with Local, one with UTC, they show the same when refreshed in PAW !

Does anyone have a clear and correct guide on this ? What to do, if anything ? What to do end of October when leaving DST and going back to normal ?

Create the chore in PAW (with no choice), or create in Architect (then, how ?). Creating a chore in the NEW (DST) time on Sunday morning to force them in the, then active, timing ?

Many thanks,

Wim

------------------------------
Wim Gielis
------------------------------

Hello Wim,

Not many chances in production for sure, but if you happened to do a restart at some point I trust your e-mail would show up at 8:15 again instead of the 9:15 you are seeing it the last couple of times. Actually deactivating your chore (wait at least 5 seconds) and activating it again will do the trick as well come to think of it.

Cheers, 

Hello Hubert,

Thanks. I can confirm that what I showed, was done before the DST switch.

However, no model restart was done. It did not occur to me that that was needed/a good test to try.

There aren't many chances in a year to test this behaviour, unless we change the server clock or something like that ?

All the best,

Wim

Hoi Wim,

You got all these shores set to DSTSensitive now but you did update them on Saturday to become like that right? Before that they were not DSTSensitive correct? Did you restart the server since those updates of these DSTSensitive flags?

I'm asking because, trying to understand all the logic around it, I've gotten suspicious of the fact that this DSTSensitive flag, whilst correctly set on the Chore, might not get updated on the scheduler thread on which I see that value being cached. 

Hi @Svetlana Pestsova, @Hubert Heijkers

That would be very good, thanks. But, unfortunately, I don't have the impression that the DST setting is honoured.

To give a bit more context, I have a daily chore that sends an email to myself. In local times, please find below the timings (I deleted some emails but the pattern is clear):

All chores are DSTSensitive = True.

The server message log is shown too. It's in UTC timings. To prove the latter, I ran a process manually just now (3.36 PM local time) and it is registered as 1.26 PM.

I have no clue what I should still do to get consistent local timings.

Thanks,

Wim

Thank you for the ask/info,

We'd add the option to select DST to the Workbench,

Best regards,

Thanks Hubert. With this REST API call I was able to PATCH the chores, so all good.

I agree, that checkbox in the interface would be useful. Including a multi-select of more than 1 chore and applying the action of, in this case, the DST sensitivity.

------------------------------
Wim Gielis

Original Message:
Sent: Fri March 29, 2024 09:18 PM
From: Hubert Heijkers
Subject: Chores and Daylight Savings Time (DST)

Hoi Wim,

Realize we just hit 24 hours before we change to DST but TM1 does support what you are asking for. It is correct that TM1 has always stored the start time in UTC (to be independent of local system settings) but at the same time has a DSTSensitive property/flag which, when set to true, will cause the start time to be offset accordingly and as such result in the start time remaining the same in local time.

If PA doesn't allow you to set this property/flag (which they should add/fix) than I'd quickly download Arc from our friends at Cubewise and use it to check that Daylight Savings Sensitive check-box there. Obviously you can also quickly PATCH the chore using the REST API and pass `{"DSTSensitive": true}`as the payload as well.

Happy Easter!

------------------------------
Hubert Heijkers
STSM, Program Director TM1 Functional Database Technology and OData Evangelist

Original Message:
Sent: Wed March 27, 2024 08:38 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello,

Through an IBM support ticket, my gut feeling was confirmed. Chores run on UTC, not local time.

This has implications for potentially all chores and the upcoming Easter weekend we might face issues. A warned man counts as two.

No willingness at IBM to change this behaviour. An idea was loaded 3 years ago, it's not under consideration and we need to use IBM Cognos Command Center.

Best regards,

Wim

------------------------------
Wim Gielis

Original Message:
Sent: Mon March 25, 2024 06:53 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello all,

This may seem an easy topic but I still have my doubts. My part of the world is Western Europe and we use CET, which is now UTC + 1 hour. Next Sunday, we jump to DST and it will be UTC + 2 hours.

I am asking myself the question whether we need to update chores given this change in timings.

What you actually require is that a chore, running now at 6 AM LOCAL time, remains at 6 AM local time in DST.

PAW and Architect have different settings, where Architect allows the choice of Local or UTC. PAW does not offer a choice.

What is strange: when I create 2 new chores in Architect and set them to 6 AM, one with Local, one with UTC, they show the same when refreshed in PAW !

Does anyone have a clear and correct guide on this ? What to do, if anything ? What to do end of October when leaving DST and going back to normal ?

Create the chore in PAW (with no choice), or create in Architect (then, how ?). Creating a chore in the NEW (DST) time on Sunday morning to force them in the, then active, timing ?

Many thanks,

Wim

------------------------------
Wim Gielis
------------------------------

Hello Hubert,

Sorry to say this, but it seems that the DST setting is not yet applied correctly.

This weekend we make the change to winter time and a chore that is set to run at 6.20 AM every night, now runs at 5.20 AM.

That is, I looked at my watch at that point in time (my watch was already adjusted automatically), and it was 5.20 AM.

Should you want to have a look at some screenshots, support ticket TS017683601 was created.

Best regards,

Wim

Hello Wim,

Not many chances in production for sure, but if you happened to do a restart at some point I trust your e-mail would show up at 8:15 again instead of the 9:15 you are seeing it the last couple of times. Actually deactivating your chore (wait at least 5 seconds) and activating it again will do the trick as well come to think of it.

Cheers, 

Hello Hubert,

Thanks. I can confirm that what I showed, was done before the DST switch.

However, no model restart was done. It did not occur to me that that was needed/a good test to try.

There aren't many chances in a year to test this behaviour, unless we change the server clock or something like that ?

All the best,

Wim

Hoi Wim,

You got all these shores set to DSTSensitive now but you did update them on Saturday to become like that right? Before that they were not DSTSensitive correct? Did you restart the server since those updates of these DSTSensitive flags?

I'm asking because, trying to understand all the logic around it, I've gotten suspicious of the fact that this DSTSensitive flag, whilst correctly set on the Chore, might not get updated on the scheduler thread on which I see that value being cached. 

Hi @Svetlana Pestsova, @Hubert Heijkers

That would be very good, thanks. But, unfortunately, I don't have the impression that the DST setting is honoured.

To give a bit more context, I have a daily chore that sends an email to myself. In local times, please find below the timings (I deleted some emails but the pattern is clear):

All chores are DSTSensitive = True.

The server message log is shown too. It's in UTC timings. To prove the latter, I ran a process manually just now (3.36 PM local time) and it is registered as 1.26 PM.

I have no clue what I should still do to get consistent local timings.

Thanks,

Wim

Thank you for the ask/info,

We'd add the option to select DST to the Workbench,

Best regards,

Thanks Hubert. With this REST API call I was able to PATCH the chores, so all good.

I agree, that checkbox in the interface would be useful. Including a multi-select of more than 1 chore and applying the action of, in this case, the DST sensitivity.

------------------------------
Wim Gielis

Original Message:
Sent: Fri March 29, 2024 09:18 PM
From: Hubert Heijkers
Subject: Chores and Daylight Savings Time (DST)

Hoi Wim,

Realize we just hit 24 hours before we change to DST but TM1 does support what you are asking for. It is correct that TM1 has always stored the start time in UTC (to be independent of local system settings) but at the same time has a DSTSensitive property/flag which, when set to true, will cause the start time to be offset accordingly and as such result in the start time remaining the same in local time.

If PA doesn't allow you to set this property/flag (which they should add/fix) than I'd quickly download Arc from our friends at Cubewise and use it to check that Daylight Savings Sensitive check-box there. Obviously you can also quickly PATCH the chore using the REST API and pass `{"DSTSensitive": true}`as the payload as well.

Happy Easter!

------------------------------
Hubert Heijkers
STSM, Program Director TM1 Functional Database Technology and OData Evangelist

Original Message:
Sent: Wed March 27, 2024 08:38 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello,

Through an IBM support ticket, my gut feeling was confirmed. Chores run on UTC, not local time.

This has implications for potentially all chores and the upcoming Easter weekend we might face issues. A warned man counts as two.

No willingness at IBM to change this behaviour. An idea was loaded 3 years ago, it's not under consideration and we need to use IBM Cognos Command Center.

Best regards,

Wim

------------------------------
Wim Gielis

Original Message:
Sent: Mon March 25, 2024 06:53 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello all,

This may seem an easy topic but I still have my doubts. My part of the world is Western Europe and we use CET, which is now UTC + 1 hour. Next Sunday, we jump to DST and it will be UTC + 2 hours.

I am asking myself the question whether we need to update chores given this change in timings.

What you actually require is that a chore, running now at 6 AM LOCAL time, remains at 6 AM local time in DST.

PAW and Architect have different settings, where Architect allows the choice of Local or UTC. PAW does not offer a choice.

What is strange: when I create 2 new chores in Architect and set them to 6 AM, one with Local, one with UTC, they show the same when refreshed in PAW !

Does anyone have a clear and correct guide on this ? What to do, if anything ? What to do end of October when leaving DST and going back to normal ?

Create the chore in PAW (with no choice), or create in Architect (then, how ?). Creating a chore in the NEW (DST) time on Sunday morning to force them in the, then active, timing ?

Many thanks,

Wim

------------------------------
Wim Gielis
------------------------------

Hoi Wim,

I'm about to jump into an Uber to the airport for my next stop this trip but, as I'm unlikely to look at it today, could you verify when it runs tonight? Without looking at the code I have a suspicion and if it would run at the expected time tonight I might know where to look;-)

Cheers,

-H 

Hello Hubert,

Sorry to say this, but it seems that the DST setting is not yet applied correctly.

This weekend we make the change to winter time and a chore that is set to run at 6.20 AM every night, now runs at 5.20 AM.

That is, I looked at my watch at that point in time (my watch was already adjusted automatically), and it was 5.20 AM.

Should you want to have a look at some screenshots, support ticket TS017683601 was created.

Best regards,

Wim

Hello Wim,

Not many chances in production for sure, but if you happened to do a restart at some point I trust your e-mail would show up at 8:15 again instead of the 9:15 you are seeing it the last couple of times. Actually deactivating your chore (wait at least 5 seconds) and activating it again will do the trick as well come to think of it.

Cheers, 

Hello Hubert,

Thanks. I can confirm that what I showed, was done before the DST switch.

However, no model restart was done. It did not occur to me that that was needed/a good test to try.

There aren't many chances in a year to test this behaviour, unless we change the server clock or something like that ?

All the best,

Wim

Hoi Wim,

You got all these shores set to DSTSensitive now but you did update them on Saturday to become like that right? Before that they were not DSTSensitive correct? Did you restart the server since those updates of these DSTSensitive flags?

I'm asking because, trying to understand all the logic around it, I've gotten suspicious of the fact that this DSTSensitive flag, whilst correctly set on the Chore, might not get updated on the scheduler thread on which I see that value being cached. 

Hi @Svetlana Pestsova, @Hubert Heijkers

That would be very good, thanks. But, unfortunately, I don't have the impression that the DST setting is honoured.

To give a bit more context, I have a daily chore that sends an email to myself. In local times, please find below the timings (I deleted some emails but the pattern is clear):

All chores are DSTSensitive = True.

The server message log is shown too. It's in UTC timings. To prove the latter, I ran a process manually just now (3.36 PM local time) and it is registered as 1.26 PM.

I have no clue what I should still do to get consistent local timings.

Thanks,

Wim

Thank you for the ask/info,

We'd add the option to select DST to the Workbench,

Best regards,

Thanks Hubert. With this REST API call I was able to PATCH the chores, so all good.

I agree, that checkbox in the interface would be useful. Including a multi-select of more than 1 chore and applying the action of, in this case, the DST sensitivity.

------------------------------
Wim Gielis

Original Message:
Sent: Fri March 29, 2024 09:18 PM
From: Hubert Heijkers
Subject: Chores and Daylight Savings Time (DST)

Hoi Wim,

Realize we just hit 24 hours before we change to DST but TM1 does support what you are asking for. It is correct that TM1 has always stored the start time in UTC (to be independent of local system settings) but at the same time has a DSTSensitive property/flag which, when set to true, will cause the start time to be offset accordingly and as such result in the start time remaining the same in local time.

If PA doesn't allow you to set this property/flag (which they should add/fix) than I'd quickly download Arc from our friends at Cubewise and use it to check that Daylight Savings Sensitive check-box there. Obviously you can also quickly PATCH the chore using the REST API and pass `{"DSTSensitive": true}`as the payload as well.

Happy Easter!

------------------------------
Hubert Heijkers
STSM, Program Director TM1 Functional Database Technology and OData Evangelist

Original Message:
Sent: Wed March 27, 2024 08:38 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello,

Through an IBM support ticket, my gut feeling was confirmed. Chores run on UTC, not local time.

This has implications for potentially all chores and the upcoming Easter weekend we might face issues. A warned man counts as two.

No willingness at IBM to change this behaviour. An idea was loaded 3 years ago, it's not under consideration and we need to use IBM Cognos Command Center.

Best regards,

Wim

------------------------------
Wim Gielis

Original Message:
Sent: Mon March 25, 2024 06:53 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello all,

This may seem an easy topic but I still have my doubts. My part of the world is Western Europe and we use CET, which is now UTC + 1 hour. Next Sunday, we jump to DST and it will be UTC + 2 hours.

I am asking myself the question whether we need to update chores given this change in timings.

What you actually require is that a chore, running now at 6 AM LOCAL time, remains at 6 AM local time in DST.

PAW and Architect have different settings, where Architect allows the choice of Local or UTC. PAW does not offer a choice.

What is strange: when I create 2 new chores in Architect and set them to 6 AM, one with Local, one with UTC, they show the same when refreshed in PAW !

Does anyone have a clear and correct guide on this ? What to do, if anything ? What to do end of October when leaving DST and going back to normal ?

Create the chore in PAW (with no choice), or create in Architect (then, how ?). Creating a chore in the NEW (DST) time on Sunday morning to force them in the, then active, timing ?

Many thanks,

Wim

------------------------------
Wim Gielis
------------------------------

Hi Hubert,

I can do that. It means that it will run tomorrow at 5.20 AM or 6.20 AM my local Belgium time (early Monday morning).

1 process in the chore gives (known) minor errors so I can check the file date time in FileZilla, for instance (easier than the TM1server.log file which might be local or GMT notation and I could be lost for a sec).

I will update this thread Monday morning.

Thanks,

Wim

Hoi Wim,

I'm about to jump into an Uber to the airport for my next stop this trip but, as I'm unlikely to look at it today, could you verify when it runs tonight? Without looking at the code I have a suspicion and if it would run at the expected time tonight I might know where to look;-)

Cheers,

-H 

Hello Hubert,

Sorry to say this, but it seems that the DST setting is not yet applied correctly.

This weekend we make the change to winter time and a chore that is set to run at 6.20 AM every night, now runs at 5.20 AM.

That is, I looked at my watch at that point in time (my watch was already adjusted automatically), and it was 5.20 AM.

Should you want to have a look at some screenshots, support ticket TS017683601 was created.

Best regards,

Wim

Hello Wim,

Not many chances in production for sure, but if you happened to do a restart at some point I trust your e-mail would show up at 8:15 again instead of the 9:15 you are seeing it the last couple of times. Actually deactivating your chore (wait at least 5 seconds) and activating it again will do the trick as well come to think of it.

Cheers, 

Hello Hubert,

Thanks. I can confirm that what I showed, was done before the DST switch.

However, no model restart was done. It did not occur to me that that was needed/a good test to try.

There aren't many chances in a year to test this behaviour, unless we change the server clock or something like that ?

All the best,

Wim

Hoi Wim,

You got all these shores set to DSTSensitive now but you did update them on Saturday to become like that right? Before that they were not DSTSensitive correct? Did you restart the server since those updates of these DSTSensitive flags?

I'm asking because, trying to understand all the logic around it, I've gotten suspicious of the fact that this DSTSensitive flag, whilst correctly set on the Chore, might not get updated on the scheduler thread on which I see that value being cached. 

Hi @Svetlana Pestsova, @Hubert Heijkers

That would be very good, thanks. But, unfortunately, I don't have the impression that the DST setting is honoured.

To give a bit more context, I have a daily chore that sends an email to myself. In local times, please find below the timings (I deleted some emails but the pattern is clear):

All chores are DSTSensitive = True.

The server message log is shown too. It's in UTC timings. To prove the latter, I ran a process manually just now (3.36 PM local time) and it is registered as 1.26 PM.

I have no clue what I should still do to get consistent local timings.

Thanks,

Wim

Thank you for the ask/info,

We'd add the option to select DST to the Workbench,

Best regards,

Thanks Hubert. With this REST API call I was able to PATCH the chores, so all good.

I agree, that checkbox in the interface would be useful. Including a multi-select of more than 1 chore and applying the action of, in this case, the DST sensitivity.

------------------------------
Wim Gielis

Original Message:
Sent: Fri March 29, 2024 09:18 PM
From: Hubert Heijkers
Subject: Chores and Daylight Savings Time (DST)

Hoi Wim,

Realize we just hit 24 hours before we change to DST but TM1 does support what you are asking for. It is correct that TM1 has always stored the start time in UTC (to be independent of local system settings) but at the same time has a DSTSensitive property/flag which, when set to true, will cause the start time to be offset accordingly and as such result in the start time remaining the same in local time.

If PA doesn't allow you to set this property/flag (which they should add/fix) than I'd quickly download Arc from our friends at Cubewise and use it to check that Daylight Savings Sensitive check-box there. Obviously you can also quickly PATCH the chore using the REST API and pass `{"DSTSensitive": true}`as the payload as well.

Happy Easter!

------------------------------
Hubert Heijkers
STSM, Program Director TM1 Functional Database Technology and OData Evangelist

Original Message:
Sent: Wed March 27, 2024 08:38 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello,

Through an IBM support ticket, my gut feeling was confirmed. Chores run on UTC, not local time.

This has implications for potentially all chores and the upcoming Easter weekend we might face issues. A warned man counts as two.

No willingness at IBM to change this behaviour. An idea was loaded 3 years ago, it's not under consideration and we need to use IBM Cognos Command Center.

Best regards,

Wim

------------------------------
Wim Gielis

Original Message:
Sent: Mon March 25, 2024 06:53 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello all,

This may seem an easy topic but I still have my doubts. My part of the world is Western Europe and we use CET, which is now UTC + 1 hour. Next Sunday, we jump to DST and it will be UTC + 2 hours.

I am asking myself the question whether we need to update chores given this change in timings.

What you actually require is that a chore, running now at 6 AM LOCAL time, remains at 6 AM local time in DST.

PAW and Architect have different settings, where Architect allows the choice of Local or UTC. PAW does not offer a choice.

What is strange: when I create 2 new chores in Architect and set them to 6 AM, one with Local, one with UTC, they show the same when refreshed in PAW !

Does anyone have a clear and correct guide on this ? What to do, if anything ? What to do end of October when leaving DST and going back to normal ?

Create the chore in PAW (with no choice), or create in Architect (then, how ?). Creating a chore in the NEW (DST) time on Sunday morning to force them in the, then active, timing ?

Many thanks,

Wim

------------------------------
Wim Gielis
------------------------------

Hello Hubert,

As indicated I would take a look at the situation this morning, Monday morning.

It's exactly the same as Sunday morning. The chore kicks off at 5.20 AM, not 6.20 AM to which it was set already (I did no change to the chore for the DST change).

In PAW the checkbox for DST is checked.

Does that help identifying what is going on ? The support ticket will contain a FileZilla picture of the TM1 logging directory with file dates and times.

Thanks,

Wim

Hi Hubert,

I can do that. It means that it will run tomorrow at 5.20 AM or 6.20 AM my local Belgium time (early Monday morning).

1 process in the chore gives (known) minor errors so I can check the file date time in FileZilla, for instance (easier than the TM1server.log file which might be local or GMT notation and I could be lost for a sec).

I will update this thread Monday morning.

Thanks,

Wim

Hoi Wim,

I'm about to jump into an Uber to the airport for my next stop this trip but, as I'm unlikely to look at it today, could you verify when it runs tonight? Without looking at the code I have a suspicion and if it would run at the expected time tonight I might know where to look;-)

Cheers,

-H 

Hello Hubert,

Sorry to say this, but it seems that the DST setting is not yet applied correctly.

This weekend we make the change to winter time and a chore that is set to run at 6.20 AM every night, now runs at 5.20 AM.

That is, I looked at my watch at that point in time (my watch was already adjusted automatically), and it was 5.20 AM.

Should you want to have a look at some screenshots, support ticket TS017683601 was created.

Best regards,

Wim

Hello Wim,

Not many chances in production for sure, but if you happened to do a restart at some point I trust your e-mail would show up at 8:15 again instead of the 9:15 you are seeing it the last couple of times. Actually deactivating your chore (wait at least 5 seconds) and activating it again will do the trick as well come to think of it.

Cheers, 

Hello Hubert,

Thanks. I can confirm that what I showed, was done before the DST switch.

However, no model restart was done. It did not occur to me that that was needed/a good test to try.

There aren't many chances in a year to test this behaviour, unless we change the server clock or something like that ?

All the best,

Wim

Hoi Wim,

You got all these shores set to DSTSensitive now but you did update them on Saturday to become like that right? Before that they were not DSTSensitive correct? Did you restart the server since those updates of these DSTSensitive flags?

I'm asking because, trying to understand all the logic around it, I've gotten suspicious of the fact that this DSTSensitive flag, whilst correctly set on the Chore, might not get updated on the scheduler thread on which I see that value being cached. 

Hi @Svetlana Pestsova, @Hubert Heijkers

That would be very good, thanks. But, unfortunately, I don't have the impression that the DST setting is honoured.

To give a bit more context, I have a daily chore that sends an email to myself. In local times, please find below the timings (I deleted some emails but the pattern is clear):

All chores are DSTSensitive = True.

The server message log is shown too. It's in UTC timings. To prove the latter, I ran a process manually just now (3.36 PM local time) and it is registered as 1.26 PM.

I have no clue what I should still do to get consistent local timings.

Thanks,

Wim

Thank you for the ask/info,

We'd add the option to select DST to the Workbench,

Best regards,

Thanks Hubert. With this REST API call I was able to PATCH the chores, so all good.

I agree, that checkbox in the interface would be useful. Including a multi-select of more than 1 chore and applying the action of, in this case, the DST sensitivity.

------------------------------
Wim Gielis

Original Message:
Sent: Fri March 29, 2024 09:18 PM
From: Hubert Heijkers
Subject: Chores and Daylight Savings Time (DST)

Hoi Wim,

Realize we just hit 24 hours before we change to DST but TM1 does support what you are asking for. It is correct that TM1 has always stored the start time in UTC (to be independent of local system settings) but at the same time has a DSTSensitive property/flag which, when set to true, will cause the start time to be offset accordingly and as such result in the start time remaining the same in local time.

If PA doesn't allow you to set this property/flag (which they should add/fix) than I'd quickly download Arc from our friends at Cubewise and use it to check that Daylight Savings Sensitive check-box there. Obviously you can also quickly PATCH the chore using the REST API and pass `{"DSTSensitive": true}`as the payload as well.

Happy Easter!

------------------------------
Hubert Heijkers
STSM, Program Director TM1 Functional Database Technology and OData Evangelist

Original Message:
Sent: Wed March 27, 2024 08:38 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello,

Through an IBM support ticket, my gut feeling was confirmed. Chores run on UTC, not local time.

This has implications for potentially all chores and the upcoming Easter weekend we might face issues. A warned man counts as two.

No willingness at IBM to change this behaviour. An idea was loaded 3 years ago, it's not under consideration and we need to use IBM Cognos Command Center.

Best regards,

Wim

------------------------------
Wim Gielis

Original Message:
Sent: Mon March 25, 2024 06:53 AM
From: Wim Gielis
Subject: Chores and Daylight Savings Time (DST)

Hello all,

This may seem an easy topic but I still have my doubts. My part of the world is Western Europe and we use CET, which is now UTC + 1 hour. Next Sunday, we jump to DST and it will be UTC + 2 hours.

I am asking myself the question whether we need to update chores given this change in timings.

What you actually require is that a chore, running now at 6 AM LOCAL time, remains at 6 AM local time in DST.

PAW and Architect have different settings, where Architect allows the choice of Local or UTC. PAW does not offer a choice.

What is strange: when I create 2 new chores in Architect and set them to 6 AM, one with Local, one with UTC, they show the same when refreshed in PAW !

Does anyone have a clear and correct guide on this ? What to do, if anything ? What to do end of October when leaving DST and going back to normal ?

Create the chore in PAW (with no choice), or create in Architect (then, how ?). Creating a chore in the NEW (DST) time on Sunday morning to force them in the, then active, timing ?

Many thanks,

Wim

------------------------------
Wim Gielis
------------------------------