Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040553
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Advanced Warehouse Operationsmajoralways2019-04-09 10:082019-05-14 11:39
Reporterjoniturralde93View Statuspublic 
Assigned Tononofrancisco 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned ToSandrahuguet
Regression introduced in release
Summary

0040553: Put-away and confirm picking list can be very slow

DescriptionCustomer 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 ReproduceBoth 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.
TagsNo 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
Powered by Mantis Bugtracker