Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038121ModulesWarehouse Pickingpublic2018-03-13 15:582018-03-16 12:47
ReporterJONHM 
Assigned ToTriage Omni WMS 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
Support ticket
OBNetwork customer
Regression introduced in release
Summary0038121: Performance problem in Warehouse Picking List when cancelling a picking with >100 lines
DescriptionPerformance problem in Warehouse Picking List when cancelling a picking with >100 lines
Steps To ReproduceAsk environment to support

- Open "Warehouse Picking List" window
- Select some picking in status 'draft' and which have >100 lines:
 * PL1017459
 * PL1017457
 * PL1017456
 * PL1017455

- Press 'Cancel' button. Every line takes for about 200 ms to delete (see log)
Proposed SolutionCould be fine to add an index into M_Inoutline table
Additional Information
TagsNo tags attached.
Relationships
related to defect 0038117 closed AtulOpenbravo Performance problem in Warehouse Picking List when processing a picking with >100 lines 
Attached Fileslog sql.log (49,001) 2018-03-13 15:58
https://issues.openbravo.com/file_download.php?file_id=11647&type=bug
Issue History
Date ModifiedUsernameFieldChange
2018-03-13 15:58JONHMNew Issue
2018-03-13 15:58JONHMAssigned To => Triage Finance
2018-03-13 15:58JONHMFile Added: sql.log
2018-03-13 15:58JONHMResolution time => 1522706400
2018-03-13 17:13JONHMRelationship addedrelated to 0038117
2018-03-13 22:43jfrancesIssue Monitored: jfrances
2018-03-16 12:44aferrazReview Assigned To => aferraz
2018-03-16 12:44aferrazNote Added: 0103314
2018-03-16 12:44aferrazStatusnew => closed
2018-03-16 12:44aferrazResolutionopen => fixed
2018-03-16 12:47aferrazAssigned ToTriage Finance => aferraz
2018-03-16 12:47aferrazAssigned Toaferraz => Triage Finance

Notes
(0103314)
aferraz   
2018-03-16 12:44   
Fixed with following commit: https://code.openbravo.com/erp/devel/pi/rev/8cb1e05233d4 [^]