Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0031631 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Retail Modules] Web POS | major | always | 2015-12-01 18:01 | 2016-01-28 16:56 | |||
Reporter | aaroncalero | View Status | public | |||||
Assigned To | mario_castello | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | RR16Q2 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 506e9711d2bd | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | pi | SCM revision | ||||||
Review Assigned To | marvintm | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0031631: [SERQA 443] The complementary product masterdata load generates javascript errors | |||||||
Description | Having the Complementary Products module installed: When a complementary product is defined in several pricelist versions of the price list used by the pos terminal, several javascript errors are raised when the complementary products master data is loaded in webpos. The error looks like: OB.Dal.insertData: model insert 'ComplementaryProduct'; SQLError: code: 6, message: could not execute statement due to a constaint failure (19 UNIQUE constraint failed: obrecp_complementaryproduct.obrecp_complementaryproduct_id); | |||||||
Steps To Reproduce | Install the complementary products module. Assuming standard retail sampledata: Add a complementary product to a product (e.g. add the Adhesive body warmers as complementary for the Avalanche transceiver). Create a new pricelist version for the "The White Valley Group Sale Price List" price list. Add the Adhesive body warmers product to that new pricelist version. Load the webpos (it should be a full refresh/load) and verify that the previous error is raised. | |||||||
Proposed Solution | The query to load complementary products filter by the store's price list: [...]plv.priceList = '" + priceList.getId() "' and [...] It should filter by pricelist version, the same way that the Product masterdata query does. | |||||||
Tags | SER-QA | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0083274) hgbot (developer) 2016-01-13 21:42 |
Repository: erp/pmods/org.openbravo.retail.complementary Changeset: 506e9711d2bdf1e95c87f7ca538e87b572cef5f6 Author: Mario Castello <mario.castello <at> peoplewalking.com> Date: Wed Jan 13 14:42:01 2016 -0600 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.complementary/rev/506e9711d2bdf1e95c87f7ca538e87b572cef5f6 [^] Fixed issue 31631: Added validation to load complementary product masterdata --- M src/org/openbravo/retail/complementary/master/ComplementaryProducts.java M web/org.openbravo.retail.complementary/js/modelComplementaryProduct.js --- |
Issue History | |||
Date Modified | Username | Field | Change |
2015-12-01 18:01 | aaroncalero | New Issue | |
2015-12-01 18:01 | aaroncalero | Assigned To | => Retail |
2015-12-01 18:01 | aaroncalero | Resolution time | => 1450134000 |
2015-12-01 18:01 | aaroncalero | Triggers an Emergency Pack | => No |
2015-12-01 18:02 | aaroncalero | Tag Attached: SER-QA | |
2015-12-07 10:15 | Orekaria | Status | new => acknowledged |
2016-01-13 14:47 | mario_castello | Assigned To | Retail => mario_castello |
2016-01-13 15:50 | mario_castello | Status | acknowledged => scheduled |
2016-01-13 21:42 | hgbot | Checkin | |
2016-01-13 21:42 | hgbot | Note Added: 0083274 | |
2016-01-13 21:42 | hgbot | Status | scheduled => resolved |
2016-01-13 21:42 | hgbot | Resolution | open => fixed |
2016-01-13 21:42 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.complementary/rev/506e9711d2bdf1e95c87f7ca538e87b572cef5f6 [^] |
2016-01-28 16:56 | marvintm | Review Assigned To | => marvintm |
2016-01-28 16:56 | marvintm | Status | resolved => closed |
2016-01-28 16:56 | marvintm | Fixed in Version | => RR16Q2 |
Copyright © 2000 - 2009 MantisBT Group |