Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012382Openbravo ERPA. Platformpublic2010-02-22 12:512010-03-16 00:00
Reporternetworkb 
Assigned Toiperdomo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP11 
Target Version2.50MP14Fixed in Version2.50MP14 
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
Summary0012382: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0012635 closed iperdomo Process request: An error in the log 
related to defect 00126702.50MP14 closed iperdomo In Oracle, I cannot unschedule background processes 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-22 12:51networkbNew Issue
2010-02-22 12:51networkbAssigned To => alostale
2010-02-22 12:51networkbOBNetwork customer => Yes
2010-02-24 17:44networkbTarget Version => 2.50MP13
2010-02-24 17:46iciordiaAssigned Toalostale => iperdomo
2010-02-24 17:52iperdomoStatusnew => scheduled
2010-02-24 17:52iperdomofix_in_branch => pi
2010-03-08 16:06jpabloaeTarget Version2.50MP13 => 2.50MP14
2010-03-09 13:15hgbotCheckin
2010-03-09 13:15hgbotNote Added: 0025175
2010-03-09 13:15hgbotStatusscheduled => resolved
2010-03-09 13:15hgbotResolutionopen => fixed
2010-03-09 13:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bfe69bdc3de186d652dbd03f6525a6cd2404991d [^]
2010-03-09 16:01iperdomoStatusresolved => new
2010-03-09 16:01iperdomoResolutionfixed => open
2010-03-09 16:01iperdomoStatusnew => scheduled
2010-03-10 16:44iperdomoRelationship addedhas duplicate 0012635
2010-03-10 18:48hgbotCheckin
2010-03-10 18:48hgbotNote Added: 0025220
2010-03-10 18:48hgbotStatusscheduled => resolved
2010-03-10 18:48hgbotResolutionopen => fixed
2010-03-10 18:48hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/bfe69bdc3de186d652dbd03f6525a6cd2404991d [^] => http://code.openbravo.com/erp/devel/pi/rev/d80e35c544aacad6e2c133a1c5dcfe7347b60abd [^]
2010-03-12 17:11plujanRelationship addedrelated to 0012670
2010-03-12 22:41hudsonbotCheckin
2010-03-12 22:41hudsonbotNote Added: 0025409
2010-03-12 22:41hudsonbotCheckin
2010-03-12 22:41hudsonbotNote Added: 0025420
2010-03-15 11:38alostaleStatusresolved => closed
2010-03-15 11:38alostaleFixed in Version => 2.50MP14
2010-03-16 00:00anonymoussf_bug_id0 => 2970931

Notes
(0025175)
hgbot   
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   
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   
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   
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 [^]