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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010878
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2009-10-06 12:442009-11-12 00:00
ReporternetworkbView Statuspublic 
Assigned Toshuehner 
PriorityurgentResolutionfixedFixed in Version2.50MP9
StatusclosedFix in branchFixed in SCM revision8468978ce25d
ProjectionnoneETAnoneTarget Version2.40MP11
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010878: 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
Tagsmain
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 00108832.40MP11 closedshuehner Manufacturing Plan process runs so slowly 
related to defect 0011021 closedshuehner API check build 173 fails with warnings 

-  Notes
(0021038)
hgbot (developer)
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 (developer)
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 (developer)
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 (administrator)
2009-10-22 14:00

Marking as resolved with the changes already committed to pi.
(0021720)
arunkumar (reporter)
2009-11-11 13:13

Tested & Working fine

- Issue History
Date Modified Username Field Change
2009-10-06 12:44 networkb New Issue
2009-10-06 12:44 networkb Assigned To => rafaroda
2009-10-06 14:44 rafaroda Assigned To rafaroda => shuehner
2009-10-06 14:44 rafaroda Priority immediate => urgent
2009-10-06 14:44 rafaroda Status new => scheduled
2009-10-06 14:44 rafaroda fix_in_branch => pi
2009-10-08 09:33 networkb fix_in_branch pi =>
2009-10-08 09:33 networkb Description Updated
2009-10-08 10:37 networkb Target Version 2.40MP10 => 2.40MP11
2009-10-15 12:47 hgbot Checkin
2009-10-15 12:47 hgbot Note Added: 0021038
2009-10-15 12:47 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a2e93631b61da12f0099201b21dd2146c567af5f [^]
2009-10-15 12:47 hgbot Checkin
2009-10-15 12:47 hgbot Note Added: 0021040
2009-10-15 12:47 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/a2e93631b61da12f0099201b21dd2146c567af5f [^] => http://code.openbravo.com/erp/devel/pi/rev/8654c9d09717b95f71a1ed866b4b4dbeb4576e62 [^]
2009-10-15 12:47 hgbot Checkin
2009-10-15 12:47 hgbot Note Added: 0021041
2009-10-15 12:47 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/8654c9d09717b95f71a1ed866b4b4dbeb4576e62 [^] => http://code.openbravo.com/erp/devel/pi/rev/8468978ce25d94f11bf5a50d1af48166fa0ef75c [^]
2009-10-16 17:54 shuehner Relationship added related to 0011021
2009-10-22 14:00 shuehner Status scheduled => resolved
2009-10-22 14:00 shuehner Fixed in Version => pi
2009-10-22 14:00 shuehner Resolution open => fixed
2009-10-22 14:00 shuehner Note Added: 0021327
2009-10-22 19:26 psarobe Tag Attached: main
2009-11-11 13:13 arunkumar Status resolved => closed
2009-11-11 13:13 arunkumar Note Added: 0021720
2009-11-11 13:13 arunkumar Fixed in Version pi => 2.50MP9
2009-11-12 00:00 anonymous sf_bug_id 0 => 2896287


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker