Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021909Openbravo ERP09. Financial managementpublic2012-10-11 11:502012-10-23 18:06
Reportershuehner 
Assigned Toeduardo_Argal 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP15.1 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Topramakrishnan
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021909: ModuleScript UpdateRecordID2Value can take a very long time, every time it is ran
DescriptionThat modulescript can take a very long time for it's execution.

In one concrete environment it takes ca. 5minutes to execute it.

Also it does take a similar amount of time every time it is ran, not just the first time.
Steps To ReproduceUse instance with a bigger amount of data in the tables important to the modulescript
run update.database several times and observe timing output related to that modulescript.
Proposed Solution- Check & fix the code which should make it take less time after the first run
- Check & try to improve general performance of that script
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 00219443.0MP18 closed dmiguelez The modulescript UpdateRecordId2Value takes long to be executed having many values 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-11 11:50shuehnerNew Issue
2012-10-11 11:50shuehnerAssigned To => eduardo_Argal
2012-10-11 11:50shuehnerModules => Core
2012-10-11 11:50shuehnerOBNetwork customer => No
2012-10-16 16:42dmiguelezRelationship addedhas duplicate 0021944
2012-10-17 08:57hgbotCheckin
2012-10-17 08:57hgbotNote Added: 0053405
2012-10-17 08:57hgbotStatusnew => resolved
2012-10-17 08:57hgbotResolutionopen => fixed
2012-10-17 08:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cf5827841b25b5da839055f3b6546ca6e54f30a3 [^]
2012-10-18 17:46hudsonbotCheckin
2012-10-18 17:46hudsonbotNote Added: 0053473
2012-10-23 18:06pramakrishnanReview Assigned To => pramakrishnan
2012-10-23 18:06pramakrishnanNote Added: 0053582
2012-10-23 18:06pramakrishnanStatusresolved => closed

Notes
(0053405)
hgbot   
2012-10-17 08:57   
Repository: erp/devel/pi
Changeset: cf5827841b25b5da839055f3b6546ca6e54f30a3
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed Oct 17 08:57:02 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cf5827841b25b5da839055f3b6546ca6e54f30a3 [^]

Fixes issue 21909. Checks previously if there are affected records.

---
M modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/UpdateRecordId2Value.class
M modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/UpdateRecordId2ValueData.class
M modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/UpdateRecordId2Value.java
M modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/UpdateRecordId2Value_data.xsql
M modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/src/org/openbravo/advpaymentmngt/modulescript/UpdateRecordId2ValueData.java
---
(0053473)
hudsonbot   
2012-10-18 17:46   
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/81ae03c9fdbb [^]

Maturity status: Test
(0053582)
pramakrishnan   
2012-10-23 18:06   
Code Review + Testing - OK