Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005016Openbravo ERP02. Master data managementpublic2008-09-11 12:272008-12-18 22:19
Reporternetworkb 
Assigned ToDowid 
PriorityhighSeverityminorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version2.35MP5 
Target VersionFixed in Version 
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
Summary0005016: 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.
Steps To Reproduce
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.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0004885 closed Dowid The BOM_PRICESTD, BOM_PRICELIMIT and BOM_PRICELIST function get an error 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-11 12:27cromeroNew Issue
2008-09-11 12:27cromeroAssigned To => rafaroda
2008-09-11 12:27cromeroStatusnew => scheduled
2008-09-11 12:29cromeroPrioritynormal => high
2008-09-17 16:04DowidAssigned Torafaroda => Dowid
2008-09-23 18:18PavelPonomarevRelationship addedrelated to 0005215
2008-10-24 12:09DowidRelationship deletedrelated to 0005215
2008-11-06 15:17svnbotCheckin
2008-11-06 15:17svnbotNote Added: 0010041
2008-11-06 15:17svnbotStatusscheduled => resolved
2008-11-06 15:17svnbotResolutionopen => fixed
2008-11-06 15:17svnbotsvn_revision => 9752
2008-11-20 23:02svnbotCheckin
2008-11-20 23:02svnbotNote Added: 0010485
2008-11-20 23:02svnbotsvn_revision9752 => 10372
2008-12-18 22:19psarobeRegression testing => No
2008-12-18 22:19psarobeStatusresolved => closed
2009-02-02 16:28rafarodaNote Deleted: 0010485

Notes
(0010041)
svnbot   
2008-11-06 15:17   
Repository: openbravo
Revision: 9752
Author: dowid
Date: 2008-11-06 15:17:22 +0100 (Thu, 06 Nov 2008)

fixed bug 0005016: The BOM_PRICESTD, BOM_PRICELIMIT and BOM_PRICELIST function get an error

---
U branches/r2.40/src-db/database/model/functions/BOM_PRICELIMIT.xml
U branches/r2.40/src-db/database/model/functions/BOM_PRICELIST.xml
U branches/r2.40/src-db/database/model/functions/BOM_PRICESTD.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9752&sc=1 [^]