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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0016785
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2011-04-12 18:032011-04-15 00:00
ReporterpsarobeView Statuspublic 
Assigned Tomtaal 
PriorityimmediateResolutionfixedFixed in Version3.0RC6
StatusclosedFix in branchpiFixed in SCM revision11571
ProjectionnoneETAnoneTarget Version3.0RC6
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0016785: When a date field is being used in a call-outs, the call-out fails

DescriptionThis happens across the whole ERP.

The problem is with "getStringParameter" used for a date field.

When you type 12-04-2011 the ERP gets 2011-04-12T00:00:00 and fails

In case you use Oracle, the error that shows the log is:

"java.sql.SQLDataException: ORA-01861: literal does not match format string"
Steps To Reproduce1. Login as Openbravo/openbravo
2. Change role to QA testing Admin
3. Go to Requisition window. Click new and select Vendor A as bpartner
4. Move to lines (form view) and fill:
 4.1 Needed by date: Current system date
 4.2 Select the product rmb
Notice that "unit price" is empty. This is wrong. It should be filled with 2.00
5. If you do this other way it works:
 5.1 Select the product rmb. the call-out puts the unit price 2.00
 5.2 Put the date
The problem is because the call-out is not receiving the correct date because of the format

Another example:
1. Go to G/L Journal window. Fill the mandatory fields (description) and save
2. Go to header and change the period to Apr-11

Expected behaviour: The accounting date must change to the last date of the April and it doesn't
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00167953.0RC6 closedmtaal Several windows don't work:Goods receipt window and goods shipment don't work as an example. All fields in blank 

-  Notes
(0035875)
shuehner (administrator)
2011-04-12 18:52

Note: getStringParameter is a standard function to read any parameter. And afaik doesn'T do any formatting.

Probably the client side is just sending wrongly formatted values again, looks like js-dateformat seems to be used instead of the classic format.

Probably same/similar issue as the 'Create From'/Create Lines psa reported some days ago.
(0035876)
psarobe (manager)
2011-04-12 19:05

Thanks Stefan.

https://issues.openbravo.com/view.php?id=16702 [^]
(0035878)
mtaal (manager)
2011-04-13 00:03

Hi,
I tested this and the G/L window works fine for me.
For the requisition case, I get the message that no price list can be found for the product/date combination. I don't see an actual error in the log, did you see this?

gr. Martin
(0035880)
psarobe (manager)
2011-04-13 00:28

Hi Martin,

Requisition: Does the unit price gets filled with 2.00?

G/L journal, header tab: Does the accounting date change to the last day of April?
(0035882)
psarobe (manager)
2011-04-13 00:44

I can reproduce it in requisition window

I cannot reproduce it in G/L journal. This is crazy
(0035894)
mtaal (manager)
2011-04-13 11:02

Repository: erp/devel/pi
Changeset: 4092392748d8106f4141ec9778676837162f77a3
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Apr 13 10:59:01 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4092392748d8106f4141ec9778676837162f77a3 [^] [^]

Fixes issue 16777: Autosave is triggered when using the Create new widget from the navigation tool bar. Sales order

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/FormInitializationComponent.java
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/ob-standard-view.js
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/ob-toolbar.js
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/ob-view-form.js
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/reference/NumberUIDefinition.java
M modules/org.openbravo.userinterface.selector/web/org.openbravo.userinterface.selector/js/ob-selector-item.js
(0035896)
mtaal (manager)
2011-04-13 11:22

For testing this change also test actions from the toolbar such as complete order, copy lines, print and export, etc.
(0035938)
psarobe (manager)
2011-04-14 11:46

Fixed

- Issue History
Date Modified Username Field Change
2011-04-12 18:03 psarobe New Issue
2011-04-12 18:03 psarobe Assigned To => mtaal
2011-04-12 18:03 psarobe Modules => Core
2011-04-12 18:04 psarobe Status new => scheduled
2011-04-12 18:04 psarobe fix_in_branch => pi
2011-04-12 18:05 psarobe fix_in_branch pi =>
2011-04-12 18:05 psarobe Summary When a date field is using in call-outs, the call-out fails => When a date field is being used in a call-outs, the call-out fails
2011-04-12 18:52 shuehner Note Added: 0035875
2011-04-12 19:05 psarobe Note Added: 0035876
2011-04-13 00:03 mtaal Note Added: 0035878
2011-04-13 00:03 mtaal Status scheduled => feedback
2011-04-13 00:28 psarobe Note Added: 0035880
2011-04-13 00:44 psarobe Note Added: 0035882
2011-04-13 09:11 psarobe Status feedback => scheduled
2011-04-13 09:11 psarobe fix_in_branch => pi
2011-04-13 11:02 mtaal Note Added: 0035894
2011-04-13 11:02 mtaal Status scheduled => resolved
2011-04-13 11:02 mtaal Fixed in SCM revision => 11571
2011-04-13 11:02 mtaal Resolution open => fixed
2011-04-13 11:22 mtaal Note Added: 0035896
2011-04-13 13:28 psarobe Relationship added related to 0016795
2011-04-14 11:46 psarobe Note Added: 0035938
2011-04-14 11:46 psarobe Status resolved => closed
2011-04-14 11:46 psarobe Fixed in Version => 3.0RC6
2011-04-15 00:00 anonymous sf_bug_id 0 => 3286833


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker