Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030219Openbravo ERP07. Sales managementpublic2015-05-26 10:042015-06-29 11:31
Reporteregoitz 
Assigned Toaferraz 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1.6Fixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030219: UpdatePaymentPlan modulscript takes hours to finish updating from mp31 to PR15Q2
DescriptionUpdatePaymentPlan modulscript takes hours to finish updating from mp31 to PR15Q2
Steps To ReproduceExecute the update on an environment with big amout of data.

contact ECA for a copy of the environment.
Proposed Solution
Additional Information
TagsApproved
Relationships
blocks defect 0030009 closed aferraz UpdatePaymentPlan modulscript takes hours to finish updating from mp31 to PR15Q2 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-06-22 11:44vmromanosTypedefect => backport
2015-06-22 11:44vmromanosTarget Version => 3.0PR15Q1.6
2015-06-23 15:51dmitry_mezentsevTag Attached: Approved
2015-06-23 17:14hgbotCheckin
2015-06-23 17:14hgbotNote Added: 0078446
2015-06-23 17:14hgbotStatusscheduled => resolved
2015-06-23 17:14hgbotResolutionopen => fixed
2015-06-23 17:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q1.6/rev/1437915e826057c3d549fea117b8a31aa3f364fa [^]
2015-06-23 17:16vmromanosReview Assigned To => vmromanos
2015-06-23 17:16vmromanosNote Added: 0078451
2015-06-23 17:16vmromanosStatusresolved => closed
2015-06-29 11:31eugeniIssue Monitored: eugeni

Notes
(0078446)
hgbot   
2015-06-23 17:14   
Repository: erp/backports/3.0PR15Q1.6
Changeset: 1437915e826057c3d549fea117b8a31aa3f364fa
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Mon Jun 22 18:29:20 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q1.6/rev/1437915e826057c3d549fea117b8a31aa3f364fa [^]

Fixes issue 30219: Performance problems in UpdatePaymentPlan modulscript

UpdatePaymentPlan modulscript has been changed in order to improve the performance.
Now a select will be done to get wrong records, and then they will be updated inside a loop.

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdatePaymentPlan.class
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdatePaymentPlanData.class
M src-util/modulescript/src/org/openbravo/modulescript/UpdatePaymentPlan.java
M src-util/modulescript/src/org/openbravo/modulescript/UpdatePaymentPlan_data.xsql
---
(0078451)
vmromanos   
2015-06-23 17:16   
Code review + testing OK