Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019228Openbravo ERP01. General setuppublic2011-12-01 23:472011-12-22 09:25
Reporterroklenardic 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP5.1 
Target VersionFixed in Version3.0MP7 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019228: Reschedule Process fails with US style dates
DescriptionIf one uses US standard date formats (in Oracle):

dateFormat.js=%m/%d/%Y
dateFormat.sql=MM/DD/YYYY
dateFormat.java=MM/dd/yyyy
dateTimeFormat.java=MM/dd/yyyy HH\:mm\:ss
dateTimeFormat.sql=MM/DD/YYYY HH24\:MI\:SS

the Reschedule Process fails when rescheduling processes that have Start Date entered. It works if changing formats it to

dateTimeFormat.sql=MM-DD-YYYY HH24\:MI\:SS
dateFormat.sql=MM-DD-YYYY
dateTimeFormat.java=MM-dd-yyyy HH\:mm\:ss
dateFormat.java=MM-dd-yyyy
dateFormat.js=%m-%d-%Y
Steps To Reproduce1) Set the Openbravo.properties date formats to standard US with the forward slash /
2) rebuild/redeploy
3) login
4) switch to System Admin
5) go to Process Request screen
6) choose Acct Server Process
7) stop it
8) enter Start Date, e.g. 12/24/2011
9) click the Reschedule Process button to receive this:

Process Request
RESCHED_ERROR The trigger information you have entered is invalid. Details: Unparseable date: "12-24-2011"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0019455 closed marvintm The process scheduling fails after some time if using a different date format 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-12-01 23:47roklenardicNew Issue
2011-12-01 23:47roklenardicAssigned To => jonalegriaesarte
2011-12-01 23:47roklenardicWeb browser => Google Chrome
2011-12-01 23:47roklenardicModules => Core
2011-12-13 10:10jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2011-12-13 10:35psarobeNote Added: 0043814
2011-12-13 10:37psarobeWeb browserGoogle Chrome => Google Chrome
2011-12-13 10:37psarobeSeverityminor => major
2011-12-13 10:41psarobeNote Edited: 0043814bug_revision_view_page.php?bugnote_id=0043814#r2974
2011-12-13 12:29iciordiaAssigned Tojecharri => marvintm
2011-12-13 19:09hgbotCheckin
2011-12-13 19:09hgbotNote Added: 0043856
2011-12-13 19:09hgbotStatusnew => resolved
2011-12-13 19:09hgbotResolutionopen => fixed
2011-12-13 19:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9c987c6e8bc83dc3ef27308783844ce812965669 [^]
2011-12-13 19:33hgbotCheckin
2011-12-13 19:33hgbotNote Added: 0043857
2011-12-14 10:27marvintmNote Added: 0043860
2011-12-14 10:27marvintmStatusresolved => new
2011-12-14 10:27marvintmResolutionfixed => open
2011-12-14 11:55hgbotCheckin
2011-12-14 11:55hgbotNote Added: 0043871
2011-12-14 11:55hgbotStatusnew => resolved
2011-12-14 11:55hgbotResolutionopen => fixed
2011-12-14 11:55hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/9c987c6e8bc83dc3ef27308783844ce812965669 [^] => http://code.openbravo.com/erp/devel/pi/rev/439027d73f6bf9fb85b6fa920ebe2d97717cda6e [^]
2011-12-17 03:07hudsonbotCheckin
2011-12-17 03:07hudsonbotNote Added: 0043916
2011-12-17 03:07hudsonbotCheckin
2011-12-17 03:07hudsonbotNote Added: 0043917
2011-12-17 03:07hudsonbotCheckin
2011-12-17 03:07hudsonbotNote Added: 0043921
2011-12-22 09:25alostaleNote Added: 0044002
2011-12-22 09:25alostaleStatusresolved => closed
2011-12-22 09:25alostaleFixed in Version => 3.0MP7
2012-01-10 18:34marvintmRelationship addedrelated to 0019455

Notes
(0043814)
psarobe   
2011-12-13 10:35   
(edited on: 2011-12-13 10:41)
The same happens to me but my configuration is a little bit different:

dateFormat.sql=DD/MM/YYYY
dateFormat.java=dd/MM/yyyy
dateFormat.js=%d/%m/%Y
dateTimeFormat.java=dd/MM/yyyy HH:mm:ss

And this results in a strange behaviour across the ERP
(0043856)
hgbot   
2011-12-13 19:09   
Repository: erp/devel/pi
Changeset: 9c987c6e8bc83dc3ef27308783844ce812965669
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Dec 13 19:08:33 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/9c987c6e8bc83dc3ef27308783844ce812965669 [^]

Fixed issue 19228. OBScheduler will correctly parse all dates

---
M src/org/openbravo/scheduling/OBScheduler.java
---
(0043857)
hgbot   
2011-12-13 19:33   
Repository: erp/devel/pi
Changeset: 411e37bc6dbb449dc7ff13e222e061a067faf980
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Dec 13 19:32:33 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/411e37bc6dbb449dc7ff13e222e061a067faf980 [^]

Related to issue 19228. Reverted fix as it was not correct in all cases

---
M src/org/openbravo/scheduling/OBScheduler.java
---
(0043860)
marvintm   
2011-12-14 10:27   
The previous fix wasn't correct. A new fix will be pushed soon.
(0043871)
hgbot   
2011-12-14 11:55   
Repository: erp/devel/pi
Changeset: 439027d73f6bf9fb85b6fa920ebe2d97717cda6e
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Dec 14 11:53:55 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/439027d73f6bf9fb85b6fa920ebe2d97717cda6e [^]

Fixed issue 19228. Date format will be set in the query so that there is no issue when changing the date format

---
M src/org/openbravo/scheduling/OBScheduler.java
M src/org/openbravo/scheduling/Trigger_data.xsql
---
(0043916)
hudsonbot   
2011-12-17 03:07   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/919bff4169c5 [^]

Maturity status: Test
(0043917)
hudsonbot   
2011-12-17 03:07   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/919bff4169c5 [^]

Maturity status: Test
(0043921)
hudsonbot   
2011-12-17 03:07   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/919bff4169c5 [^]

Maturity status: Test
(0044002)
alostale   
2011-12-22 09:25   
Verified on pi@d17b74061474