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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0012382
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2010-02-22 12:512010-03-16 00:00
ReporternetworkbView Statuspublic 
Assigned Toiperdomo 
PriorityurgentResolutionfixedFixed in Version2.50MP14
StatusclosedFix in branchpiFixed in SCM revisiond80e35c544aa
ProjectionnoneETAnoneTarget Version2.50MP14
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP11SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012382: The ProcessReques_data.xsql file does not take into account the date format defined on the Openbravo.properties file

DescriptionThe ProcessReques_data.xsql file does not take into account the date format defined on the Openbravo.properties file.
It uses directly a date format 'DD-MM-YYY HH24:MI:SS' instead of use the date format defined.

This bug is related with other bug solved previously:
https://issues.openbravo.com/view.php?id=9202 [^]

Steps To Reproduce-Install a new application using a date format different than DD-MM-YYYY, for example
 MM-DD-YYYY.

-Create, define and schedule a new background process.

-You get the following error on the log:

90a1517b 08:53:35 [DefaultQuartzScheduler_Worker-1] ERROR org.openbravo.scheduling.ProcessRequestData - SQL error in query: UPDATE AD_Process_Request SET Updated = NOW(), Updatedby = ?, AD_User_ID = ?, Status = ?, Channel = ?, Previous_Fire_Time = TO_TIMESTAMP(?, 'DD-MM-YYYY HH24:MI:SS'), Next_Fire_Time = TO_TIMESTAMP(?, 'DD-MM-YYYY HH24:MI:SS'), Scheduled_Finish = TO_TIMESTAMP(?, 'DD-MM-YYYY HH24:MI:SS'), Ob_Context = ? WHERE AD_Process_Request_ID = ?Exception:java.sql.SQLDataException: ORA-01843: not a valid month
 
90a1517b 08:53:35 [DefaultQuartzScheduler_Worker-1] ERROR org.openbravo.scheduling.ProcessMonitor - @CODE=1843@ORA-01843: not a valid month
 
javax.servlet.ServletException: @CODE=1843@ORA-01843: not a valid month
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate defect 0012635 closediperdomo Process request: An error in the log 
related to defect 00126702.50MP14 closediperdomo In Oracle, I cannot unschedule background processes 

-  Notes
(0025175)
hgbot (developer)
2010-03-09 13:15

 Repository: erp/devel/pi
Changeset: bfe69bdc3de186d652dbd03f6525a6cd2404991d
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Tue Mar 09 13:20:12 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/bfe69bdc3de186d652dbd03f6525a6cd2404991d [^]

Fixes issue 12382: Added dateTimeFormat in db calls

---
M src/org/openbravo/scheduling/OBScheduler.java
M src/org/openbravo/scheduling/ProcessMonitor.java
M src/org/openbravo/scheduling/ProcessRequest_data.xsql
M src/org/openbravo/scheduling/ProcessRunner.java
---
(0025220)
hgbot (developer)
2010-03-10 18:48

 Repository: erp/devel/pi
Changeset: d80e35c544aacad6e2c133a1c5dcfe7347b60abd
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Wed Mar 10 18:52:56 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/d80e35c544aacad6e2c133a1c5dcfe7347b60abd [^]

Fixes 12382: Added datetime format on to_timestamp calls

---
M src-core/src/org/openbravo/base/ConfigParameters.java
M src/org/openbravo/scheduling/OBScheduler.java
M src/org/openbravo/scheduling/ProcessMonitor.java
M src/org/openbravo/scheduling/ProcessRequest_data.xsql
M src/org/openbravo/scheduling/ProcessRunner.java
---
(0025409)
hudsonbot (viewer)
2010-03-12 22:41

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/bfe69bdc3de1 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]
(0025420)
hudsonbot (viewer)
2010-03-12 22:41

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/d80e35c544aa [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]

- Issue History
Date Modified Username Field Change
2010-02-22 12:51 networkb New Issue
2010-02-22 12:51 networkb Assigned To => alostale
2010-02-22 12:51 networkb OBNetwork customer => Yes
2010-02-24 17:44 networkb Target Version => 2.50MP13
2010-02-24 17:46 iciordia Assigned To alostale => iperdomo
2010-02-24 17:52 iperdomo Status new => scheduled
2010-02-24 17:52 iperdomo fix_in_branch => pi
2010-03-08 16:06 jpabloae Target Version 2.50MP13 => 2.50MP14
2010-03-09 13:15 hgbot Checkin
2010-03-09 13:15 hgbot Note Added: 0025175
2010-03-09 13:15 hgbot Status scheduled => resolved
2010-03-09 13:15 hgbot Resolution open => fixed
2010-03-09 13:15 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bfe69bdc3de186d652dbd03f6525a6cd2404991d [^]
2010-03-09 16:01 iperdomo Status resolved => new
2010-03-09 16:01 iperdomo Resolution fixed => open
2010-03-09 16:01 iperdomo Status new => scheduled
2010-03-10 16:44 iperdomo Relationship added has duplicate 0012635
2010-03-10 18:48 hgbot Checkin
2010-03-10 18:48 hgbot Note Added: 0025220
2010-03-10 18:48 hgbot Status scheduled => resolved
2010-03-10 18:48 hgbot Resolution open => fixed
2010-03-10 18:48 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/bfe69bdc3de186d652dbd03f6525a6cd2404991d [^] => http://code.openbravo.com/erp/devel/pi/rev/d80e35c544aacad6e2c133a1c5dcfe7347b60abd [^]
2010-03-12 17:11 plujan Relationship added related to 0012670
2010-03-12 22:41 hudsonbot Checkin
2010-03-12 22:41 hudsonbot Note Added: 0025409
2010-03-12 22:41 hudsonbot Checkin
2010-03-12 22:41 hudsonbot Note Added: 0025420
2010-03-15 11:38 alostale Status resolved => closed
2010-03-15 11:38 alostale Fixed in Version => 2.50MP14
2010-03-16 00:00 anonymous sf_bug_id 0 => 2970931

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker