Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0034458 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | always | 2016-11-10 08:54 | 2017-03-07 17:22 | |||
| Reporter | malsasua | View Status | public | |||||
| Assigned To | migueldejuana | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | RR17Q1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 9155193cb91c | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | SCM revision | |||||||
| Review Assigned To | marvintm | |||||||
| 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  prod_window.png [^] (60,228 bytes) 2016-11-10 08:54
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0091914) hgbot (developer) 2016-11-30 08:47 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 9155193cb91c5e559c07d0675f479a4ad04e7a16 Author: Miguel de Juana <miguel.dejuana <at> openbravo.com> Date: Tue Nov 29 17:06:51 2016 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/9155193cb91c5e559c07d0675f479a4ad04e7a16 [^] Fixed issue 0034458: Error loading masterdata product, when a generic product is in more than one pricelist - Add also priceListVersion filter for generic products --- M src/org/openbravo/retail/posterminal/master/Product.java --- |
|
Notes |
|
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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |