Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023412Openbravo ERP04. Warehouse managementpublic2013-03-27 11:112014-11-14 12:56
Reporteregoitz 
Assigned ToSandrahuguet 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Topramakrishnan
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023412: Manage Stock Pick and Execute Window does not work with large amount of data
DescriptionManage 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
TagsMoved 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 00289073.0PR15Q3 closed reinaldoguerra Cannot filter the Manage Reservation Stock pop-up of Sales Order window 
causes defect 00290033.0PR15Q2 closed reinaldoguerra Error in log when typing a wrong filter in Manage Reservation Stock pop-up 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-03-27 11:11egoitzNew Issue
2013-03-27 11:11egoitzAssigned To => dmiguelez
2013-03-27 11:11egoitzModules => Core
2013-03-27 11:11egoitzTriggers an Emergency Pack => No
2013-03-27 11:11egoitzTag Attached: Performance
2013-03-27 17:39dmiguelezAssigned Todmiguelez => jonalegriaesarte
2013-05-06 18:54jonalegriaesarteTarget Version => 3.0MP24
2013-05-13 17:33dmiguelezAssigned Tojonalegriaesarte => dmiguelez
2013-05-13 17:33dmiguelezTarget Version3.0MP24 => 3.0MP25
2013-06-28 14:13jonalegriaesarteNote Added: 0059777
2013-06-28 14:13jonalegriaesarteTarget Version3.0MP25 => 3.0MP26
2013-07-29 16:37jonalegriaesarteTarget Version3.0MP26 => 3.0MP27
2013-07-29 16:37jonalegriaesarteTag Attached: Moved from MP26 to MP27
2013-08-19 16:41jonalegriaesarteTarget Version3.0MP27 => 3.0MP28
2013-09-30 16:36jonalegriaesarteNote Added: 0061491
2013-09-30 16:36jonalegriaesarteTarget Version3.0MP28 => 3.0MP29
2013-10-28 16:50egoitzNote Added: 0061918
2013-10-28 16:50egoitzTarget Version3.0MP29 => 3.0MP30
2013-11-18 16:24jonalegriaesarteNote Added: 0062212
2013-11-18 16:24jonalegriaesarteTypedefect => design defect
2013-11-18 16:24jonalegriaesarteTarget Version3.0MP30 =>
2014-02-25 16:55SandrahuguetRelationship addedblocks 0025833
2014-02-25 16:56SandrahuguetAssigned Todmiguelez => Sandrahuguet
2014-02-28 14:54hgbotCheckin
2014-02-28 14:54hgbotNote Added: 0064677
2014-02-28 14:54hgbotStatusnew => resolved
2014-02-28 14:54hgbotResolutionopen => fixed
2014-02-28 14:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0b033ca5bd1b08e81a30cfdbab2b459549d8c17c [^]
2014-02-28 14:54hgbotCheckin
2014-02-28 14:54hgbotNote Added: 0064679
2014-02-28 14:54hgbotCheckin
2014-02-28 14:54hgbotNote Added: 0064681
2014-03-03 17:38hudsonbotCheckin
2014-03-03 17:38hudsonbotNote Added: 0064749
2014-03-03 17:38hudsonbotCheckin
2014-03-03 17:38hudsonbotNote Added: 0064751
2014-03-03 17:38hudsonbotCheckin
2014-03-03 17:38hudsonbotNote Added: 0064753
2014-03-05 13:28SandrahuguetReview Assigned To => pramakrishnan
2014-03-11 09:38hgbotCheckin
2014-03-11 09:38hgbotNote Added: 0065024
2014-03-11 11:15pramakrishnanNote Added: 0065027
2014-03-11 11:15pramakrishnanStatusresolved => closed
2014-03-12 05:19hudsonbotCheckin
2014-03-12 05:19hudsonbotNote Added: 0065072
2014-11-14 12:56ngarciaRelationship addedcauses 0028162
2015-01-15 10:36dmitry_mezentsevRelationship addedcauses 0028618
2015-03-24 18:21aferrazRelationship addedcauses 0027848
2015-03-24 18:27aferrazRelationship addedcauses 0028907
2015-03-24 18:28aferrazRelationship addedcauses 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   
Repository: erp/devel/pi
Changeset: 3e2ab0ee70e8429615dee6773f9dd478b9f7f5f8
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Mon Feb 24 16:56:34 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3e2ab0ee70e8429615dee6773f9dd478b9f7f5f8 [^]

Related to issue 23412, related to issue 25814

---
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0064749)
hudsonbot   
2014-03-03 17:38   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/8d1e52794b1e [^]
Maturity status: Test
(0064751)
hudsonbot   
2014-03-03 17:38   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/8d1e52794b1e [^]
Maturity status: Test
(0064753)
hudsonbot   
2014-03-03 17:38   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/8d1e52794b1e [^]
Maturity status: Test
(0065024)
hgbot   
2014-03-11 09:38   
Repository: erp/devel/pi
Changeset: 9a1b082f1cab1fe3fad7398e2d72dc86bff186e1
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue Mar 11 09:32:59 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/9a1b082f1cab1fe3fad7398e2d72dc86bff186e1 [^]

Related to issue 23412

---
M src/org/openbravo/common/actionhandler/ManageReservationActionHandler.java
---
(0065027)
pramakrishnan   
2014-03-11 11:15   
Code Review + Testing - OK.
(0065072)
hudsonbot   
2014-03-12 05:19   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/82d89b03cb26 [^]
Maturity status: Test