Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030009Openbravo ERP07. Sales managementpublic2015-05-26 10:042015-06-24 02:56
Reporteregoitz 
Assigned Toaferraz 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed 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
Summary0030009: 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
TagsNo tags attached.
Relationships
related to defect 00288603.0PR15Q2 closed Sandrahuguet UpdatePaymentPlan modulscript takes long when updating from a version lower than q3 to q3. 
depends on backport 00302183.0PR15Q2.3 closed aferraz UpdatePaymentPlan modulscript takes hours to finish updating from mp31 to PR15Q2 
depends on backport 00302193.0PR15Q1.6 closed aferraz UpdatePaymentPlan modulscript takes hours to finish updating from mp31 to PR15Q2 
related to defect 0030007 closed aferraz Payment schedule amount incorrectly calculated when adding a payment from reconcile window to a sales order 
blocks defect 00301703.0PR15Q3 closed aferraz Generic UpdatePaymentPlan module script 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-05-26 10:04egoitzNew Issue
2015-05-26 10:04egoitzAssigned To => Triage Finance
2015-05-26 10:04egoitzOBNetwork customer => Yes
2015-05-26 10:04egoitzModules => Core
2015-05-26 10:04egoitzSupport ticket => 36303
2015-05-26 10:04egoitzResolution time => 1433023200
2015-05-26 10:04egoitzTriggers an Emergency Pack => No
2015-05-27 12:27aferrazRelationship addedrelated to 0028860
2015-05-28 10:54aferrazRelationship addedrelated to 0030007
2015-05-29 09:48aferrazAssigned ToTriage Finance => aferraz
2015-06-02 14:41aferrazStatusnew => scheduled
2015-06-12 14:48aferrazRelationship addedrelated to 0030170
2015-06-15 17:55aferrazRelationship deletedrelated to 0030170
2015-06-15 17:55aferrazRelationship addedblocks 0030170
2015-06-22 11:44vmromanosStatusscheduled => acknowledged
2015-06-22 11:44vmromanosStatusacknowledged => scheduled
2015-06-23 17:15hgbotCheckin
2015-06-23 17:15hgbotNote Added: 0078448
2015-06-23 17:15hgbotStatusscheduled => resolved
2015-06-23 17:15hgbotResolutionopen => fixed
2015-06-23 17:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/89faeb6298463816c653854cd670f9b42b20eb4c [^]
2015-06-23 17:17vmromanosReview Assigned To => vmromanos
2015-06-23 17:17vmromanosNote Added: 0078452
2015-06-23 17:17vmromanosStatusresolved => closed
2015-06-24 02:56hudsonbotCheckin
2015-06-24 02:56hudsonbotNote Added: 0078464

Notes
(0078448)
hgbot   
2015-06-23 17:15   
Repository: erp/devel/pi
Changeset: 89faeb6298463816c653854cd670f9b42b20eb4c
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Mon Jun 22 18:29:20 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/89faeb6298463816c653854cd670f9b42b20eb4c [^]

Fixes issue 30009: 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
---
(0078452)
vmromanos   
2015-06-23 17:17   
Code review + testing OK
(0078464)
hudsonbot   
2015-06-24 02:56   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/0a35ad8c7048 [^]
Maturity status: Test