Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013107Openbravo ERP00. Application dictionarypublic2010-04-23 17:252010-05-18 21:43
Reporternetworkb 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP14 
Target Version2.50MP17Fixed in Version 
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
Summary0013107: Error with a Process with a parameter 'Time'
DescriptionCreate a process with a parameter, reference: time.

When you execute the process (IE. 10:00:00), the value is saved on the column p_date of the table ad_pinstance_para as "0001-01-10 00:00:00 BC".
Steps To Reproduce-As System Administrator create a new module. (Prefix: PR)
-go to Application Dictionary || Report and Process
-Create a new record:
     - Search Key: PR_process
     - Name: process.
     - Procedure: PR_process

- Go to parameter and create a new record:
     - Name: Hour
     - DB Column Name: DateFrom
     - Reference: Time

- Go to General Setup || Application || Menu
- Create a new record:
     - Action: Process and select the process created.

- Compile:
     ant smartbuild
- Restart Tomcat

- Go to the process, introduce: 10:00:00

- On the DB:

select * from ad_pinstance_para order by created desc

- Realize that the data has been saved on teh column p_date as "0001-01-10 00:00:00 BC".
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-04-23 17:25networkbNew Issue
2010-04-23 17:25networkbAssigned To => alostale
2010-04-23 17:25networkbOBNetwork customer => Yes
2010-04-26 08:32alostaleStatusnew => scheduled
2010-04-29 16:52hgbotCheckin
2010-04-29 16:52hgbotNote Added: 0026799
2010-04-29 16:52hgbotStatusscheduled => resolved
2010-04-29 16:52hgbotResolutionopen => fixed
2010-04-29 16:52hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6e98e916a1c90d5a3347d3c51a6c5e540fe17e4a [^]
2010-05-11 18:19jpabloaeTarget Version2.50MP16 => 2.50MP17
2010-05-17 11:59marvintmNote Added: 0027361
2010-05-17 11:59marvintmStatusresolved => closed
2010-05-18 00:01anonymoussf_bug_id0 => 3002958
2010-05-18 21:43hudsonbotCheckin
2010-05-18 21:43hudsonbotNote Added: 0027457

Notes
(0026799)
hgbot   
2010-04-29 16:52   
Repository: erp/devel/pi
Changeset: 6e98e916a1c90d5a3347d3c51a6c5e540fe17e4a
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Apr 29 16:52:18 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6e98e916a1c90d5a3347d3c51a6c5e540fe17e4a [^]

fixed bug 13107: Error with a Process with a parameter 'Time'

---
M src-wad/src/org/openbravo/wad/WadActionButton.java
M src-wad/src/org/openbravo/wad/controls/WADControl.java
M src-wad/src/org/openbravo/wad/controls/WADTime.java
M src/org/openbravo/erpCommon/reference/PInstanceProcess_data.xsql
---
(0027361)
marvintm   
2010-05-17 11:59   
Verified that following the steps to reproduce I get a correct time (10:00:00) as the value of the parameter.
(0027457)
hudsonbot   
2010-05-18 21:43   
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/6e98e916a1c9 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^]