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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0031631
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2015-12-01 18:012016-01-28 16:56
ReporteraaroncaleroView Statuspublic 
Assigned Tomario_castello 
PrioritynormalResolutionfixedFixed in VersionRR16Q2
StatusclosedFix in branchFixed in SCM revision506e9711d2bd
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0031631: [SERQA 443] The complementary product masterdata load generates javascript errors

DescriptionHaving 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 ReproduceInstall 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 SolutionThe 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.
TagsSER-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
Powered by Mantis Bugtracker