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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0039438
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Advanced Warehouse Operationscriticalalways2018-10-11 15:512018-10-23 16:53
ReporterguilleaerView Statuspublic 
Assigned Toguilleaer 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision5450f81489ec
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Regression date
Regression introduced by commithttps://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/2ffe8a2a6f90df3af96ec7da24b8db174ed54a55 [^]
Regression levelPackaging and release
Review Assigned Tomarvintm
Support ticket
OBNetwork customerGold
Regression introduced in release
Summary

0039438: [AWOFE]Performance loading tasks is very poor

DescriptionThe query executed to load user tasks is slow when grouped task is involved
Steps To ReproduceLogin in Openbravo
Create a purchase order
Generate reception task
Assign it to a certain user A

Using user A login in AWO FE
The process to load task is very slow or an error is shown because a timeout

Proposed SolutionIt seems that the problem is the PL function
OBAWO_GETCHILDTASKMAXPRIORITY which is not using indexes.

Fix it to take advantage of indexes
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0040615 closedvmromanos Task loading can be very slow [Frontend] 

-  Notes
(0107251)
hgbot (developer)
2018-10-11 16:28

 Repository: retail/backports/AWO/3.0RR18Q3/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: 80e118c7e8120585b600b68ee9dca8bc8d57476a
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Thu Oct 11 16:23:50 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR18Q3/org.openbravo.warehouse.advancedwarehouseoperations/rev/80e118c7e8120585b600b68ee9dca8bc8d57476a [^]

Related to issue 39438 39299: Revert changeset which creates performance problem

---
M src-db/database/model/functions/OBAWO_GETCHILDTASKMAXPRIORITY.xml
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/TaskProperties.java
---
(0107252)
hgbot (developer)
2018-10-11 16:33

 Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: 0e3b49fc3a4118f204940d20bd6ce7275d9e57a5
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Thu Oct 11 16:31:23 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/0e3b49fc3a4118f204940d20bd6ce7275d9e57a5 [^]

Related to issue 39438 39299: Revert changeset which creates performance problem

---
M src-db/database/model/functions/OBAWO_GETCHILDTASKMAXPRIORITY.xml
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/TaskProperties.java
---
(0107261)
hgbot (developer)
2018-10-15 08:19

 Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: 3c299cac726df5c62cc7ef505c21ad81b576bada
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Oct 15 08:19:44 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/3c299cac726df5c62cc7ef505c21ad81b576bada [^]

Fixed issue 39438: Adapt OBAWO_GETCHILDTASKMAXPRIORITY plsql function to take advantage of indexes

---
M src-db/database/model/functions/OBAWO_GETCHILDTASKMAXPRIORITY.xml
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/TaskProperties.java
---
(0107262)
hgbot (developer)
2018-10-15 08:21

 Repository: retail/backports/AWO/3.0RR18Q3/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: 5450f81489ecc2dd7c7132883790ca9250a7fbed
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Oct 15 08:19:44 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR18Q3/org.openbravo.warehouse.advancedwarehouseoperations/rev/5450f81489ecc2dd7c7132883790ca9250a7fbed [^]

Fixed issue 39438: Adapt OBAWO_GETCHILDTASKMAXPRIORITY plsql function to take advantage of indexes

---
M src-db/database/model/functions/OBAWO_GETCHILDTASKMAXPRIORITY.xml
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/TaskProperties.java
---

- Issue History
Date Modified Username Field Change
2018-10-11 15:51 guilleaer New Issue
2018-10-11 15:51 guilleaer Assigned To => guilleaer
2018-10-11 15:51 guilleaer Regression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/2ffe8a2a6f90df3af96ec7da24b8db174ed54a55 [^]
2018-10-11 15:51 guilleaer Regression level => Packaging and release
2018-10-11 15:51 guilleaer Resolution time => 1539554400
2018-10-11 15:51 guilleaer OBNetwork customer => Gold
2018-10-11 15:51 guilleaer Summary Performance loading tasks is very poor => [AWOFE]Performance loading tasks is very poor
2018-10-11 16:28 hgbot Checkin
2018-10-11 16:28 hgbot Note Added: 0107251
2018-10-11 16:33 hgbot Checkin
2018-10-11 16:33 hgbot Note Added: 0107252
2018-10-15 08:19 hgbot Checkin
2018-10-15 08:19 hgbot Note Added: 0107261
2018-10-15 08:19 hgbot Status new => resolved
2018-10-15 08:19 hgbot Resolution open => fixed
2018-10-15 08:19 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/3c299cac726df5c62cc7ef505c21ad81b576bada [^]
2018-10-15 08:21 hgbot Checkin
2018-10-15 08:21 hgbot Note Added: 0107262
2018-10-15 08:21 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/3c299cac726df5c62cc7ef505c21ad81b576bada [^] => http://code.openbravo.com/retail/backports/AWO/3.0RR18Q3/org.openbravo.warehouse.advancedwarehouseoperations/rev/5450f81489ecc2dd7c7132883790ca9250a7fbed [^]
2018-10-23 16:53 marvintm Review Assigned To => marvintm
2018-10-23 16:53 marvintm Status resolved => closed
2019-05-31 12:20 vmromanos Relationship added related to 0040615
2022-09-06 17:18 caristu Category Advance Warehouse Operations => Advanced Warehouse Operations

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker