Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0004885 | Openbravo ERP | 02. Master data management | public | 2008-09-09 16:48 | 2008-12-11 13:48 |
|
| Reporter | networkb | |
| Assigned To | Dowid | |
| Priority | immediate | Severity | minor | Reproducibility | sometimes |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | |
| Product Version | 2.35MP5 | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0004885: The BOM_PRICESTD, BOM_PRICELIMIT and BOM_PRICELIST function get an error |
| Description | When 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 Solution | Instead 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 | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0005215 | | closed | Dowid | Verify Bom button works incorrectly | | depends on | backport | 0005016 | | closed | Dowid | The BOM_PRICESTD, BOM_PRICELIMIT and BOM_PRICELIST function get an error | | depends on | backport | 0005017 | | closed | Dowid | The BOM_PRICESTD, BOM_PRICELIMIT and BOM_PRICELIST function get an error |
|
| Attached Files | |
|
| 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 | |
|
Notes |
|
|
|
|
This task should be done very carefully, because these functions are also used in the price calculation for Non BOM products. |
|
|
|
(0009755)
|
|
svnbot
|
|
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
|
|
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 [^]
|
|
|
|
|
|
cannot verify with that description |
|