Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0044610 | Retail Modules | Mobile Warehouse operations | public | 2020-07-14 18:10 | 2020-08-21 09:24 |
|
| Reporter | gsuarez | |
| Assigned To | Retail | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0044610: Bad performance into the selector on PutAway Process |
| Description | The customer had been have several performance problem when they trying to filter into this selector over a warehouse with a lot of tasks rows (this around to 1.800.000). After apply the filter, the response take more than3 minutes to provide the results.
We detect the problem into the query used to filter where this try to compare the filter condition in different entities at the same time (Product, Bin and Attribute Set Instance) using the OR operator. We execute this query by each entity and we get a better performance activity in each case. |
| Steps To Reproduce | Prepare an environment with a lot of data to apply the filter (you can use the environment test of customer).
open the Mobile Warehouse Operation
open the selector where you pick the put away process.
Search for any product. |
| Proposed Solution | As workaround we change the behavior of the query to this:
Split the query doing one query for each entity, we merge the results and deleted the duplicate rows. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  TaskGeneratorLine.diff (1,825) 2020-07-14 18:12
https://issues.openbravo.com/file_download.php?file_id=14766&type=bug
StorageDetail.diff (11,958) 2020-07-14 18:13
https://issues.openbravo.com/file_download.php?file_id=14767&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2020-07-14 18:10 | gsuarez | New Issue | |
| 2020-07-14 18:10 | gsuarez | Assigned To | => Retail |
| 2020-07-14 18:10 | gsuarez | Resolution time | => 1596492000 |
| 2020-07-14 18:10 | gsuarez | Triggers an Emergency Pack | => No |
| 2020-07-14 18:12 | gsuarez | File Added: TaskGeneratorLine.diff | |
| 2020-07-14 18:13 | gsuarez | File Added: StorageDetail.diff | |
| 2020-07-14 18:16 | gsuarez | Note Added: 0121451 | |
| 2020-08-17 18:47 | guilleaer | Note Added: 0122105 | |
| 2020-08-21 09:24 | marvintm | Resolution time | 1596492000 => |
| 2020-08-21 09:24 | marvintm | Note Added: 0122229 | |
| 2020-08-21 09:24 | marvintm | Type | defect => design defect |
|
Notes |
|
|
(0121451)
|
|
gsuarez
|
|
2020-07-14 18:16
|
|
We modified the next java classes as workaround to this.
modules/org.openbravo.warehouse.advancedwarehouseoperations/src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/taskgenerationcandidates/TGC_StorageDetail_PA.java
modules/org.openbravo.warehouse.advancedwarehouseoperations/src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/classes/
replace/TaskGeneratorLine.java |
|
|
|
|
|
|
|
|
We have changed this issue to design defect. In the end, the only solution we have for these kinds of problems is to refactor the selector so that the user specifies which property he wants to filter by, like we did in the WebPOS with the customer or receipt selectors.
This change however is not trivial, and that's why we changed it to design defect. |
|