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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0023412
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 04. Warehouse managementmajoralways2013-03-27 11:112014-11-14 12:56
ReporteregoitzView Statuspublic 
Assigned ToSandrahuguet 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision0b033ca5bd1b
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Topramakrishnan
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023412: 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
TagsMoved from MP26 to MP27, Performance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0025833 closedSandrahuguet API Change: remove C_RM_ORDER_PICK_EDIT_LINES and M_RESERVATION_PICK_EDIT 
causes defect 0028162 closedAtulOpenbravo Cannot modify the reservation of a sales order line if it is partially reserved and released 
causes defect 0028618 closedSandrahuguet It is possible to reserve more qty than the qty of the order 
causes defect 0027848 closedreinaldoguerra Not possible to select more than one value in fk filter drop down on Manage Stock 
causes defect 00289073.0PR15Q3 closedreinaldoguerra Cannot filter the Manage Reservation Stock pop-up of Sales Order window 
causes defect 00290033.0PR15Q2 closedreinaldoguerra Error in log when typing a wrong filter in Manage Reservation Stock pop-up 

-  Notes
(0059777)
jonalegriaesarte (reporter)
2013-06-28 14:13

 P&E needs to be moved to the new infrastructure
(0061491)
jonalegriaesarte (reporter)
2013-09-30 16:36

  Moved to MP29 but we are working on it with maximum priority
(0061918)
egoitz (developer)
2013-10-28 16:50

 Moved to mp30 but a solution is being tested
(0062212)
jonalegriaesarte (reporter)
2013-11-18 16:24

 Moved to design defect because the window needs to be rebuilt using the new infrastructure.
(0064677)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
2014-03-11 11:15

 Code Review + Testing - OK.
(0065072)
hudsonbot (developer)
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

- 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker