Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0019228
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupmajoralways2011-12-01 23:472011-12-22 09:25
ReporterroklenardicView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in Version3.0MP7
StatusclosedFix in branchFixed in SCM revision439027d73f6b
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0MP5.1SCM revision 
Review Assigned To
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0019228: 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"
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0019455 closedmarvintm The process scheduling fails after some time if using a different date format 

-  Notes
(0043814)
psarobe (manager)
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 (developer)
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 (developer)
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 (developer)
2011-12-14 10:27

 The previous fix wasn't correct. A new fix will be pushed soon.
(0043871)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (manager)
2011-12-22 09:25

 Verified on pi@d17b74061474

- Issue History
Date Modified Username Field Change
2011-12-01 23:47 roklenardic New Issue
2011-12-01 23:47 roklenardic Assigned To => jonalegriaesarte
2011-12-01 23:47 roklenardic Web browser => Google Chrome
2011-12-01 23:47 roklenardic Modules => Core
2011-12-13 10:10 jonalegriaesarte Assigned To jonalegriaesarte => jecharri
2011-12-13 10:35 psarobe Note Added: 0043814
2011-12-13 10:37 psarobe Web browser Google Chrome => Google Chrome
2011-12-13 10:37 psarobe Severity minor => major
2011-12-13 10:41 psarobe Note Edited: 0043814 View Revisions
2011-12-13 12:29 iciordia Assigned To jecharri => marvintm
2011-12-13 19:09 hgbot Checkin
2011-12-13 19:09 hgbot Note Added: 0043856
2011-12-13 19:09 hgbot Status new => resolved
2011-12-13 19:09 hgbot Resolution open => fixed
2011-12-13 19:09 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9c987c6e8bc83dc3ef27308783844ce812965669 [^]
2011-12-13 19:33 hgbot Checkin
2011-12-13 19:33 hgbot Note Added: 0043857
2011-12-14 10:27 marvintm Note Added: 0043860
2011-12-14 10:27 marvintm Status resolved => new
2011-12-14 10:27 marvintm Resolution fixed => open
2011-12-14 11:55 hgbot Checkin
2011-12-14 11:55 hgbot Note Added: 0043871
2011-12-14 11:55 hgbot Status new => resolved
2011-12-14 11:55 hgbot Resolution open => fixed
2011-12-14 11:55 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/9c987c6e8bc83dc3ef27308783844ce812965669 [^] => http://code.openbravo.com/erp/devel/pi/rev/439027d73f6bf9fb85b6fa920ebe2d97717cda6e [^]
2011-12-17 03:07 hudsonbot Checkin
2011-12-17 03:07 hudsonbot Note Added: 0043916
2011-12-17 03:07 hudsonbot Checkin
2011-12-17 03:07 hudsonbot Note Added: 0043917
2011-12-17 03:07 hudsonbot Checkin
2011-12-17 03:07 hudsonbot Note Added: 0043921
2011-12-22 09:25 alostale Note Added: 0044002
2011-12-22 09:25 alostale Status resolved => closed
2011-12-22 09:25 alostale Fixed in Version => 3.0MP7
2012-01-10 18:34 marvintm Relationship added related to 0019455

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker