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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0045059
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajorhave not tried2020-09-15 20:512020-10-22 12:36
ReporterlbressanView Statuspublic 
Assigned Toinigo_lerga 
PriorityhighResolutionunable to reproduceFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0045059: 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.
TagsNo tags attached.
Attached Files? file icon Explain Plan Query Executed [^] (4,246 bytes) 2020-10-08 16:55 [Show Content]
? file icon Execution [^] (3,655,900 bytes) 2020-10-08 16:55
txt file icon Explain_Analyze_Query.txt [^] (5,274 bytes) 2020-10-09 09:34 [Show Content]
? file icon AWOzz_HighVolume.java [^] (10,695 bytes) 2020-10-09 09:44

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0123649)
dmiguelez (developer)
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 (reporter)
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 (reporter)
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

- Issue History
Date Modified Username Field Change
2020-09-15 20:51 lbressan New Issue
2020-09-15 20:51 lbressan Assigned To => Retail
2020-09-15 20:51 lbressan Resolution time => 1602108000
2020-09-15 20:51 lbressan Triggers an Emergency Pack => No
2020-09-15 22:04 eugeni Issue Monitored: eugeni
2020-10-06 08:28 marvintm Assigned To Retail => Triage Finance
2020-10-06 08:28 marvintm Project Retail Modules => Modules
2020-10-06 08:28 marvintm Project Modules => Openbravo ERP
2020-10-06 08:29 marvintm Modules => Core
2020-10-06 08:29 marvintm Category Mobile Warehouse picking => 07. Sales management
2020-10-07 15:33 inigo_lerga Assigned To Triage Finance => inigo_lerga
2020-10-07 15:34 inigo_lerga Status new => scheduled
2020-10-08 16:55 inigo_lerga File Added: Explain Plan Query Executed
2020-10-08 16:55 inigo_lerga File Added: Execution
2020-10-09 09:34 dmiguelez File Added: Explain_Analyze_Query.txt
2020-10-09 09:44 inigo_lerga File Added: AWOzz_HighVolume.java
2020-10-09 10:23 dmiguelez Review Assigned To => dmiguelez
2020-10-09 10:23 dmiguelez Note Added: 0123649
2020-10-09 10:23 dmiguelez Status scheduled => closed
2020-10-09 10:23 dmiguelez Resolution open => unable to reproduce
2020-10-22 12:28 eugeni Note Added: 0123848
2020-10-22 12:36 eugeni Note Added: 0123849


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker