Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030218Openbravo ERP07. Sales managementpublic2015-05-26 10:042015-06-23 17:16
Reporteregoitz 
Assigned Toaferraz 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q2.3Fixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket36303
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030218: 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.0PR15Q2.3
2015-06-23 15:51dmitry_mezentsevTag Attached: Approved
2015-06-23 17:14hgbotCheckin
2015-06-23 17:14hgbotNote Added: 0078444
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.0PR15Q2.3/rev/bcb08f11e7eee059638fa8454c011d2babe8b686 [^]
2015-06-23 17:16vmromanosReview Assigned To => vmromanos
2015-06-23 17:16vmromanosNote Added: 0078450
2015-06-23 17:16vmromanosStatusresolved => closed

Notes
(0078444)
hgbot   
2015-06-23 17:14   
Repository: erp/backports/3.0PR15Q2.3
Changeset: bcb08f11e7eee059638fa8454c011d2babe8b686
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.0PR15Q2.3/rev/bcb08f11e7eee059638fa8454c011d2babe8b686 [^]

Fixes issue 30218: 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
---
(0078450)
vmromanos   
2015-06-23 17:16   
Code review + testing OK