Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0040553 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Modules] Advanced Warehouse Operations | major | always | 2019-04-09 10:08 | 2019-05-14 11:39 | |||
Reporter | joniturralde93 | View Status | public | |||||
Assigned To | nonofrancisco | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Regression date | ||||||||
Regression introduced by commit | ||||||||
Regression level | ||||||||
Review Assigned To | Sandrahuguet | |||||||
Regression introduced in release | ||||||||
Summary | 0040553: Put-away and confirm picking list can be very slow | |||||||
Description | Customer with potent machine has this processes working slowly. Put-away: ~10s Confirm picking list: ~21s Referenced inventory has 160 product at the moment but there will be up to 500 in the future. There were only few users in the system, but eventually there will be around 150 users, 80 of them using AWO (moving, boxing and unboxing). So this processes will probably be even slower in the future. | |||||||
Steps To Reproduce | Both in BACKEND: Confirm picking list: 1. Open window Picking list 2. Select record AWOPLST1000088 3. Execute 'Confirm Picking List' Put-Away: 1. Open window Warehouse Operations 2. Select a record that can be Put-Away. Example: Storage bin group: SHP - Shipping - SHP - Shipping - US West Coast - US West Coast, Product: Sesame Seeds 3. Execute 'Put-Away' It is internally advised that the configuration of this customer is very messy. We finally got the records to reproduce it in their test environment if needed. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0111655) hgbot (developer) 2019-05-14 11:36 |
Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations Changeset: 6fcf1ad218d8c240a989b78537197895502b624b Author: Nono Carballo <nonofce <at> gmail.com> Date: Mon May 13 13:15:57 2019 -0400 URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/6fcf1ad218d8c240a989b78537197895502b624b [^] related to issue 40553 Adds new indexes to improve performance --- M src-db/database/model/tables/OBAWO_INVPROP_LINE.xml M src-db/database/model/tables/OBAWO_TASK.xml --- |
(0111656) Sandrahuguet (developer) 2019-05-14 11:39 |
added two indexes to improve the performance although the main problem is in a client customization. |
Issue History | |||
Date Modified | Username | Field | Change |
2019-04-09 10:08 | joniturralde93 | New Issue | |
2019-04-09 10:08 | joniturralde93 | Assigned To | => Triage Finance |
2019-04-09 10:08 | joniturralde93 | Resolution time | => 1556575200 |
2019-04-10 08:41 | Sandrahuguet | Assigned To | Triage Finance => nonofrancisco |
2019-04-10 08:51 | Sandrahuguet | Assigned To | nonofrancisco => Triage Finance |
2019-04-16 09:58 | Sandrahuguet | Assigned To | Triage Finance => joniturralde93 |
2019-04-16 09:58 | Sandrahuguet | Status | new => feedback |
2019-04-23 14:10 | joniturralde93 | Resolution time | 1556575200 => 1557784800 |
2019-04-23 14:10 | joniturralde93 | Assigned To | joniturralde93 => Triage Finance |
2019-04-23 14:10 | joniturralde93 | Status | feedback => new |
2019-04-23 14:10 | joniturralde93 | Summary | Take away and confirm picking list can be very slow => Put-away and confirm picking list can be very slow |
2019-04-23 14:10 | joniturralde93 | Description Updated | View Revisions |
2019-04-23 14:10 | joniturralde93 | Steps to Reproduce Updated | View Revisions |
2019-04-23 15:06 | Sandrahuguet | Assigned To | Triage Finance => nonofrancisco |
2019-05-02 06:27 | nonofrancisco | Status | new => scheduled |
2019-05-14 11:36 | hgbot | Checkin | |
2019-05-14 11:36 | hgbot | Note Added: 0111655 | |
2019-05-14 11:39 | Sandrahuguet | Review Assigned To | => Sandrahuguet |
2019-05-14 11:39 | Sandrahuguet | Note Added: 0111656 | |
2019-05-14 11:39 | Sandrahuguet | Status | scheduled => closed |
2019-05-14 11:39 | Sandrahuguet | Resolution | open => fixed |
2022-09-06 17:18 | caristu | Category | Advance Warehouse Operations => Advanced Warehouse Operations |
Copyright © 2000 - 2009 MantisBT Group |