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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0025317
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminoralways2013-12-12 11:112014-03-11 17:04
ReporteregoitzView Statuspublic 
Assigned Tojonalegriaesarte 
PriorityhighResolutionfixedFixed in Version3.0PR14Q2
StatusclosedFix in branchFixed in SCM revisionecb94735a506
ProjectionnoneETAnoneTarget Version3.0PR14Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0025317: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0064995)
hgbot (developer)
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 (viewer)
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

- Issue History
Date Modified Username Field Change
2013-12-12 11:11 egoitz New Issue
2013-12-12 11:11 egoitz Assigned To => dmiguelez
2013-12-12 11:11 egoitz Modules => Core
2013-12-12 11:11 egoitz OBNetwork customer => Yes
2013-12-12 11:11 egoitz Support ticket => 24982
2013-12-12 11:11 egoitz Resolution time => 1389913200
2013-12-12 11:11 egoitz Triggers an Emergency Pack => No
2014-01-02 12:18 dmiguelez Assigned To dmiguelez => jonalegriaesarte
2014-03-10 18:03 hgbot Checkin
2014-03-10 18:03 hgbot Note Added: 0064995
2014-03-10 18:03 hgbot Status new => resolved
2014-03-10 18:03 hgbot Resolution open => fixed
2014-03-10 18:03 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ecb94735a506e358093b136b3093b15d1758dfa2 [^]
2014-03-10 18:05 egoitz Review Assigned To => egoitz
2014-03-10 18:05 egoitz Status resolved => closed
2014-03-10 18:05 egoitz Fixed in Version => PR14Q2
2014-03-11 17:04 hudsonbot Checkin
2014-03-11 17:04 hudsonbot Note Added: 0065052

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker