Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0034458 | Retail Modules | Web POS | public | 2016-11-10 08:54 | 2017-03-07 17:22 |
|
| Reporter | malsasua | |
| Assigned To | migueldejuana | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | Community Appliance |
| Product Version | | |
| Target Version | | Fixed in Version | RR17Q1 | |
| Merge Request Status | |
| Review Assigned To | marvintm |
| OBNetwork customer | |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0034458: Error loading masterdata product, when a generic product is in more than one pricelist |
| Description | when a generic product is included in more than one pricelist, when the masterdata of entity product is loaded in the terminal, the same product is returned more than one time by the query, and error is returned:
OB.Dal.insertData: model insert 'Product'; SQLError: code: 6, message: could not execute statement due to a constaint failure (19 UNIQUE constraint failed: m_product.m_product_id); |
| Steps To Reproduce | in backoffice
. go to product window, to record: Thermal t-shirt (generic)
. go to tab price: create two new records:
pricelist: The White Valley Group Sale Price List (Opening Store)
pricelist: The White Valley Group Sale Price List Version
(see attachment)
in terminal
. do login
check console errors
|
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  prod_window.png (60,228) 2016-11-10 08:54
https://issues.openbravo.com/file_download.php?file_id=10031&type=bug
|
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2016-11-10 08:54 | malsasua | New Issue | |
| 2016-11-10 08:54 | malsasua | Assigned To | => Retail |
| 2016-11-10 08:54 | malsasua | File Added: prod_window.png | |
| 2016-11-10 08:54 | malsasua | Resolution time | => 1480374000 |
| 2016-11-10 08:54 | malsasua | Triggers an Emergency Pack | => No |
| 2016-11-30 08:47 | hgbot | Checkin | |
| 2016-11-30 08:47 | hgbot | Note Added: 0091914 | |
| 2016-11-30 08:47 | hgbot | Status | new => resolved |
| 2016-11-30 08:47 | hgbot | Resolution | open => fixed |
| 2016-11-30 08:47 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/9155193cb91c5e559c07d0675f479a4ad04e7a16 [^] |
| 2016-11-30 10:13 | migueldejuana | Assigned To | Retail => migueldejuana |
| 2016-12-05 09:36 | marvintm | Review Assigned To | => marvintm |
| 2016-12-05 09:36 | marvintm | Status | resolved => closed |
| 2016-12-05 09:36 | marvintm | Fixed in Version | => RR17Q1 |
| 2017-03-07 17:22 | Practics | Issue Monitored: Practics | |