Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0039817 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| design defect | [Openbravo ERP] I. Performance | major | have not tried | 2018-12-17 12:29 | 2019-01-15 10:41 | |||||||
| Reporter | adrianromero | View Status | public | |||||||||
| Assigned To | AtulOpenbravo | |||||||||||
| Priority | urgent | Resolution | open | Fixed in Version | ||||||||
| Status | scheduled | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | 3.0PR18Q3.2 | 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 | 0039817: Module script UpdateQtyDelivered cannot be executed due to poor performance | |||||||||||
| Description | In environments with a large amount of orders. Upgrading from 16Q4 to 18Q3.2 this module script needs to be removed in order to perform the upgrade process in the customer proposed time slot. In the testing environment for the upgrade, this module script was running for more than 12 hours before cancelling the upgrade. | |||||||||||
| Steps To Reproduce | From an Openbravo 16Q4 version and a database with a large amount of orders. Replace the sources from 16Q4 to 18Q3 and perform a build process in order to upgrade the Openbravo version. Note that the build process stops in the execution of the module script UpdateQtyDelivered select count(*) from m_inout; # 5973239 select count(*) from c_order; # 5973243 | |||||||||||
| Tags | Performance | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0108961) Sandrahuguet (developer) 2019-01-15 10:41 edited on: 2019-05-09 11:13 |
Moved to design defect, this module script is slow because it must execute a complex queries. That's why a log was added to the compilation process informing about this: https://code.openbravo.com/erp/devel/pi/file/tip/src-util/modulescript/src/org/openbravo/modulescript/UpdateQtyDelivered.java#l40 [^] As a workaround ONLY if you can't wait several hours, you can delete the module script, update your system AND [MUST BE DONE] and execute modulescript queries[1] BEFORE working in Return To Vendor Shipment. [1] https://code.openbravo.com/erp/devel/pi/file/tip/src-util/modulescript/src/org/openbravo/modulescript/UpdateQtyDelivered_data.xsql [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2018-12-17 12:29 | adrianromero | New Issue | |
| 2018-12-17 12:29 | adrianromero | Assigned To | => platform |
| 2018-12-17 12:29 | adrianromero | Modules | => Core |
| 2018-12-17 12:29 | adrianromero | Triggers an Emergency Pack | => No |
| 2018-12-17 12:29 | adrianromero | Relationship added | related to 0034612 |
| 2018-12-17 12:36 | rafaroda | Issue Monitored: rafaroda | |
| 2018-12-17 12:37 | adrianromero | Resolution time | => 1547852400 |
| 2018-12-17 12:38 | rafaroda | Relationship added | related to 0039815 |
| 2018-12-17 12:59 | alostale | Assigned To | platform => Triage Finance |
| 2018-12-17 17:15 | Sandrahuguet | Status | new => feedback |
| 2018-12-17 17:16 | Sandrahuguet | Tag Attached: Performance | |
| 2018-12-17 17:18 | adrianromero | Status | feedback => new |
| 2018-12-17 17:18 | adrianromero | Steps to Reproduce Updated | View Revisions |
| 2018-12-17 18:09 | Sandrahuguet | Assigned To | Triage Finance => AtulOpenbravo |
| 2018-12-18 06:41 | AtulOpenbravo | Status | new => scheduled |
| 2019-01-15 10:31 | Sandrahuguet | Type | defect => design defect |
| 2019-01-15 10:41 | Sandrahuguet | Note Added: 0108961 | |
| 2019-05-09 11:13 | Sandrahuguet | Note Edited: 0108961 | View Revisions |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |