Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025317Openbravo ERP07. Sales managementpublic2013-12-12 11:112014-03-11 17:04
Reporteregoitz 
Assigned Tojonalegriaesarte 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q2Fixed in Version3.0PR14Q2 
Merge Request Status
Review Assigned Toegoitz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket24982
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025317: Empty error message when inserting a incorrect m_transaction line when there is not symbol for the unit of meassure
DescriptionEmpty error message when inserting a incorrect m_transaction line when there is not symbol for the unit of meassure
Steps To ReproduceCheck the trigger:
m_transaction_trg2

On the following line if the v_uom_value it does not show the error.

    RAISE EXCEPTION '%', '@CannotTakeOutReservedStock@' || ' @of@' || ' @Product@: ' || v_product_value || ', @AttributeSetInstance@: ' || COALESCE(v_attr_description, '-') || ', @UOM@: ' || v_uom_value || ' @And@'||' @StorageBin@: ' || COALESCE(v_locator_value, '-'); --OBTG:-20000--

The symbols is captured as following:

          SELECT uomsymbol
            INTO v_uom_value
          FROM C_Uom
          WHERE C_Uom_ID = NEW.c_uom_id;

It can be null because it is not mandatory on the application.
Proposed SolutionAdd a coalesce on the raise.
Previously when thaking the symbol take also the name and use the name when the symbol is null.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-12-12 11:11egoitzNew Issue
2013-12-12 11:11egoitzAssigned To => dmiguelez
2013-12-12 11:11egoitzModules => Core
2013-12-12 11:11egoitzOBNetwork customer => Yes
2013-12-12 11:11egoitzSupport ticket => 24982
2013-12-12 11:11egoitzResolution time => 1389913200
2013-12-12 11:11egoitzTriggers an Emergency Pack => No
2014-01-02 12:18dmiguelezAssigned Todmiguelez => jonalegriaesarte
2014-03-10 18:03hgbotCheckin
2014-03-10 18:03hgbotNote Added: 0064995
2014-03-10 18:03hgbotStatusnew => resolved
2014-03-10 18:03hgbotResolutionopen => fixed
2014-03-10 18:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ecb94735a506e358093b136b3093b15d1758dfa2 [^]
2014-03-10 18:05egoitzReview Assigned To => egoitz
2014-03-10 18:05egoitzStatusresolved => closed
2014-03-10 18:05egoitzFixed in Version => PR14Q2
2014-03-11 17:04hudsonbotCheckin
2014-03-11 17:04hudsonbotNote Added: 0065052

Notes
(0064995)
hgbot   
2014-03-10 18:03   
Repository: erp/devel/pi
Changeset: ecb94735a506e358093b136b3093b15d1758dfa2
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Mon Mar 10 18:02:57 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/ecb94735a506e358093b136b3093b15d1758dfa2 [^]

Fixes issue 0025317: Empty error message when inserting a incorrect
m_transaction line when there is not symbol for the unit of meassure

---
M src-db/database/model/triggers/M_TRANSACTION_TRG2.xml
---
(0065052)
hudsonbot   
2014-03-11 17:04   
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/0d35a09c7eb8 [^]
Maturity status: Test