Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0034458
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2016-11-10 08:542017-03-07 17:22
ReportermalsasuaView Statuspublic 
Assigned Tomigueldejuana 
PrioritynormalResolutionfixedFixed in VersionRR17Q1
StatusclosedFix in branchFixed in SCM revision9155193cb91c
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket44334
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0034458: Error loading masterdata product, when a generic product is in more than one pricelist

Descriptionwhen 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 Reproducein 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
     
    
TagsNo tags attached.
Attached Filespng file icon prod_window.png [^] (60,228 bytes) 2016-11-10 08:54

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  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
---

- 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 OBNetwork customer => Yes
2016-11-10 08:54 malsasua Support ticket => 44334
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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker