Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0039438 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] Advanced Warehouse Operations | critical | always | 2018-10-11 15:51 | 2018-10-23 16:53 | |||
| Reporter | guilleaer | View Status | public | |||||
| Assigned To | guilleaer | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 5450f81489ec | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Regression date | ||||||||
| Regression introduced by commit | https://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/2ffe8a2a6f90df3af96ec7da24b8db174ed54a55 [^] | |||||||
| Regression level | Packaging and release | |||||||
| Review Assigned To | marvintm | |||||||
| Regression introduced in release | ||||||||
| Summary | 0039438: [AWOFE]Performance loading tasks is very poor | |||||||
| Description | The query executed to load user tasks is slow when grouped task is involved | |||||||
| Steps To Reproduce | Login 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 Solution | It seems that the problem is the PL function OBAWO_GETCHILDTASKMAXPRIORITY which is not using indexes. Fix it to take advantage of indexes | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
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 --- |
|
Notes |
|
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 | 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |