Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045059Openbravo ERP07. Sales managementpublic2020-09-15 20:512020-10-22 12:36
Reporterlbressan 
Assigned Toinigo_lerga 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionunable to reproduce 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0045059: Filtering / Sorting the Sales Order Line Picking window does not work
DescriptionIn the standard "Sales Order Lines Picking" window (without customizations) filtering or Sorting does not work (in some cases with extreme slowness). This window allows you to generate AWO tasks for the selected order lines.
This error does not allow an agile selection of the orders to be prepared, and must be done one by one from the sales order window
Steps To Reproduce1. You need to have AWO
2. There must be dozens of orders pending to prepare
3. Enter the sale and filter it (you will see that it is not filtered or ordered)

Descriptive video attached https://drive.google.com/file/d/1yhrX8VBVScFXyA2-3v1RFlPNawbTHYYw/view [^]

IMPORTANT: It must be reproduced and tested in an environment with enough backorders (tens, between 200 to 350) for one day.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files? Explain Plan Query Executed (4,246) 2020-10-08 16:55
https://issues.openbravo.com/file_download.php?file_id=15011&type=bug
? Execution (3,655,900) 2020-10-08 16:55
https://issues.openbravo.com/file_download.php?file_id=15012&type=bug
txt Explain_Analyze_Query.txt (5,274) 2020-10-09 09:34
https://issues.openbravo.com/file_download.php?file_id=15014&type=bug
? AWOzz_HighVolume.java (10,695) 2020-10-09 09:44
https://issues.openbravo.com/file_download.php?file_id=15015&type=bug
Issue History
Date ModifiedUsernameFieldChange
2020-09-15 20:51lbressanNew Issue
2020-09-15 20:51lbressanAssigned To => Retail
2020-09-15 20:51lbressanResolution time => 1602108000
2020-09-15 20:51lbressanTriggers an Emergency Pack => No
2020-09-15 22:04eugeniIssue Monitored: eugeni
2020-10-06 08:28marvintmAssigned ToRetail => Triage Finance
2020-10-06 08:28marvintmProjectRetail Modules => Modules
2020-10-06 08:28marvintmProjectModules => Openbravo ERP
2020-10-06 08:29marvintmModules => Core
2020-10-06 08:29marvintmCategoryMobile Warehouse picking => 07. Sales management
2020-10-07 15:33inigo_lergaAssigned ToTriage Finance => inigo_lerga
2020-10-07 15:34inigo_lergaStatusnew => scheduled
2020-10-08 16:55inigo_lergaFile Added: Explain Plan Query Executed
2020-10-08 16:55inigo_lergaFile Added: Execution
2020-10-09 09:34dmiguelezFile Added: Explain_Analyze_Query.txt
2020-10-09 09:44inigo_lergaFile Added: AWOzz_HighVolume.java
2020-10-09 10:23dmiguelezReview Assigned To => dmiguelez
2020-10-09 10:23dmiguelezNote Added: 0123649
2020-10-09 10:23dmiguelezStatusscheduled => closed
2020-10-09 10:23dmiguelezResolutionopen => unable to reproduce
2020-10-22 12:28eugeniNote Added: 0123848
2020-10-22 12:36eugeniNote Added: 0123849

Notes
(0123649)
dmiguelez   
2020-10-09 10:23   
It has not been possible to reproduce the issue with the given steps.

Attached is a script that allows to create 2000 orders to reproduce the issue.
Also, a video and the explain plan is included to demonstrate that the issue is not reproducible in an standard environment.
(0123848)
eugeni   
2020-10-22 12:28   
We believe 2.000 orders is a very low number of orders for testing this issue

In our live environment:
* Last 30 days orders: 21.000 (may be relevant because there is filter in the HQL now() - 30)
* Total sales orders: 1.000.000 (may be relevant if your remove the implict filter from the view)
* Sales order pending for picking (i.ed, orders with some qty pending to be prepared): 200
(0123849)
eugeni   
2020-10-22 12:36   
Also number of lines per order might have an impact.

In our live environment:
* Last 30 days orders: 21.000 (may be relevant because there is filter in the HQL now() - 30). Average 3 lines x order = 63.000 order lines
* Total sales orders: 1.000.000 (may be relevant if you remove the implicit filter from the view) = 3.000.000 order lines
* Sales order pending for picking (i.ed, orders with some qty pending to be prepared): 200 = 600 order lines

Hope it helps,
Eugeni