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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0039817
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] I. Performancemajorhave not tried2018-12-17 12:292019-01-15 10:41
ReporteradrianromeroView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityurgentResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0PR18Q3.2SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0039817: Module script UpdateQtyDelivered cannot be executed due to poor performance

DescriptionIn 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 ReproduceFrom 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
TagsPerformance
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to design defect 00346123.0PR17Q1 closedvmromanos Performance problem in Return To Vendor Shipment 
related to design defect 0039815 scheduledmarkmm82 Module script UpdateIsCompletelyInvoiced cannot be executed due to poor performance 

-  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 [^]


- 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker