Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0035312 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | minor | random | 2017-02-20 17:38 | 2017-04-28 09:29 | |||
| Reporter | migueldejuana | View Status | public | |||||
| Assigned To | rqueralta | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | RR17Q3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 1a3ccb3274b2 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | guilleaer | |||||||
| OBNetwork customer | No | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0035312: [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 Reproduce | N/A | |||||||
| Proposed Solution | See 35191 issue for product query and apply it on the other queries. It is needed to order by a unique constraint. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0096042) hgbot (developer) 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 (developer) 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 --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2017-02-20 17:38 | migueldejuana | New Issue | |
| 2017-02-20 17:38 | migueldejuana | Assigned To | => Retail |
| 2017-02-20 17:38 | migueldejuana | OBNetwork customer | => No |
| 2017-02-20 17:38 | migueldejuana | Triggers an Emergency Pack | => No |
| 2017-02-20 17:38 | migueldejuana | Relationship added | related to 0035191 |
| 2017-02-20 17:38 | migueldejuana | Description Updated | View Revisions |
| 2017-04-04 20:33 | rqueralta | Assigned To | Retail => rqueralta |
| 2017-04-17 16:15 | hgbot | Checkin | |
| 2017-04-17 16:15 | hgbot | Note Added: 0096042 | |
| 2017-04-17 16:15 | hgbot | Status | new => resolved |
| 2017-04-17 16:15 | hgbot | Resolution | open => fixed |
| 2017-04-17 16:15 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.giftcards/rev/e81ac6b2a34d0ffec420fada93dfcdb082c332ed [^] |
| 2017-04-17 16:20 | hgbot | Checkin | |
| 2017-04-17 16:20 | hgbot | Note Added: 0096044 | |
| 2017-04-17 16:20 | hgbot | Fixed in SCM revision | http://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:29 | guilleaer | Review Assigned To | => guilleaer |
| 2017-04-28 09:29 | guilleaer | Status | resolved => closed |
| 2017-04-28 09:29 | guilleaer | Fixed in Version | => RR17Q3 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |