Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0045059 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 07. Sales management | major | have not tried | 2020-09-15 20:51 | 2020-10-22 12:36 | |||
Reporter | lbressan | View Status | public | |||||
Assigned To | inigo_lerga | |||||||
Priority | high | Resolution | unable to reproduce | 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 | |||||||
Review Assigned To | dmiguelez | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0045059: Filtering / Sorting the Sales Order Line Picking window does not work | |||||||
Description | In 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 Reproduce | 1. 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. | |||||||
Tags | No tags attached. | |||||||
Attached Files | Explain Plan Query Executed [^] (4,246 bytes) 2020-10-08 16:55 [Show Content]
Execution [^] (3,655,900 bytes) 2020-10-08 16:55 Explain_Analyze_Query.txt [^] (5,274 bytes) 2020-10-09 09:34 [Show Content] 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 |