Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005016 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 02. Master data management | minor | sometimes | 2008-09-11 12:27 | 2008-12-18 22:19 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | Dowid | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 10372 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.35MP5 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0005016: 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. | |||||||
| 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0010041) svnbot (reporter) 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 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-09-11 12:27 | cromero | New Issue | |
| 2008-09-11 12:27 | cromero | Assigned To | => rafaroda |
| 2008-09-11 12:27 | cromero | Status | new => scheduled |
| 2008-09-11 12:29 | cromero | Priority | normal => high |
| 2008-09-17 16:04 | Dowid | Assigned To | rafaroda => Dowid |
| 2008-09-23 18:18 | PavelPonomarev | Relationship added | related to 0005215 |
| 2008-10-24 12:09 | Dowid | Relationship deleted | related to 0005215 |
| 2008-11-06 15:17 | svnbot | Checkin | |
| 2008-11-06 15:17 | svnbot | Note Added: 0010041 | |
| 2008-11-06 15:17 | svnbot | Status | scheduled => resolved |
| 2008-11-06 15:17 | svnbot | Resolution | open => fixed |
| 2008-11-06 15:17 | svnbot | svn_revision | => 9752 |
| 2008-11-20 23:02 | svnbot | Checkin | |
| 2008-11-20 23:02 | svnbot | Note Added: 0010485 | |
| 2008-11-20 23:02 | svnbot | svn_revision | 9752 => 10372 |
| 2008-12-18 22:19 | psarobe | Regression testing | => No |
| 2008-12-18 22:19 | psarobe | Status | resolved => closed |
| 2009-02-02 16:28 | rafaroda | Note Deleted: 0010485 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |