Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039438ModulesAdvanced Warehouse Operationspublic2018-10-11 15:512018-10-23 16:53
Reporterguilleaer 
Assigned Toguilleaer 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
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
Summary0039438: [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
Additional Information
TagsNo tags attached.
Relationships
related to defect 0040615 closed vmromanos Task loading can be very slow [Frontend] 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-10-11 15:51guilleaerNew Issue
2018-10-11 15:51guilleaerAssigned To => guilleaer
2018-10-11 15:51guilleaerRegression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/2ffe8a2a6f90df3af96ec7da24b8db174ed54a55 [^]
2018-10-11 15:51guilleaerRegression level => Packaging and release
2018-10-11 15:51guilleaerResolution time => 1539554400
2018-10-11 15:51guilleaerOBNetwork customer => Gold
2018-10-11 15:51guilleaerSummaryPerformance loading tasks is very poor => [AWOFE]Performance loading tasks is very poor
2018-10-11 16:28hgbotCheckin
2018-10-11 16:28hgbotNote Added: 0107251
2018-10-11 16:33hgbotCheckin
2018-10-11 16:33hgbotNote Added: 0107252
2018-10-15 08:19hgbotCheckin
2018-10-15 08:19hgbotNote Added: 0107261
2018-10-15 08:19hgbotStatusnew => resolved
2018-10-15 08:19hgbotResolutionopen => fixed
2018-10-15 08:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/3c299cac726df5c62cc7ef505c21ad81b576bada [^]
2018-10-15 08:21hgbotCheckin
2018-10-15 08:21hgbotNote Added: 0107262
2018-10-15 08:21hgbotFixed in SCM revisionhttp://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:53marvintmReview Assigned To => marvintm
2018-10-23 16:53marvintmStatusresolved => closed
2019-05-31 12:20vmromanosRelationship addedrelated to 0040615
2022-09-06 17:18caristuCategoryAdvance Warehouse Operations => Advanced Warehouse Operations

Notes
(0107251)
hgbot   
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   
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   
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   
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
---