Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026842Openbravo ERP07. Sales managementpublic2014-06-11 13:382014-12-30 23:23
Reporterjonalegriaesarte 
Assigned ToSandrahuguet 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR15Q1Fixed in Versionpi 
Merge Request Status
Review Assigned Toreinaldoguerra
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket29222
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026842: Null pointer exception in create order process in sales quotation due to changes in units
DescriptionNull pointer exception in create order process in sales quotation due to changes in units.
Steps To Reproduce- Create a product with a price
- Create sales quotation with one line including the product created
- Book it
- Change the unit of the product
- Create order in sales quotation. Process fails:
Error
java.lang.Exception: Could not execute JDBC batch update
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-06-11 13:38jonalegriaesarteNew Issue
2014-06-11 13:38jonalegriaesarteAssigned To => pramakrishnan
2014-06-11 13:38jonalegriaesarteModules => Core
2014-06-11 13:38jonalegriaesarteOBNetwork customer => Yes
2014-06-11 13:38jonalegriaesarteSupport ticket => 29222
2014-06-11 13:38jonalegriaesarteResolution time => 1408485600
2014-06-11 13:38jonalegriaesarteTriggers an Emergency Pack => No
2014-06-16 12:48jonalegriaesarteTarget VersionPR14Q3 => PR14Q4
2014-09-29 16:12jonalegriaesarteTarget Version3.0PR14Q4 => 3.0PR15Q1
2014-10-02 06:08reinaldoguerraAssigned Topramakrishnan => reinaldoguerra
2014-10-02 06:08reinaldoguerraStatusnew => scheduled
2014-10-02 06:31reinaldoguerraNote Added: 0070642
2014-10-15 16:57vmromanosAssigned Toreinaldoguerra => vmromanos
2014-10-15 16:57vmromanosReview Assigned To => reinaldoguerra
2014-10-15 17:01hgbotCheckin
2014-10-15 17:01hgbotNote Added: 0070971
2014-10-15 17:01hgbotStatusscheduled => resolved
2014-10-15 17:01hgbotResolutionopen => fixed
2014-10-15 17:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e5a0444fa6fa8f979441761a403b9477d6b46a1f [^]
2014-10-21 10:09vmromanosNote Added: 0071069
2014-10-21 10:09vmromanosStatusresolved => new
2014-10-21 10:09vmromanosResolutionfixed => open
2014-10-30 16:39SandrahuguetAssigned Tovmromanos => Sandrahuguet
2014-10-30 16:41hgbotCheckin
2014-10-30 16:41hgbotNote Added: 0071277
2014-10-30 16:41hgbotStatusnew => resolved
2014-10-30 16:41hgbotResolutionopen => fixed
2014-10-30 16:41hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/e5a0444fa6fa8f979441761a403b9477d6b46a1f [^] => http://code.openbravo.com/erp/devel/pi/rev/0d4116dbb09583b47eaf891494e96a7f30d3e55b [^]
2014-10-30 19:59reinaldoguerraStatusresolved => closed
2014-10-30 19:59reinaldoguerraFixed in Version => pi
2014-12-30 23:22hudsonbotCheckin
2014-12-30 23:22hudsonbotNote Added: 0072938
2014-12-30 23:23hudsonbotCheckin
2014-12-30 23:23hudsonbotNote Added: 0073004

Notes
(0070642)
reinaldoguerra   
2014-10-02 06:31   
Test plan used:
1- Login into Openbravo ERP with España Región Norte warehouse
2- Create a product with a price
3- Create sales quotation with one line including the product created
4- Book it
5- Change the unit of the product
6- Create order in sales quotation. Process fails:
7- The error message is now: Unit of Measure mismatch (product/transaction)
(0070971)
hgbot   
2014-10-15 17:01   
Repository: erp/devel/pi
Changeset: e5a0444fa6fa8f979441761a403b9477d6b46a1f
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Wed Oct 15 17:01:38 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e5a0444fa6fa8f979441761a403b9477d6b46a1f [^]

Fixed bug 26842: DB errors no properly parsed in ConvertQuotationIntoOrder

Database errors thrown by a trigger were not properly captured by the ConvertQuotationIntoOrder process.
We use the OBMessageUtils.translateError() method to parse the error message thrown by the Database and print it into the UI.

---
M src/org/openbravo/erpCommon/ad_process/ConvertQuotationIntoOrder.java
---
(0071069)
vmromanos   
2014-10-21 10:09   
Reopened.
The issue seems to be fixed in Oracle, but in PG it shows a very ugly error message
(0071277)
hgbot   
2014-10-30 16:41   
Repository: erp/devel/pi
Changeset: 0d4116dbb09583b47eaf891494e96a7f30d3e55b
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Oct 30 16:40:32 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0d4116dbb09583b47eaf891494e96a7f30d3e55b [^]

Fixed bug 26842 DB errors no properly parsed in ConvertQuotationIntoOrder

Use getUnderlyingSQLException to parse the exception

---
M src/org/openbravo/erpCommon/ad_process/ConvertQuotationIntoOrder.java
---
(0072938)
hudsonbot   
2014-12-30 23:22   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/6525fe229e06 [^]
Maturity status: Test
(0073004)
hudsonbot   
2014-12-30 23:23   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/6525fe229e06 [^]
Maturity status: Test