Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010883Openbravo ERPA. Platformpublic2009-10-06 12:442009-11-10 12:57
Reporternetworkb 
Assigned Toshuehner 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target Version2.40MP11Fixed in Version2.40MP11 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010883: Manufacturing Plan process runs so slowly
DescriptionManufacturing Plan run so slowly to create about 47000 lines. This process runs properly, but takes so much time to finish.

Partner has updated source + code to MP9 (indexes in tables and all performance improvements done). However, the result is the same.

In order to have properly data to reproduce this bug, contact with support team (npe) in order to provide it.
Steps To Reproduce
Proposed Solution
Additional Information
Tagsmain
Relationships
blocks defect 00108782.40MP11 closed shuehner Manufacturing Plan process runs so slowly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-10-06 14:44rafarodaTypedefect => backport
2009-10-06 14:44rafarodafix_in_branch => 2.40
2009-10-13 09:33networkbTarget Version2.40MP10 => 2.40MP11
2009-10-15 13:22hgbotCheckin
2009-10-15 13:22hgbotNote Added: 0021051
2009-10-15 13:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/1f86e73e25461b3e4cc32238b17eff3a0f794a44 [^]
2009-10-15 13:22hgbotCheckin
2009-10-15 13:22hgbotNote Added: 0021053
2009-10-15 13:22hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/1f86e73e25461b3e4cc32238b17eff3a0f794a44 [^] => http://code.openbravo.com/erp/stable/2.40/rev/7d0f2b249074fef6a5808d41c48614bf0e81fa1c [^]
2009-10-15 13:22hgbotCheckin
2009-10-15 13:22hgbotNote Added: 0021054
2009-10-15 13:22hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/7d0f2b249074fef6a5808d41c48614bf0e81fa1c [^] => http://code.openbravo.com/erp/stable/2.40/rev/5406cfccff305c2ff983914caf8157ddda757377 [^]
2009-10-22 14:03shuehnerStatusscheduled => resolved
2009-10-22 14:03shuehnerResolutionopen => fixed
2009-10-22 14:03shuehnerNote Added: 0021328
2009-10-22 19:26psarobeTag Attached: main
2009-11-10 12:57arunkumarStatusresolved => closed
2009-11-10 12:57arunkumarNote Added: 0021692
2009-11-10 12:57arunkumarFixed in Version => 2.40MP11

Notes
(0021051)
hgbot   
2009-10-15 13:22   
Repository: erp/stable/2.40
Changeset: 1f86e73e25461b3e4cc32238b17eff3a0f794a44
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Oct 15 12:43:42 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/1f86e73e25461b3e4cc32238b17eff3a0f794a44 [^]

Issue 10883: Improve performance of Manufacturing Plan process
Fix logic issue introduced in issue 7406, fixing behavior and improving
the performance as originally intended.

---
M src-db/database/model/functions/MRP_RUN_EXPLODE.xml
---
(0021053)
hgbot   
2009-10-15 13:22   
Repository: erp/stable/2.40
Changeset: 7d0f2b249074fef6a5808d41c48614bf0e81fa1c
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Oct 15 12:45:02 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/7d0f2b249074fef6a5808d41c48614bf0e81fa1c [^]

Issue 10883: Improve performance of manufacturing plan process
Simplify view definition by eliminating unneeded join with
ma_processplan_version

---
M src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml
---
(0021054)
hgbot   
2009-10-15 13:22   
Repository: erp/stable/2.40
Changeset: 5406cfccff305c2ff983914caf8157ddda757377
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Oct 15 12:46:13 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/5406cfccff305c2ff983914caf8157ddda757377 [^]

Issue 10883: Improve performance of the Manufacturing Plan process
Add some needed indices

---
M src-db/database/model/tables/AD_SEQUENCE.xml
M src-db/database/model/tables/MA_PROCESSPLAN_VERSION.xml
M src-db/database/model/tables/MA_SEQUENCE.xml
M src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml
M src-db/database/model/tables/MA_WRPHASE.xml
M src-db/database/model/tables/MA_WRPHASEPRODUCT.xml
M src-db/database/model/tables/MRP_RUN_PRODUCTIONLINE.xml
M src-db/database/model/tables/MRP_RUN_PURCHASELINE.xml
---
(0021328)
shuehner   
2009-10-22 14:03   
Marking as resolved with the fixed already committed.
(0021692)
arunkumar   
2009-11-10 12:57   
Tested & Working fine.