[Mifos-issues] [JIRA] (MIFOSX-1269) Job scheduler timezones not handled correctly
Title: Message Title Binny Gopinath Sreevas updated an issue Mifos X / MIFOSX-1269 Job scheduler timezones not handled correctly Change By: Binny Gopinath Sreevas Fix Version/s: ImmediateBacklog Fix Version/s: ConfirmedBacklog Add Comment This message was sent by Atlassian JIRA (v6.3-OD-08-005-WN#6328-sha1:aae40f7) -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds___ Mifos-issues mailing list Mifos-issues@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-issues
[Mifos-issues] [JIRA] (MIFOSX-1269) Job scheduler timezones not handled correctly
Title: Message Title Sander van der Heyden created an issue Mifos X / MIFOSX-1269 Job scheduler timezones not handled correctly Issue Type: Bug Assignee: Unassigned Created: 02/Jun/14 4:15 AM Priority: Major Reporter: Sander van der Heyden When investigating some issues with the overdue loan portfolio we found out that the current way the jobs are handled can cause differences in the figures for tenants by not picking up the correct date. The server has the timezone set to UTC/GMT. When a cronjob is added with a cron entry to run at 0:01 every day, the java scheduler converts this into the timezone of the tenant (UTC+3 in this example). In this case this results in the actual schedule to be kicked off at 21:01 the day before. When the job then triggers it on 21:01 on 01-06-2014 it uses the mysql CURDATE() feature to decide on the current date, but this returns in UTC, therefore reporting everything against 01-06-2014, instead of 02-06-2014 which was the expected (based on timezone UTC+3). In this case the arrears are updated incorrectly, but same applies to prepayments and all other jobs that happen in the gap between UTC and the tenant timezone. Workaround: Update the cronjob entry to run at 03:01 (UTC+3) by default, this then gets converted into 0:01 (UTC) and therefore it uses 02-06-2014 as the date.
[Mifos-issues] [JIRA] (MIFOSX-1269) Job scheduler timezones not handled correctly
Title: Message Title Sander van der Heyden commented on MIFOSX-1269 Re: Job scheduler timezones not handled correctly Vishwas Babu A J there is the option in MySQL to do SET time_zone = 'America/Los_Angeles';. I'm unsure if this is persisted per connection or per query (which would throw back problems with the regular selects that get adjusted in JAVA). Add Comment This message was sent by Atlassian JIRA (v6.3-OD-06-017#6327-sha1:b47b85e) -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech___ Mifos-issues mailing list Mifos-issues@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-issues
[Mifos-issues] [JIRA] (MIFOSX-1269) Job scheduler timezones not handled correctly
Title: Message Title Vishwas Babu A J updated an issue Mifos X / MIFOSX-1269 Job scheduler timezones not handled correctly Change By: Vishwas Babu A J Fix Version/s: 1.23.0.RELEASE Add Comment This message was sent by Atlassian JIRA (v6.3-OD-06-017#6327-sha1:b47b85e) -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech___ Mifos-issues mailing list Mifos-issues@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-issues
[Mifos-issues] [JIRA] (MIFOSX-1269) Job scheduler timezones not handled correctly
Title: Message Title Vishwas Babu A J updated an issue Mifos X / MIFOSX-1269 Job scheduler timezones not handled correctly Change By: Vishwas Babu A J Assignee: PramodNuthakki Add Comment This message was sent by Atlassian JIRA (v6.3-OD-06-017#6327-sha1:b47b85e) -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech___ Mifos-issues mailing list Mifos-issues@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-issues