Openbravo Issue Tracking System - Retail Modules  | 
| View Issue Details | 
  | 
| ID | Project | Category | View Status | Date Submitted | Last Update | 
| 0035239 | Retail Modules | Web POS | public | 2017-02-13 12:25 | 2017-02-27 09:17 | 
  | 
| Reporter | adrianromero |   | 
| Assigned To | migueldejuana |   | 
| Priority | normal | Severity | major | Reproducibility | have not tried | 
| Status | closed | Resolution | fixed |   | 
| Platform |  | OS | 5 | OS Version |  | 
| Product Version |  |   | 
| Target Version |  | Fixed in Version | RR17Q2 |   | 
| Merge Request Status |  | 
| Review Assigned To | marvintm | 
| OBNetwork customer | OBPS | 
| Support ticket |  | 
| Regression level |  | 
| Regression date |  | 
| Regression introduced in release |  | 
| Regression introduced by commit |  | 
| Triggers an Emergency Pack | No | 
  | 
| Summary | 0035239: [SER-QA 2431] Complementary products does not uses *Remote products* preference | 
| Description | The complementary products do not work as a remote entity, so when there are a lot of products in the database, for example 10000. Then in the login the application tries to load 10000 of records that makes login very slow | 
| Steps To Reproduce | * Load the database with around 10000 of complementary product records 
* Login in Web POS, and observe the login takes ~ 1 minute to enter in the application | 
| Proposed Solution | Set this product as remote using the *Remote Products* preference. | 
| Additional Information |  | 
| Tags | SER-QA | 
| Relationships | | related to  | defect  | 0030025 |   | new  | Retail  | Complementary products load is too slow  |  | related to  | defect  | 0035221 |   | closed  | migueldejuana  | The order by clause on the CategoryTree master data query should be removed  |  | related to  | defect  | 0035249 |   | closed  | ranjith_qualiantech_com  | Complementary products master query does not take into account incremental refresh  |  
  | 
| Attached Files |   Issue35239.export (1,336) 2017-02-13 12:32 https://issues.openbravo.com/file_download.php?file_id=10437&type=bug
   898b94330afe.txt (4,302) 2017-02-14 17:08 https://issues.openbravo.com/file_download.php?file_id=10446&type=bug | 
  | 
| Issue History | 
| Date Modified | Username | Field | Change | 
| 2017-02-13 12:25 | adrianromero | New Issue |  | 
| 2017-02-13 12:25 | adrianromero | Assigned To |  => Retail | 
| 2017-02-13 12:25 | adrianromero | OBNetwork customer |  => Yes | 
| 2017-02-13 12:25 | adrianromero | Resolution time |  => 1488150000 | 
| 2017-02-13 12:25 | adrianromero | Triggers an Emergency Pack |  => No | 
| 2017-02-13 12:26 | adrianromero | Tag Attached: SER-QA |  | 
| 2017-02-13 12:27 | adrianromero | Relationship added | related to 0030025 | 
| 2017-02-13 12:28 | adrianromero | Relationship added | related to 0035221 | 
| 2017-02-13 12:32 | adrianromero | File Added: Issue35239.export |  | 
| 2017-02-13 17:15 | adrianromero | Relationship added | related to 0035249 | 
| 2017-02-14 17:06 | migueldejuana | Assigned To | Retail => adrianromero | 
| 2017-02-14 17:06 | migueldejuana | Status | new => scheduled | 
| 2017-02-14 17:08 | adrianromero | File Added: 898b94330afe.txt |  | 
| 2017-02-14 17:09 | adrianromero | Assigned To | adrianromero => migueldejuana | 
| 2017-02-15 17:50 | hgbot | Checkin |  | 
| 2017-02-15 17:50 | hgbot | Note Added: 0094372 |  | 
| 2017-02-15 17:50 | hgbot | Status | scheduled => resolved | 
| 2017-02-15 17:50 | hgbot | Resolution | open => fixed | 
| 2017-02-15 17:50 | hgbot | Fixed in SCM revision |  => http://code.openbravo.com/tools/automation/pi-mobile/rev/30f3c2aa9f85e4b17721fb6195cd06e69ce87509 [^] | 
| 2017-02-15 17:50 | hgbot | Checkin |  | 
| 2017-02-15 17:50 | hgbot | Note Added: 0094373 |  | 
| 2017-02-15 17:50 | hgbot | Fixed in SCM revision | http://code.openbravo.com/tools/automation/pi-mobile/rev/30f3c2aa9f85e4b17721fb6195cd06e69ce87509 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.complementary/rev/9b062730799d91bd2c588a41ca699705e51aa647 [^] | 
| 2017-02-27 09:17 | marvintm | Review Assigned To |  => marvintm | 
| 2017-02-27 09:17 | marvintm | Status | resolved => closed | 
| 2017-02-27 09:17 | marvintm | Fixed in Version |  => RR17Q2 |