Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0032580 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | sometimes | 2016-04-04 12:57 | 2016-05-17 09:33 | |||
| 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 | 8e430de95b26 | ||||
| Projection | none | ETA | none | Target Version | ||||
| 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 | 0032580: 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 |
|
|
(0085477) hgbot (developer) 2016-04-07 10:49 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 12d6c5a3c4a5b1880577e143d0e91b4b83aa2834 Author: Ranjith S R <ranjith <at> qualiantech.com> Date: Thu Apr 07 14:18:24 2016 +0530 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/12d6c5a3c4a5b1880577e143d0e91b4b83aa2834 [^] Fixes issue 32580 : Adding Order by clause in ProductCharacteristicValue --- M src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java --- |
|
(0085774) ranjith_qualiantech_com (viewer) 2016-04-20 12:05 |
Order by has to be added in other models which are missed in posterminal module |
|
(0086036) hgbot (developer) 2016-04-28 07:49 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 8e430de95b267732a649d1207414f352870f4644 Author: Ranjith S R <ranjith <at> qualiantech.com> Date: Thu Apr 28 11:16:18 2016 +0530 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/8e430de95b267732a649d1207414f352870f4644 [^] Fixes issue 32580 : 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/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/ServicePriceRule.java M src/org/openbravo/retail/posterminal/master/ServicePriceRuleRangePrices.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/ApprovalReason.java M src/org/openbravo/retail/posterminal/term/CashCloseReport.java --- |
|
(0086485) migueldejuana (viewer) 2016-05-17 09:33 |
Tested and reviewed in ec98fed2ca51 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2016-04-04 12:57 | malsasua | New Issue | |
| 2016-04-04 12:57 | malsasua | Assigned To | => Retail |
| 2016-04-04 12:57 | malsasua | OBNetwork customer | => Yes |
| 2016-04-04 12:57 | malsasua | Resolution time | => 1463608800 |
| 2016-04-04 12:57 | malsasua | Triggers an Emergency Pack | => No |
| 2016-04-04 13:52 | Orekaria | Status | new => acknowledged |
| 2016-04-06 15:19 | ranjith_qualiantech_com | Assigned To | Retail => ranjith_qualiantech_com |
| 2016-04-06 15:19 | ranjith_qualiantech_com | Status | acknowledged => scheduled |
| 2016-04-07 10:49 | hgbot | Checkin | |
| 2016-04-07 10:49 | hgbot | Note Added: 0085477 | |
| 2016-04-07 10:49 | hgbot | Status | scheduled => resolved |
| 2016-04-07 10:49 | hgbot | Resolution | open => fixed |
| 2016-04-07 10:49 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/12d6c5a3c4a5b1880577e143d0e91b4b83aa2834 [^] |
| 2016-04-13 17:11 | Orekaria | Status | resolved => new |
| 2016-04-13 17:11 | Orekaria | Resolution | fixed => open |
| 2016-04-14 11:29 | Orekaria | Status | new => scheduled |
| 2016-04-14 11:29 | Orekaria | Status | scheduled => resolved |
| 2016-04-14 11:29 | Orekaria | Resolution | open => fixed |
| 2016-04-20 12:05 | ranjith_qualiantech_com | Note Added: 0085774 | |
| 2016-04-20 12:05 | ranjith_qualiantech_com | Status | resolved => new |
| 2016-04-20 12:05 | ranjith_qualiantech_com | Resolution | fixed => open |
| 2016-04-20 12:05 | ranjith_qualiantech_com | Status | new => scheduled |
| 2016-04-28 07:49 | hgbot | Checkin | |
| 2016-04-28 07:49 | hgbot | Note Added: 0086036 | |
| 2016-04-28 07:49 | hgbot | Status | scheduled => resolved |
| 2016-04-28 07:49 | hgbot | Resolution | open => fixed |
| 2016-04-28 07:49 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/12d6c5a3c4a5b1880577e143d0e91b4b83aa2834 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/8e430de95b267732a649d1207414f352870f4644 [^] |
| 2016-05-17 09:33 | migueldejuana | Note Added: 0086485 | |
| 2016-05-17 09:33 | migueldejuana | Review Assigned To | => migueldejuana |
| 2016-05-17 09:33 | migueldejuana | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |