Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010878 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2009-10-06 12:44 | 2009-11-12 00:00 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP9 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 8468978ce25d | ||||
| Projection | none | ETA | none | Target Version | 2.40MP11 | |||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0010878: Manufacturing Plan process runs so slowly | |||||||
| Description | Manufacturing 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 | |||||||
| Tags | main | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
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 |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |