🔧 Critical Issue with "Delay Until" and Timezone Handling on Self-Hosted Instance

Discussions
1

Hi everyone,

I’m facing an urgent issue with my self-hosted Activepieces setup. I have several hundred active flows using the “Delay Until” step, where a pause is set dynamically using an ISO timestamp like this: 2025-06-16T18:45:00 (no timezone suffix included).

The problem is that these timestamps are being interpreted as UTC, whereas I need them to be handled in Europe/Paris time (CET/CEST). As a result, all of my flows will resume 1 to 2 hours off schedule — which is critical for my use case.

Here’s what I’ve already tried:

Changed the server timezone to Europe/Paris (via TZ env variable) → had no effect on scheduled flows.

Restarted all containers with updated timezone.

I cannot manually edit all paused flows — there are too many (~1000).

:pushpin: What I need:

  1. A way to mass-update all currently paused flows so they trigger at the correct Paris time (instead of UTC).

  2. A way to make sure future flows interpret ISO timestamps (without offset) as Paris time — or at least allow me to enforce this behavior globally.

Any help (SQL patch? configuration override? code patch?) would be hugely appreciated :pray: — this could otherwise cause major misfires in my automation workflows.

Thanks in advance!

2

Hello @Nadir_de_Source,

I’ve forwarded the issue to the team. They’ll get back to you soon.

3

Thanks a lot.

I’d like by the way to change the time of the PAUSED flows ; I tried something like this
BEGIN;

UPDATE flow_run
SET “pauseMetadata” = jsonb_set(
“pauseMetadata”,
‘{resumeDateTime}’,
to_jsonb(
((“pauseMetadata”->>‘resumeDateTime’)::timestamptz
- interval ‘2 hours’)::text
)
)
WHERE flowDisplayName = ‘fr-online-event-forms-management’
AND “pauseMetadata” @> ‘{
“type”:“DELAY”,
“handlerId”:“”,
“progressUpdateType”:“NONE”
}’
AND (“pauseMetadata”->>‘resumeDateTime’) = ‘2025-06-08 18:40:00+00’;

COMMIT;

It updated the db but the flow was still running in UTC :s

I updated my times in my flows that I will send them in UTC for the delay until, like this I wont have this problem later.

But for my PAUSED flows I really need to update them.

4

@kishanprmr

Is it possible to have a feedback today please? I have the flows coming tomorrow I dont know how to switch or change the time trigger (with 2 hours less).