Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010878Openbravo ERPA. Platformpublic2009-10-06 12:442009-11-12 00:00
Reporternetworkb 
Assigned Toshuehner 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target Version2.40MP11Fixed in Version2.50MP9 
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
Summary0010878: 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.

Database PostgreSQL 8.2
Steps To Reproduce
Proposed Solution
Additional Information
Tagsmain
Relationships
depends on backport 00108832.40MP11 closed shuehner Manufacturing Plan process runs so slowly 
related to defect 0011021 closed shuehner API check build 173 fails with warnings 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-10-06 12:44networkbNew Issue
2009-10-06 12:44networkbAssigned To => rafaroda
2009-10-06 12:44networkbOBNetwork customer => Yes
2009-10-06 14:44rafarodaAssigned Torafaroda => shuehner
2009-10-06 14:44rafarodaPriorityimmediate => urgent
2009-10-06 14:44rafarodaStatusnew => scheduled
2009-10-06 14:44rafarodafix_in_branch => pi
2009-10-08 09:33networkbfix_in_branchpi =>
2009-10-08 09:33networkbDescription Updated
2009-10-08 10:37networkbTarget Version2.40MP10 => 2.40MP11
2009-10-15 12:47hgbotCheckin
2009-10-15 12:47hgbotNote Added: 0021038
2009-10-15 12:47hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a2e93631b61da12f0099201b21dd2146c567af5f [^]
2009-10-15 12:47hgbotCheckin
2009-10-15 12:47hgbotNote Added: 0021040
2009-10-15 12:47hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/a2e93631b61da12f0099201b21dd2146c567af5f [^] => http://code.openbravo.com/erp/devel/pi/rev/8654c9d09717b95f71a1ed866b4b4dbeb4576e62 [^]
2009-10-15 12:47hgbotCheckin
2009-10-15 12:47hgbotNote Added: 0021041
2009-10-15 12:47hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/8654c9d09717b95f71a1ed866b4b4dbeb4576e62 [^] => http://code.openbravo.com/erp/devel/pi/rev/8468978ce25d94f11bf5a50d1af48166fa0ef75c [^]
2009-10-16 17:54shuehnerRelationship addedrelated to 0011021
2009-10-22 14:00shuehnerStatusscheduled => resolved
2009-10-22 14:00shuehnerFixed in Version => pi
2009-10-22 14:00shuehnerResolutionopen => fixed
2009-10-22 14:00shuehnerNote Added: 0021327
2009-10-22 19:26psarobeTag Attached: main
2009-11-11 13:13arunkumarStatusresolved => closed
2009-11-11 13:13arunkumarNote Added: 0021720
2009-11-11 13:13arunkumarFixed in Versionpi => 2.50MP9
2009-11-12 00:00anonymoussf_bug_id0 => 2896287

Notes
(0021038)
hgbot   
2009-10-15 12:47   
Repository: erp/devel/pi
Changeset: a2e93631b61da12f0099201b21dd2146c567af5f
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Oct 15 12:42:48 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a2e93631b61da12f0099201b21dd2146c567af5f [^]

Issue 10878
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
---
(0021040)
hgbot   
2009-10-15 12:47   
Repository: erp/devel/pi
Changeset: 8654c9d09717b95f71a1ed866b4b4dbeb4576e62
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Oct 15 12:45:04 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8654c9d09717b95f71a1ed866b4b4dbeb4576e62 [^]

Issue 10878: 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
---
(0021041)
hgbot   
2009-10-15 12:47   
Repository: erp/devel/pi
Changeset: 8468978ce25d94f11bf5a50d1af48166fa0ef75c
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Oct 15 12:46:11 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8468978ce25d94f11bf5a50d1af48166fa0ef75c [^]

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

---
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
---
(0021327)
shuehner   
2009-10-22 14:00   
Marking as resolved with the changes already committed to pi.
(0021720)
arunkumar   
2009-11-11 13:13   
Tested & Working fine