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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0021211
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 06. Material requirement planning (MRP)majoralways2012-07-25 18:102012-09-01 01:03
ReporterioritzCiaView Statuspublic 
Assigned Togorkaion 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision6ec538cab068
ProjectionnoneETAnoneTarget Version3.0MP15
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_22
OS VersionUbuntu 10.04Database version8.4Ant version1.7.1
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0021211: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00212773.0MP15 closedmarvintm CallStoredProcedure do not support procedures that do not return a value 
has duplicate defect 00212703.0MP15 closedgorkaion The MRP process does not finish with a big amount of data. 

-  Notes
(0051156)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
2012-08-31 10:40

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

- Issue History
Date Modified Username Field Change
2012-07-25 18:10 ioritzCia New Issue
2012-07-25 18:10 ioritzCia Assigned To => mirurita
2012-07-25 18:10 ioritzCia Web browser => Google Chrome
2012-07-25 18:10 ioritzCia Modules => Core
2012-08-06 08:55 gorkaion Relationship added related to 0021277
2012-08-06 08:56 gorkaion Relationship added has duplicate 0021270
2012-08-06 08:56 gorkaion Status new => scheduled
2012-08-06 08:56 gorkaion Assigned To mirurita => gorkaion
2012-08-06 08:56 gorkaion fix_in_branch => pi
2012-08-06 08:57 gorkaion Web browser Google Chrome => Google Chrome
2012-08-06 08:57 gorkaion Target Version => 3.0MP15
2012-08-06 08:57 gorkaion fix_in_branch pi =>
2012-08-08 08:55 hgbot Checkin
2012-08-08 08:55 hgbot Note Added: 0051156
2012-08-08 08:55 hgbot Checkin
2012-08-08 08:55 hgbot Note Added: 0051157
2012-08-08 08:55 hgbot Status scheduled => resolved
2012-08-08 08:55 hgbot Resolution open => fixed
2012-08-08 08:55 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6ec538cab06826757f4ebc6dc5b44a399303fc1c [^]
2012-08-31 10:37 hgbot Checkin
2012-08-31 10:37 hgbot Note Added: 0051700
2012-08-31 10:40 dmiguelez Closed by => dmiguelez
2012-08-31 10:40 dmiguelez Note Added: 0051701
2012-08-31 10:40 dmiguelez Status resolved => closed
2012-09-01 01:03 hudsonbot Checkin
2012-09-01 01:03 hudsonbot Note Added: 0051748


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker