Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024784Openbravo ERP07. Sales managementpublic2013-09-16 18:022014-03-04 11:32
Reporteregoitz 
Assigned Topramakrishnan 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP28Fixed in Version3.0PR14Q2 
Merge Request Status
Review Assigned Toegoitz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024784: A join is missing on the selects on the UpdateTransactionBPExchangeRate modulescriopt
DescriptionPerformance problems when executing an update.database caused by the UpdateTransactionBPExchangeRate modulescript.
There are 2 selects using two tables but there is not a oin between both tables.
The methods are selectCheckBP and updateBP on the
modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/UpdateTransactionBPExchangeRate_data.xsql
file
Steps To Reproduce-Check the methods on the following file:

modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/UpdateTransactionBPExchangeRate_data.xsql
Proposed SolutionUse a join
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-09-16 18:02egoitzNew Issue
2013-09-16 18:02egoitzAssigned To => dmiguelez
2013-09-16 18:02egoitzModules => Core
2013-09-16 18:02egoitzTriggers an Emergency Pack => No
2013-09-16 18:03egoitzTag Attached: Performance
2013-09-16 18:03egoitzResolution time => 1380578400
2013-09-16 18:03egoitzTarget Version => 3.0MP28
2013-09-18 12:10dmiguelezAssigned Todmiguelez => jonalegriaesarte
2013-09-18 16:26jonalegriaesarteAssigned Tojonalegriaesarte => pramakrishnan
2013-09-23 08:27hgbotCheckin
2013-09-23 08:27hgbotNote Added: 0061336
2013-09-23 08:27hgbotStatusnew => resolved
2013-09-23 08:27hgbotResolutionopen => fixed
2013-09-23 08:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/adbac66770f0b9393c4db98c1ae9bd771e0b01f9 [^]
2013-09-23 08:29pramakrishnanNote Added: 0061337
2013-09-23 08:29pramakrishnanStatusresolved => new
2013-09-23 08:29pramakrishnanResolutionfixed => open
2013-09-23 08:30pramakrishnanReview Assigned To => egoitz
2013-09-23 08:30pramakrishnanStatusnew => scheduled
2013-09-23 08:30pramakrishnanStatusscheduled => resolved
2013-09-23 08:30pramakrishnanResolutionopen => fixed
2013-09-23 10:09egoitzNote Added: 0061344
2013-09-23 10:09egoitzStatusresolved => closed
2013-09-23 10:09egoitzFixed in Version => 3.0MP28
2013-09-24 20:10hudsonbotCheckin
2013-09-24 20:10hudsonbotNote Added: 0061375
2014-02-19 11:36egoitzNote Added: 0064347
2014-02-19 11:36egoitzStatusclosed => new
2014-02-19 11:36egoitzResolutionfixed => open
2014-02-19 11:36egoitzFixed in Version3.0MP28 =>
2014-02-19 13:27hgbotCheckin
2014-02-19 13:27hgbotNote Added: 0064358
2014-02-19 13:27hgbotStatusnew => resolved
2014-02-19 13:27hgbotResolutionopen => fixed
2014-02-19 13:27hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/adbac66770f0b9393c4db98c1ae9bd771e0b01f9 [^] => http://code.openbravo.com/erp/devel/pi/rev/4d08c67b088e1f16086d9e2741a6c06981155601 [^]
2014-02-20 16:33hudsonbotCheckin
2014-02-20 16:33hudsonbotNote Added: 0064454
2014-03-04 11:32egoitzNote Added: 0064790
2014-03-04 11:32egoitzStatusresolved => closed
2014-03-04 11:32egoitzFixed in Version => 3.0MP32

Notes
(0061336)
hgbot   
2013-09-23 08:27   
Repository: erp/devel/pi
Changeset: adbac66770f0b9393c4db98c1ae9bd771e0b01f9
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Sun Sep 22 19:12:38 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/adbac66770f0b9393c4db98c1ae9bd771e0b01f9 [^]

Fixes Issue 24784: Missing 'Join' in UpdateTransactionBPExchangeRate modulescript

---
M modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/UpdateTransactionBPExchangeRate_data.xsql
M modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/src/org/openbravo/advpaymentmngt/modulescript/UpdateTransactionBPExchangeRateData.java
---
(0061337)
pramakrishnan   
2013-09-23 08:29   
Reopened to update review assigned to
(0061344)
egoitz   
2013-09-23 10:09   
verified
(0061375)
hudsonbot   
2013-09-24 20:10   
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/af5a5f1a0fe1 [^]

Maturity status: Test
(0064347)
egoitz   
2014-02-19 11:36   
The .class files generated are missing.
It is needed to push also the class files generated using

ant compile.modulescript -Dmodule=javapackageofmodule
(0064358)
hgbot   
2014-02-19 13:27   
Repository: erp/devel/pi
Changeset: 4d08c67b088e1f16086d9e2741a6c06981155601
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Wed Feb 19 17:50:18 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/4d08c67b088e1f16086d9e2741a6c06981155601 [^]

Fixes Issue 24784: Added class file.

---
M modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/UpdateTransactionBPExchangeRateData.class
---
(0064454)
hudsonbot   
2014-02-20 16:33   
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/18b4af8b32eb [^]
Maturity status: Test
(0064790)
egoitz   
2014-03-04 11:32   
verified