Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039817Openbravo ERPI. Performancepublic2018-12-17 12:292019-01-15 10:41
Reporteradrianromero 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version3.0PR18Q3.2 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039817: 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
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to design defect 00346123.0PR17Q1 closed vmromanos Performance problem in Return To Vendor Shipment 
related to design defect 0039815 scheduled markmm82 Module script UpdateIsCompletelyInvoiced cannot be executed due to poor performance 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-12-17 12:29adrianromeroNew Issue
2018-12-17 12:29adrianromeroAssigned To => platform
2018-12-17 12:29adrianromeroModules => Core
2018-12-17 12:29adrianromeroTriggers an Emergency Pack => No
2018-12-17 12:29adrianromeroRelationship addedrelated to 0034612
2018-12-17 12:36rafarodaIssue Monitored: rafaroda
2018-12-17 12:37adrianromeroResolution time => 1547852400
2018-12-17 12:38rafarodaRelationship addedrelated to 0039815
2018-12-17 12:59alostaleAssigned Toplatform => Triage Finance
2018-12-17 17:15SandrahuguetStatusnew => feedback
2018-12-17 17:16SandrahuguetTag Attached: Performance
2018-12-17 17:18adrianromeroStatusfeedback => new
2018-12-17 17:18adrianromeroSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=18051#r18051
2018-12-17 18:09SandrahuguetAssigned ToTriage Finance => AtulOpenbravo
2018-12-18 06:41AtulOpenbravoStatusnew => scheduled
2019-01-15 10:31SandrahuguetTypedefect => design defect
2019-01-15 10:41SandrahuguetNote Added: 0108961
2019-05-09 11:13SandrahuguetNote Edited: 0108961bug_revision_view_page.php?bugnote_id=0108961#r18743

Notes
(0108961)
Sandrahuguet   
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 [^]