Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021211Openbravo ERP06. Material requirement planning (MRP)public2012-07-25 18:102012-09-01 01:03
ReporterioritzCia 
Assigned Togorkaion 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 10.04
Product Version 
Target Version3.0MP15Fixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021211: MRP performance should be improved.
DescriptionIf the MRP configuration is quite big, processing a Manufacturing Plan is a very heavy task.
Steps To Reproduce- Configure the MRP (http://wiki.openbravo.com/wiki/Material_Requirement_%28MRP%29 [^]) with many products (above 7000) for the same planner.
- Create needs for many of those products by raising the minimun stocks, selling products, raising the sales forecasts.
- Execute the manufacturing plan.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00212773.0MP15 closed marvintm CallStoredProcedure do not support procedures that do not return a value 
has duplicate defect 00212703.0MP15 closed gorkaion The MRP process does not finish with a big amount of data. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-07-25 18:10ioritzCiaNew Issue
2012-07-25 18:10ioritzCiaAssigned To => mirurita
2012-07-25 18:10ioritzCiaWeb browser => Google Chrome
2012-07-25 18:10ioritzCiaModules => Core
2012-08-06 08:55gorkaionRelationship addedrelated to 0021277
2012-08-06 08:56gorkaionRelationship addedhas duplicate 0021270
2012-08-06 08:56gorkaionStatusnew => scheduled
2012-08-06 08:56gorkaionAssigned Tomirurita => gorkaion
2012-08-06 08:56gorkaionfix_in_branch => pi
2012-08-06 08:57gorkaionWeb browserGoogle Chrome => Google Chrome
2012-08-06 08:57gorkaionTarget Version => 3.0MP15
2012-08-06 08:57gorkaionfix_in_branchpi =>
2012-08-08 08:55hgbotCheckin
2012-08-08 08:55hgbotNote Added: 0051156
2012-08-08 08:55hgbotCheckin
2012-08-08 08:55hgbotNote Added: 0051157
2012-08-08 08:55hgbotStatusscheduled => resolved
2012-08-08 08:55hgbotResolutionopen => fixed
2012-08-08 08:55hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6ec538cab06826757f4ebc6dc5b44a399303fc1c [^]
2012-08-31 10:37hgbotCheckin
2012-08-31 10:37hgbotNote Added: 0051700
2012-08-31 10:40dmiguelezClosed by => dmiguelez
2012-08-31 10:40dmiguelezNote Added: 0051701
2012-08-31 10:40dmiguelezStatusresolved => closed
2012-09-01 01:03hudsonbotCheckin
2012-09-01 01:03hudsonbotNote Added: 0051748

Notes
(0051156)
hgbot   
2012-08-08 08:55   
Repository: erp/devel/pi
Changeset: 095cf3f720f604e0736cb736ed3b32e956b7e260
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Tue Jul 31 17:50:39 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/095cf3f720f604e0736cb736ed3b32e956b7e260 [^]

Related to issue 21211.Replace procedure by java process.

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT.xml
M src-db/database/sourcedata/AD_PROCESS.xml
A src/org/openbravo/erpCommon/ad_actionButton/MRPManufacturingPlanProcess.java
---
(0051157)
hgbot   
2012-08-08 08:55   
Repository: erp/devel/pi
Changeset: 6ec538cab06826757f4ebc6dc5b44a399303fc1c
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Wed Aug 08 08:47:14 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6ec538cab06826757f4ebc6dc5b44a399303fc1c [^]

Fixed issue 21211.Persist ma_processplan_totalized view on temporary table.

---
M src-db/database/model/functions/MRP_RUN_EXPLODE.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_TABLE.xml
M src/org/openbravo/erpCommon/ad_actionButton/MRPManufacturingPlanProcess.java
A src-db/database/model/tables/MA_PROCESSPLAN_TOT_AUX.xml
---
(0051700)
hgbot   
2012-08-31 10:37   
Repository: erp/devel/pi
Changeset: 61c74db7ded82f670bdcead05c6f57150bf7609b
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Fri Aug 31 10:32:08 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/61c74db7ded82f670bdcead05c6f57150bf7609b [^]

Related to issue 21211: Sets fetch size for the Scrollable.

---
M src/org/openbravo/erpCommon/ad_actionButton/MRPManufacturingPlanProcess.java
---
(0051701)
dmiguelez   
2012-08-31 10:40   
Code Review + Testing OK
(0051748)
hudsonbot   
2012-09-01 01:03   
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/05b3ea484705 [^]

Maturity status: Test