Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005017Openbravo ERP02. Master data managementpublic2008-09-11 12:272008-12-09 12:38
Reporternetworkb 
Assigned ToDowid 
PriorityhighSeverityminorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version2.35MP5 
Target VersionFixed in Version2.35MP10 
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
Summary0005017: 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:17PavelPonomarevRelationship addedrelated to 0005215
2008-10-24 12:10DowidRelationship deletedrelated to 0005215
2008-11-06 15:19svnbotCheckin
2008-11-06 15:19svnbotNote Added: 0010042
2008-11-06 15:19svnbotStatusscheduled => resolved
2008-11-06 15:19svnbotResolutionopen => fixed
2008-11-06 15:19svnbotsvn_revision => 9753
2008-12-09 12:38psarobeRegression testing => No
2008-12-09 12:38psarobeStatusresolved => closed

Notes
(0010042)
svnbot   
2008-11-06 15:19   
Repository: openbravo
Revision: 9753
Author: dowid
Date: 2008-11-06 15:19:28 +0100 (Thu, 06 Nov 2008)

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

---
U branches/r2.3x/database/model/functions/BOM_PRICELIMIT.xml
U branches/r2.3x/database/model/functions/BOM_PRICELIST.xml
U branches/r2.3x/database/model/functions/BOM_PRICESTD.xml
---

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