Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0023412 | Openbravo ERP | 04. Warehouse management | public | 2013-03-27 11:11 | 2014-11-14 12:56 |
|
| Reporter | egoitz | |
| Assigned To | Sandrahuguet | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | pramakrishnan |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0023412: Manage Stock Pick and Execute Window does not work with large amount of data |
| Description | Manage Stock Pick and Execute Window does not work with large amount of data.
The view button Manage Reservation, from window Stock Reservation triggers M_RESERVATION_PICK_EDIT view.
This view does not show any data when large amount of data in DDBB.
These are the approximately counts of records in DDBB that is joining the query:
c_order: 550.000 records
c_orderline : 1.76 million records
m_storage_detail: 650.000 records
m_reservation: 13.000 records
m_reservation_stock: 13.000 records
m_matchpo: 750.000 records
The query runs and runs for long time and never finish. |
| Steps To Reproduce | -On an environment with data as described previosly open the Manage Stock Pick and Execute.
-The popup does not show data |
| Proposed Solution | |
| Additional Information | |
| Tags | Moved from MP26 to MP27, Performance |
| Relationships | | blocks | defect | 0025833 | | closed | Sandrahuguet | API Change: remove C_RM_ORDER_PICK_EDIT_LINES and M_RESERVATION_PICK_EDIT | | causes | defect | 0028162 | | closed | AtulOpenbravo | Cannot modify the reservation of a sales order line if it is partially reserved and released | | causes | defect | 0028618 | | closed | Sandrahuguet | It is possible to reserve more qty than the qty of the order | | causes | defect | 0027848 | | closed | reinaldoguerra | Not possible to select more than one value in fk filter drop down on Manage Stock | | causes | defect | 0028907 | 3.0PR15Q3 | closed | reinaldoguerra | Cannot filter the Manage Reservation Stock pop-up of Sales Order window | | causes | defect | 0029003 | 3.0PR15Q2 | closed | reinaldoguerra | Error in log when typing a wrong filter in Manage Reservation Stock pop-up |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2013-03-27 11:11 | egoitz | New Issue | |
| 2013-03-27 11:11 | egoitz | Assigned To | => dmiguelez |
| 2013-03-27 11:11 | egoitz | Modules | => Core |
| 2013-03-27 11:11 | egoitz | Triggers an Emergency Pack | => No |
| 2013-03-27 11:11 | egoitz | Tag Attached: Performance | |
| 2013-03-27 17:39 | dmiguelez | Assigned To | dmiguelez => jonalegriaesarte |
| 2013-05-06 18:54 | jonalegriaesarte | Target Version | => 3.0MP24 |
| 2013-05-13 17:33 | dmiguelez | Assigned To | jonalegriaesarte => dmiguelez |
| 2013-05-13 17:33 | dmiguelez | Target Version | 3.0MP24 => 3.0MP25 |
| 2013-06-28 14:13 | jonalegriaesarte | Note Added: 0059777 | |
| 2013-06-28 14:13 | jonalegriaesarte | Target Version | 3.0MP25 => 3.0MP26 |
| 2013-07-29 16:37 | jonalegriaesarte | Target Version | 3.0MP26 => 3.0MP27 |
| 2013-07-29 16:37 | jonalegriaesarte | Tag Attached: Moved from MP26 to MP27 | |
| 2013-08-19 16:41 | jonalegriaesarte | Target Version | 3.0MP27 => 3.0MP28 |
| 2013-09-30 16:36 | jonalegriaesarte | Note Added: 0061491 | |
| 2013-09-30 16:36 | jonalegriaesarte | Target Version | 3.0MP28 => 3.0MP29 |
| 2013-10-28 16:50 | egoitz | Note Added: 0061918 | |
| 2013-10-28 16:50 | egoitz | Target Version | 3.0MP29 => 3.0MP30 |
| 2013-11-18 16:24 | jonalegriaesarte | Note Added: 0062212 | |
| 2013-11-18 16:24 | jonalegriaesarte | Type | defect => design defect |
| 2013-11-18 16:24 | jonalegriaesarte | Target Version | 3.0MP30 => |
| 2014-02-25 16:55 | Sandrahuguet | Relationship added | blocks 0025833 |
| 2014-02-25 16:56 | Sandrahuguet | Assigned To | dmiguelez => Sandrahuguet |
| 2014-02-28 14:54 | hgbot | Checkin | |
| 2014-02-28 14:54 | hgbot | Note Added: 0064677 | |
| 2014-02-28 14:54 | hgbot | Status | new => resolved |
| 2014-02-28 14:54 | hgbot | Resolution | open => fixed |
| 2014-02-28 14:54 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/0b033ca5bd1b08e81a30cfdbab2b459549d8c17c [^] |
| 2014-02-28 14:54 | hgbot | Checkin | |
| 2014-02-28 14:54 | hgbot | Note Added: 0064679 | |
| 2014-02-28 14:54 | hgbot | Checkin | |
| 2014-02-28 14:54 | hgbot | Note Added: 0064681 | |
| 2014-03-03 17:38 | hudsonbot | Checkin | |
| 2014-03-03 17:38 | hudsonbot | Note Added: 0064749 | |
| 2014-03-03 17:38 | hudsonbot | Checkin | |
| 2014-03-03 17:38 | hudsonbot | Note Added: 0064751 | |
| 2014-03-03 17:38 | hudsonbot | Checkin | |
| 2014-03-03 17:38 | hudsonbot | Note Added: 0064753 | |
| 2014-03-05 13:28 | Sandrahuguet | Review Assigned To | => pramakrishnan |
| 2014-03-11 09:38 | hgbot | Checkin | |
| 2014-03-11 09:38 | hgbot | Note Added: 0065024 | |
| 2014-03-11 11:15 | pramakrishnan | Note Added: 0065027 | |
| 2014-03-11 11:15 | pramakrishnan | Status | resolved => closed |
| 2014-03-12 05:19 | hudsonbot | Checkin | |
| 2014-03-12 05:19 | hudsonbot | Note Added: 0065072 | |
| 2014-11-14 12:56 | ngarcia | Relationship added | causes 0028162 |
| 2015-01-15 10:36 | dmitry_mezentsev | Relationship added | causes 0028618 |
| 2015-03-24 18:21 | aferraz | Relationship added | causes 0027848 |
| 2015-03-24 18:27 | aferraz | Relationship added | causes 0028907 |
| 2015-03-24 18:28 | aferraz | Relationship added | causes 0029003 |
|
Notes |
|
|
(0059777)
|
|
jonalegriaesarte
|
|
2013-06-28 14:13
|
|
|
P&E needs to be moved to the new infrastructure |
|
|
|
(0061491)
|
|
jonalegriaesarte
|
|
2013-09-30 16:36
|
|
|
Moved to MP29 but we are working on it with maximum priority |
|
|
|
(0061918)
|
|
egoitz
|
|
2013-10-28 16:50
|
|
|
Moved to mp30 but a solution is being tested |
|
|
|
(0062212)
|
|
jonalegriaesarte
|
|
2013-11-18 16:24
|
|
|
Moved to design defect because the window needs to be rebuilt using the new infrastructure. |
|
|
|
(0064677)
|
|
hgbot
|
|
2014-02-28 14:54
|
|
Repository: erp/devel/pi
Changeset: 0b033ca5bd1b08e81a30cfdbab2b459549d8c17c
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Feb 20 18:24:02 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0b033ca5bd1b08e81a30cfdbab2b459549d8c17c [^]
Fixed bug 23412 Stock reservation pick&edit with manual datasource
---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_TAB.xml
M src-db/database/sourcedata/AD_TABLE.xml
M src-db/database/sourcedata/OBSERDS_DATASOURCE.xml
M src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
M src-db/database/sourcedata/OBUIAPP_PROCESS.xml
M src-db/database/sourcedata/OBUIAPP_REF_WINDOW.xml
A src/org/openbravo/common/datasource/StockReservationPickAndEditDataSource.java
R src-db/database/model/views/M_RESERVATION_PICK_EDIT.xml
---
|
|
|
|
(0064679)
|
|
hgbot
|
|
2014-02-28 14:54
|
|
Repository: erp/devel/pi
Changeset: bda5291496b89b9e1994dd8b09502eb37e617158
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri Feb 21 11:02:09 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/bda5291496b89b9e1994dd8b09502eb37e617158 [^]
Related to issue 23412, related to issue 25814
---
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_TAB.xml
M src-db/database/sourcedata/OBSERDS_DATASOURCE.xml
M src-db/database/sourcedata/OBUIAPP_PROCESS.xml
M src/org/openbravo/common/actionhandler/ManageReservationActionHandler.java
---
|
|
|
|
(0064681)
|
|
hgbot
|
|
2014-02-28 14:54
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(0065024)
|
|
hgbot
|
|
2014-03-11 09:38
|
|
|
|
|
|
|
Code Review + Testing - OK. |
|
|
|
|
|