Openbravo Issue Tracking System - Retail Modules | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0032664 | Retail Modules | Web POS | public | 2016-04-04 12:57 | 2016-06-09 11:58 | |||||||
| Reporter | malsasua | |||||||||||
| Assigned To | ranjith_qualiantech_com | |||||||||||
| Priority | high | Severity | major | Reproducibility | sometimes | |||||||
| Status | closed | Resolution | fixed | |||||||||
| Platform | OS | 20 | OS Version | Community Appliance | ||||||||
| Product Version | ||||||||||||
| Target Version | RR16Q2 | Fixed in Version | RR16Q2 | |||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | guilleaer | |||||||||||
| OBNetwork customer | OBPS | |||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0032664: 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); | |||||||||||
| Proposed Solution | ||||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| Issue History | ||||||||||||
| Date Modified | Username | Field | Change | |||||||||
| 2016-04-14 11:29 | Orekaria | Type | defect => backport | |||||||||
| 2016-04-14 11:29 | Orekaria | Target Version | => RR16Q2 | |||||||||
| 2016-04-19 08:17 | hgbot | Checkin | ||||||||||
| 2016-04-19 08:17 | hgbot | Note Added: 0085721 | ||||||||||
| 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.0RR16Q2/org.openbravo.retail.posterminal/rev/5fcdb09a9b8ce8fd5a593314b572132b619854de [^] | |||||||||
| 2016-05-17 17:21 | guilleaer | Review Assigned To | => guilleaer | |||||||||
| 2016-05-17 17:21 | guilleaer | Status | resolved => closed | |||||||||
| 2016-05-17 17:21 | guilleaer | Fixed in Version | => RR16Q2 | |||||||||
| 2016-06-09 11:58 | hgbot | Checkin | ||||||||||
| 2016-06-09 11:58 | hgbot | Note Added: 0087112 | ||||||||||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||