Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030584Openbravo ERP01. General setuppublic2015-08-10 10:212015-08-20 13:45
Reportermaite 
Assigned Toaferraz 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q3.1Fixed in Version3.0PR15Q3.1 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket37781
Regression levelProduction - Confirmed Stable
Regression date2014-11-14
Regression introduced in release3.0PR15Q1
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/9eba998e1eb9 [^]
Triggers an Emergency PackNo
Summary0030584: Performance problem in "InitializeBPCurrency" modulescript
DescriptionPerformance problem in "InitializeBPCurrency" modulescript
Steps To ReproduceRelated with issue https://issues.openbravo.com/view.php?id=28076 [^] , "UpdateBpCurrency" method was included. Performance of this method in not good in case huge amount of business partners needs to be updated

In my case, query returns 35382 business partners to update (I wait for 40 minutes and still running). Contact me in case copy of this environment is required.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00305303.0PR15Q4 closed aferraz Performance problem in "InitializeBPCurrency" modulescript 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-08-14 13:31aferrazTypedefect => backport
2015-08-14 13:31aferrazTarget Version3.0PR15Q4 => 3.0PR15Q3
2015-08-18 09:55shuehnerNote Added: 0079402
2015-08-18 09:55shuehnerTarget Version3.0PR15Q3 => 3.0PR15Q3.1
2015-08-20 13:44hgbotCheckin
2015-08-20 13:44hgbotNote Added: 0079438
2015-08-20 13:44hgbotStatusscheduled => resolved
2015-08-20 13:44hgbotResolutionopen => fixed
2015-08-20 13:44hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q3.1/rev/342d80ab46405aee6f22a43feb8c7051709f4ef5 [^]
2015-08-20 13:45aferrazReview Assigned To => vmromanos
2015-08-20 13:45aferrazNote Added: 0079439
2015-08-20 13:45aferrazStatusresolved => closed
2015-08-20 13:45aferrazFixed in Version => 3.0PR15Q3.1

Notes
(0079402)
shuehner   
2015-08-18 09:55   
Move to Q3.1 as Q3 is already very late and this backport missed the last re-package and not worth to repackage just for this single issue.
(0079438)
hgbot   
2015-08-20 13:44   
Repository: erp/backports/3.0PR15Q3.1
Changeset: 342d80ab46405aee6f22a43feb8c7051709f4ef5
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri Aug 14 13:02:06 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q3.1/rev/342d80ab46405aee6f22a43feb8c7051709f4ef5 [^]

Fixes issue 30584: Performance problem in InitializeBPCurrency modulescript

Improve performance of UpdateBpCurrency method in InitializeBPCurrency modulescript.

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeBPCurrencyData.class
M src-util/modulescript/build/javasqlc/src/org/openbravo/modulescript/InitializeBPCurrencyData.java
M src-util/modulescript/src/org/openbravo/modulescript/InitializeBPCurrency_data.xsql
---
(0079439)
aferraz   
2015-08-20 13:45   
Code review and Testing OK done by vmromanos