Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0032665 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Retail Modules] Web POS | major | sometimes | 2016-04-04 12:57 | 2016-04-26 13:58 | |||
| Reporter | malsasua | View Status | public | |||||
| Assigned To | ranjith_qualiantech_com | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 2f99c7e32af0 | ||||
| Projection | none | ETA | none | Target Version | RR16Q1.1 | |||
| 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 | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | migueldejuana | |||||||
| OBNetwork customer | OBPS | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0032665: order by is missing in ProductCharacteristicValue model | |||||||
| Description | In the query executed to load the model ProductCharacteristicValue, is missing a order by criteria. When this model has got more than 35.000 records, two or more requests are done to backend to retrieve the data (in batchs of 35.000 records). In some cases, the second request is returning records included in the first request. It is important that it should be checked in all models, not only ProductCharacteristicValue | |||||||
| Steps To Reproduce | it has been reproduced in postgres 9.3.4 in one instance with more than 35.000 product characteristic value: . do login error is returned: OG.Dal.insertData: model insert 'ProductCharacteristicValue': SQLError: code: 6, message: could not execute statement duet to a constraint failure (19 UNIQUE constaint failed: m_proudct_ch_value.m_product_ch_value_id); | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0085720) hgbot (developer) 2016-04-19 08:17 |
Repository: retail/backports/3.0RR16Q1.1/org.openbravo.retail.posterminal Changeset: 2f99c7e32af099705faa53fabbcc790968d7587e Author: Ranjith S R <ranjith <at> qualiantech.com> Date: Mon Apr 18 15:09:42 2016 +0530 URL: http://code.openbravo.com/retail/backports/3.0RR16Q1.1/org.openbravo.retail.posterminal/rev/2f99c7e32af099705faa53fabbcc790968d7587e [^] Fixes issue 32665 : Added missing order by clause to models --- M src/org/openbravo/retail/posterminal/master/DiscountFilterBusinessPartner.java M src/org/openbravo/retail/posterminal/master/DiscountFilterBusinessPartnerGroup.java M src/org/openbravo/retail/posterminal/master/DiscountFilterCharacteristic.java M src/org/openbravo/retail/posterminal/master/DiscountFilterProduct.java M src/org/openbravo/retail/posterminal/master/DiscountFilterProductCategory.java M src/org/openbravo/retail/posterminal/master/DiscountFilterRole.java M src/org/openbravo/retail/posterminal/master/OfferPriceList.java M src/org/openbravo/retail/posterminal/master/PriceList.java M src/org/openbravo/retail/posterminal/master/Product.java M src/org/openbravo/retail/posterminal/master/ProductBOM.java M src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java M src/org/openbravo/retail/posterminal/master/ProductPrice.java M src/org/openbravo/retail/posterminal/master/TaxCategoryBOM.java M src/org/openbravo/retail/posterminal/master/TaxZone.java M src/org/openbravo/retail/posterminal/master/TaxZoneProperties.java M src/org/openbravo/retail/posterminal/term/CashCloseReport.java --- |
|
(0085822) migueldejuana (viewer) 2016-04-21 12:19 |
Reviewed in RR16Q1.1 |
|
(0085989) hgbot (developer) 2016-04-26 13:58 |
Repository: retail/backports/3.0RR16Q1.1/org.openbravo.retail.posterminal Changeset: a724bf7cbdf86fef8c6425f27ababc37e57438ae Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Tue Apr 26 13:58:26 2016 +0200 URL: http://code.openbravo.com/retail/backports/3.0RR16Q1.1/org.openbravo.retail.posterminal/rev/a724bf7cbdf86fef8c6425f27ababc37e57438ae [^] Related to issue 32665. Reverted all models except ProductCharacteristicValue as there seems to be a problem in Oracle. --- M src/org/openbravo/retail/posterminal/master/DiscountFilterBusinessPartner.java M src/org/openbravo/retail/posterminal/master/DiscountFilterBusinessPartnerGroup.java M src/org/openbravo/retail/posterminal/master/DiscountFilterCharacteristic.java M src/org/openbravo/retail/posterminal/master/DiscountFilterProduct.java M src/org/openbravo/retail/posterminal/master/DiscountFilterProductCategory.java M src/org/openbravo/retail/posterminal/master/DiscountFilterRole.java M src/org/openbravo/retail/posterminal/master/OfferPriceList.java M src/org/openbravo/retail/posterminal/master/PriceList.java M src/org/openbravo/retail/posterminal/master/Product.java M src/org/openbravo/retail/posterminal/master/ProductBOM.java M src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java M src/org/openbravo/retail/posterminal/master/ProductPrice.java M src/org/openbravo/retail/posterminal/master/TaxCategoryBOM.java M src/org/openbravo/retail/posterminal/master/TaxZone.java M src/org/openbravo/retail/posterminal/master/TaxZoneProperties.java M src/org/openbravo/retail/posterminal/term/CashCloseReport.java --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2016-04-14 11:29 | Orekaria | Type | defect => backport |
| 2016-04-14 11:29 | Orekaria | Target Version | => RR16Q1.2 |
| 2016-04-14 12:21 | Orekaria | Target Version | RR16Q1.2 => RR16Q1.1 |
| 2016-04-19 08:17 | hgbot | Checkin | |
| 2016-04-19 08:17 | hgbot | Note Added: 0085720 | |
| 2016-04-19 08:17 | hgbot | Status | scheduled => resolved |
| 2016-04-19 08:17 | hgbot | Resolution | open => fixed |
| 2016-04-19 08:17 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/12d6c5a3c4a5b1880577e143d0e91b4b83aa2834 [^] => http://code.openbravo.com/retail/backports/3.0RR16Q1.1/org.openbravo.retail.posterminal/rev/2f99c7e32af099705faa53fabbcc790968d7587e [^] |
| 2016-04-21 12:19 | migueldejuana | Note Added: 0085822 | |
| 2016-04-21 12:20 | migueldejuana | Review Assigned To | => migueldejuana |
| 2016-04-21 12:20 | migueldejuana | Status | resolved => closed |
| 2016-04-26 13:58 | hgbot | Checkin | |
| 2016-04-26 13:58 | hgbot | Note Added: 0085989 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |