Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0039815 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| design defect | [Openbravo ERP] I. Performance | major | have not tried | 2018-12-17 12:22 | 2019-01-15 10:36 | |||||||
| Reporter | adrianromero | View Status | public | |||||||||
| Assigned To | markmm82 | |||||||||||
| 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 | 0039815: Module script UpdateIsCompletelyInvoiced 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 24 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 UpdateIsCompletelyInvoiced select count(*) from m_inout; # 5973239 select count(*) from c_order; # 5973243 | |||||||||||
| Tags | Performance | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||||||||||||||||
|
||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0108960) Sandrahuguet (developer) 2019-01-15 10:36 edited on: 2019-05-09 11:14 |
Moved to design defect, this module script is slow because it must execute a complex query that requires several sequencial scans on high volume tables. 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/UpdateIsCompletelyInvoiced.java#l41 [^] [^] As a workaround ONLY if you can't wait several hours, you can delete the module script, update your system AND [MUST BE DONE] execute modulescript queries [1] BEFORE working with any goods receipt/shipment or creating an invoice from a goods receipt/shipment. [1] https://code.openbravo.com/erp/devel/pi/file/tip/src-util/modulescript/src/org/openbravo/modulescript/UpdateIsCompletelyInvoiced_data.xsql [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2018-12-17 12:22 | adrianromero | New Issue | |
| 2018-12-17 12:22 | adrianromero | Assigned To | => platform |
| 2018-12-17 12:22 | adrianromero | Modules | => Core |
| 2018-12-17 12:22 | adrianromero | Triggers an Emergency Pack | => No |
| 2018-12-17 12:23 | adrianromero | Relationship added | related to 0035688 |
| 2018-12-17 12:23 | adrianromero | Relationship added | related to 0038510 |
| 2018-12-17 12:24 | adrianromero | version | => 3.0PR18Q3.2 |
| 2018-12-17 12:33 | adrianromero | Relationship deleted | related to 0035688 |
| 2018-12-17 12:34 | adrianromero | Relationship added | depends on 0035682 |
| 2018-12-17 12:36 | rafaroda | Issue Monitored: rafaroda | |
| 2018-12-17 12:36 | adrianromero | Resolution time | => 1547852400 |
| 2018-12-17 12:38 | rafaroda | Relationship added | related to 0039817 |
| 2018-12-17 13:00 | 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:17 | adrianromero | Status | feedback => new |
| 2018-12-17 17:17 | adrianromero | Steps to Reproduce Updated | View Revisions |
| 2018-12-17 18:09 | Sandrahuguet | Assigned To | Triage Finance => AtulOpenbravo |
| 2018-12-28 09:28 | Sandrahuguet | Assigned To | AtulOpenbravo => markmm82 |
| 2019-01-02 17:23 | markmm82 | Status | new => scheduled |
| 2019-01-15 10:31 | Sandrahuguet | Type | defect => design defect |
| 2019-01-15 10:36 | Sandrahuguet | Note Added: 0108960 | |
| 2019-01-15 10:37 | Sandrahuguet | Note Edited: 0108960 | View Revisions |
| 2019-05-09 11:14 | Sandrahuguet | Note Edited: 0108960 | View Revisions |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |