Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016785Openbravo ERPA. Platformpublic2011-04-12 18:032011-04-15 00:00
Reporterpsarobe 
Assigned Tomtaal 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0RC6Fixed in Version3.0RC6 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016785: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00167953.0RC6 closed mtaal Several windows don't work:Goods receipt window and goods shipment don't work as an example. All fields in blank 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-04-12 18:03psarobeNew Issue
2011-04-12 18:03psarobeAssigned To => mtaal
2011-04-12 18:03psarobeModules => Core
2011-04-12 18:04psarobeStatusnew => scheduled
2011-04-12 18:04psarobefix_in_branch => pi
2011-04-12 18:05psarobefix_in_branchpi =>
2011-04-12 18:05psarobeSummaryWhen 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:52shuehnerNote Added: 0035875
2011-04-12 19:05psarobeNote Added: 0035876
2011-04-13 00:03mtaalNote Added: 0035878
2011-04-13 00:03mtaalStatusscheduled => feedback
2011-04-13 00:28psarobeNote Added: 0035880
2011-04-13 00:44psarobeNote Added: 0035882
2011-04-13 09:11psarobeStatusfeedback => scheduled
2011-04-13 09:11psarobefix_in_branch => pi
2011-04-13 11:02mtaalNote Added: 0035894
2011-04-13 11:02mtaalStatusscheduled => resolved
2011-04-13 11:02mtaalFixed in SCM revision => 11571
2011-04-13 11:02mtaalResolutionopen => fixed
2011-04-13 11:22mtaalNote Added: 0035896
2011-04-13 13:28psarobeRelationship addedrelated to 0016795
2011-04-14 11:46psarobeNote Added: 0035938
2011-04-14 11:46psarobeStatusresolved => closed
2011-04-14 11:46psarobeFixed in Version => 3.0RC6
2011-04-15 00:00anonymoussf_bug_id0 => 3286833

Notes
(0035875)
shuehner   
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   
2011-04-12 19:05   
Thanks Stefan.

https://issues.openbravo.com/view.php?id=16702 [^]
(0035878)
mtaal   
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   
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   
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   
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   
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   
2011-04-14 11:46   
Fixed