Re: Issue with OFBiz Job Scheduler and Daylight Saving Time

2023-11-06 Thread Scott Gray
Hi Deepak, A few years ago we modified the JobSandbox table to include a temporal expression timezone field, that allowed a UTC based OFBiz to schedule recurring jobs according to a specific timezone but ultimately store the next runTime back in UTC. I had thought that improvement had made it

Re: Issue with OFBiz Job Scheduler and Daylight Saving Time

2023-11-05 Thread Deepak Dixit
Thanks Scott for the review and input. I agree we can use UTC, but in this case we need to reschedule the job timings according to the user timezone. eg. - Reporting jobs that runs on specific time - Some business process, like order routing job etc. that should run on specific time, Please

Re: Issue with OFBiz Job Scheduler and Daylight Saving Time

2023-11-03 Thread Scott Gray
Hi Deepak, IMO the best general solution is to not run OFBiz or the database configured with a timezone that observes DST, instead use UTC or similar. This achieves the same result but without needing any extra fields. I'm not objecting to your solution, just sharing this tip out loud since the

Re: Issue with OFBiz Job Scheduler and Daylight Saving Time

2023-10-30 Thread Deepak Dixit
Here is the PR for reference https://github.com/apache/ofbiz-framework/pull/674/files Please review and share your feedback!! Thanks & Regards -- Deepak Dixit ofbiz.apache.org On Mon, Oct 30, 2023 at 6:53 PM Michael Brohl wrote: > +1 > > Thanks Deepak, > > Michael Brohl > > ecomify GmbH -

Re: Issue with OFBiz Job Scheduler and Daylight Saving Time

2023-10-30 Thread Michael Brohl
+1 Thanks Deepak, Michael Brohl ecomify GmbH - www.ecomify.de Am 30.10.23 um 14:03 schrieb Deepak Dixit: The issue occurs when DST changes, and OFBiz fails to schedule recurring jobs properly. This is due to a condition in the PersistedServiceJob.createRecurrence method where it compares

Re: Issue with OFBiz Job Scheduler and Daylight Saving Time

2023-10-30 Thread Deepak Dixit
Here is the task for reference https://issues.apache.org/jira/browse/OFBIZ-12864 Thanks & Regards -- Deepak Dixit ofbiz.apache.org On Mon, Oct 30, 2023 at 6:33 PM Deepak Dixit wrote: > The issue occurs when DST changes, and OFBiz fails to schedule recurring > jobs properly. > This is due to a

Re: Issue with OFBiz Job Scheduler and Daylight Saving Time

2023-10-30 Thread Deepak Dixit
The issue occurs when DST changes, and OFBiz fails to schedule recurring jobs properly. This is due to a condition in the PersistedServiceJob.createRecurrence method where it compares the next scheduled time (next) with the start time (startTime) for the job. *Proposed Solution:*To address the

Issue with OFBiz Job Scheduler and Daylight Saving Time

2023-10-16 Thread Deepak Dixit
Hi Dev, I wanted to draw your attention to an issue we've encountered with the OFBiz job scheduler, particularly when it comes to handling Daylight Saving Time (DST) changes. It appears that the job scheduler fails to create new recurring jobs when DST ends, especially when the tempExprTypeId is