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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0004885
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementminorsometimes2008-09-09 16:482008-12-11 13:48
ReporternetworkbView Statuspublic 
Assigned ToDowid 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision9239
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.35MP5SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0004885: The BOM_PRICESTD, BOM_PRICELIMIT and BOM_PRICELIST function get an error

DescriptionWhen the product that is parameter of the function is BOM and has price 0, and the products that belong to the bug also have price 0 (in the pricelist_version passed to the fuctions) you get an error because you don't have enough cursors to execute.
It happen because is a recursive function and never stop in this case.
Proposed SolutionInstead of using this line
IF(v_Price=0) THEN

use this other more restrictive


SELECT ISBOM INTO v_isBom FROM M_PRODUCT WHERE M_PRODUCT_ID=Product_ID;
    
IF(v_Price=0 AND v_isBom='Y') THEN

remember to declare v_isBom.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0005215 closedDowid Verify Bom button works incorrectly 
depends on backport 0005016 closedDowid The BOM_PRICESTD, BOM_PRICELIMIT and BOM_PRICELIST function get an error 
depends on backport 0005017 closedDowid The BOM_PRICESTD, BOM_PRICELIMIT and BOM_PRICELIST function get an error 

-  Notes
(0008994)
cromero (viewer)
2008-09-11 12:27

 This task should be done very carefully, because these functions are also used in the price calculation for Non BOM products.
(0009755)
svnbot (viewer)
2008-10-27 10:15

 Repository: openbravo
Revision: 9237
Author: dowid
Date: 2008-10-27 10:15:17 +0100 (Mon, 27 Oct 2008)

Fixed bug 0004885: The BOM_PRICESTD, BOM_PRICELIMIT and BOM_PRICELIST function get an error

---
U trunk/src-db/database/model/functions/M_BOM_PRICELIMIT.xml
U trunk/src-db/database/model/functions/M_BOM_PRICELIST.xml
U trunk/src-db/database/model/functions/M_BOM_PRICESTD.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9237&sc=1 [^]
(0009762)
svnbot (viewer)
2008-10-27 10:56

 Repository: openbravo
Revision: 9239
Author: dowid
Date: 2008-10-27 10:56:08 +0100 (Mon, 27 Oct 2008)

Fixed bug 0004885: The BOM_PRICESTD, BOM_PRICELIMIT and BOM_PRICELIST function get an error

---
U trunk/src-db/database/model/functions/M_BOM_PRICELIMIT.xml
U trunk/src-db/database/model/functions/M_BOM_PRICELIST.xml
U trunk/src-db/database/model/functions/M_BOM_PRICESTD.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9239&sc=1 [^]
(0011179)
psarobe (viewer)
2008-12-11 13:48

 cannot verify with that description

- Issue History
Date Modified Username Field Change
2008-09-09 16:48 networkb New Issue
2008-09-09 16:48 networkb Assigned To => cromero
2008-09-09 16:48 networkb sf_bug_id 0 => 2102168
2008-09-09 16:48 networkb OBNetwork customer => Yes
2008-09-09 16:48 networkb Regression testing => No
2008-09-11 12:27 cromero Status new => scheduled
2008-09-11 12:27 cromero Note Added: 0008994
2008-09-11 12:27 cromero Assigned To cromero => rafaroda
2008-09-11 12:27 cromero fix_in_branch => trunk
2008-09-11 12:28 cromero Priority normal => high
2008-09-11 12:28 cromero fix_in_branch trunk =>
2008-09-17 10:08 cromero Assigned To rafaroda => Dowid
2008-10-24 11:13 cromero Priority high => immediate
2008-10-24 12:12 Dowid Relationship added depends on 0005215
2008-10-24 12:12 Dowid Relationship deleted depends on 0005215
2008-10-24 12:13 Dowid Relationship added related to 0005215
2008-10-27 10:15 svnbot Checkin
2008-10-27 10:15 svnbot Note Added: 0009755
2008-10-27 10:15 svnbot Status scheduled => resolved
2008-10-27 10:15 svnbot Resolution open => fixed
2008-10-27 10:15 svnbot svn_revision => 9237
2008-10-27 10:56 svnbot Checkin
2008-10-27 10:56 svnbot Note Added: 0009762
2008-10-27 10:56 svnbot svn_revision 9237 => 9239
2008-12-11 13:48 psarobe Status resolved => closed
2008-12-11 13:48 psarobe Note Added: 0011179

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker