Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035312Retail ModulesWeb POSpublic2017-02-20 17:382017-04-28 09:29
Reportermigueldejuana 
Assigned Torqueralta 
PriorityhighSeverityminorReproducibilityrandom
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR17Q3 
Merge Request Status
Review Assigned Toguilleaer
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035312: [External Modules] It is possible to have duplicated primary keys on WebSQL
Description[External Modules]
It is possible to have duplicated primary keys on WebSQL if you have a lot of products with duplicated names and an small pagination.
When the query is done it orders by name and since there are a lot that have the same value it can rely on errors in WebPOS console and losses of some record.

It will be needed to review each masterdata to ensure the proper behavior of them.
Steps To ReproduceN/A
Proposed SolutionSee 35191 issue for product query and apply it on the other queries.
It is needed to order by a unique constraint.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0035191 closed marvintm It is possible to have duplicated primary keys on WebSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-02-20 17:38migueldejuanaNew Issue
2017-02-20 17:38migueldejuanaAssigned To => Retail
2017-02-20 17:38migueldejuanaTriggers an Emergency Pack => No
2017-02-20 17:38migueldejuanaRelationship addedrelated to 0035191
2017-02-20 17:38migueldejuanaDescription Updatedbug_revision_view_page.php?rev_id=14648#r14648
2017-04-04 20:33rqueraltaAssigned ToRetail => rqueralta
2017-04-17 16:15hgbotCheckin
2017-04-17 16:15hgbotNote Added: 0096042
2017-04-17 16:15hgbotStatusnew => resolved
2017-04-17 16:15hgbotResolutionopen => fixed
2017-04-17 16:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.giftcards/rev/e81ac6b2a34d0ffec420fada93dfcdb082c332ed [^]
2017-04-17 16:20hgbotCheckin
2017-04-17 16:20hgbotNote Added: 0096044
2017-04-17 16:20hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.giftcards/rev/e81ac6b2a34d0ffec420fada93dfcdb082c332ed [^] => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.procurement/rev/1a3ccb3274b29ffc4a79c022b50fb61a1e0d5739 [^]
2017-04-28 09:29guilleaerReview Assigned To => guilleaer
2017-04-28 09:29guilleaerStatusresolved => closed
2017-04-28 09:29guilleaerFixed in Version => RR17Q3

Notes
(0096042)
hgbot   
2017-04-17 16:15   
Repository: erp/pmods/org.openbravo.retail.giftcards
Changeset: e81ac6b2a34d0ffec420fada93dfcdb082c332ed
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Tue Apr 11 13:14:23 2017 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.giftcards/rev/e81ac6b2a34d0ffec420fada93dfcdb082c332ed [^]

Fixed issue 35312: [External Modules] It is possible to have duplicated primary
keys on WebSQL

---
M src/org/openbravo/retail/giftcards/master/CashMgmtEvents.java
M src/org/openbravo/retail/giftcards/master/GiftCardReason.java
---
(0096044)
hgbot   
2017-04-17 16:20   
Repository: erp/pmods/org.openbravo.mobile.procurement
Changeset: 1a3ccb3274b29ffc4a79c022b50fb61a1e0d5739
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Tue Apr 11 13:07:25 2017 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.procurement/rev/1a3ccb3274b29ffc4a79c022b50fb61a1e0d5739 [^]

Fixed issue 35312: [External Modules] It is possible to have duplicated primary
keys on WebSQL

---
M src/org/openbravo/mobile/procurement/master/BPCategory.java
M src/org/openbravo/mobile/procurement/master/BusinessPartner.java
M src/org/openbravo/mobile/procurement/master/CategoryTree.java
M src/org/openbravo/mobile/procurement/master/Product.java
M src/org/openbravo/mobile/procurement/master/ProductCategory.java
M src/org/openbravo/mobile/procurement/master/TaxRate.java
---