Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024264Openbravo ERP09. Financial managementpublic2013-07-03 17:192013-10-24 09:00
Reporterjonalegriaesarte 
Assigned Tongarcia 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP29Fixed in Version3.0MP29 
Merge Request Status
Review Assigned Toegoitz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket22148
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024264: The c_elementvalue_trg is performing and update when it is not needed. Can cause performance issues in some cases.
DescriptionThe c_elementvalue_trg is performing and update when it is not needed. Can cause performance issues in some cases.
The update is:
UPDATE Fact_Acct SET AcctValue=:new.VALUE,AcctDescription=:new.NAME WHERE
Account_ID=:new.C_ElementValue_ID;

and it is performed always, although it is not needed.
Steps To Reproduce- Change the isactive field of a c_elementvalue
- Notice that the update is performed
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-07-03 17:19jonalegriaesarteNew Issue
2013-07-03 17:19jonalegriaesarteAssigned To => jonalegriaesarte
2013-07-03 17:19jonalegriaesarteModules => Core
2013-07-03 17:19jonalegriaesarteOBNetwork customer => Yes
2013-07-03 17:19jonalegriaesarteSupport ticket => 22148
2013-07-03 17:19jonalegriaesarteTriggers an Emergency Pack => No
2013-08-19 16:47jonalegriaesarteTarget Version3.0MP27 => 3.0MP28
2013-09-16 13:18jonalegriaesarteTarget Version3.0MP28 => 3.0MP29
2013-10-17 00:54jonalegriaesarteAssigned Tojonalegriaesarte => ngarcia
2013-10-17 17:20ngarciaSummaryThe c_element_value_trg is performing and update when it is not needed. Can cause performance issues in some cases. => The c_elementvalue_trg is performing and update when it is not needed. Can cause performance issues in some cases.
2013-10-17 17:20ngarciaDescription Updatedbug_revision_view_page.php?rev_id=5127#r5127
2013-10-17 17:20ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=5129#r5129
2013-10-22 09:21hgbotCheckin
2013-10-22 09:21hgbotNote Added: 0061836
2013-10-22 09:21hgbotStatusnew => resolved
2013-10-22 09:21hgbotResolutionopen => fixed
2013-10-22 09:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5eedba0298f0a461dcea6a5ba2a775263cf8a8b0 [^]
2013-10-22 23:42hudsonbotCheckin
2013-10-22 23:42hudsonbotNote Added: 0061856
2013-10-24 09:00egoitzReview Assigned To => egoitz
2013-10-24 09:00egoitzNote Added: 0061874
2013-10-24 09:00egoitzStatusresolved => closed
2013-10-24 09:00egoitzFixed in Version => 3.0MP29

Notes
(0061836)
hgbot   
2013-10-22 09:21   
Repository: erp/devel/pi
Changeset: 5eedba0298f0a461dcea6a5ba2a775263cf8a8b0
Author: Naiara Garcia <naiara.garcia <at> openbravo.com>
Date: Thu Oct 17 18:28:13 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5eedba0298f0a461dcea6a5ba2a775263cf8a8b0 [^]

Fixed issue 24264: The c_elementvalue_trg is performing and update when it is
 not needed. Can cause performance issues in some cases

---
M src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml
---
(0061856)
hudsonbot   
2013-10-22 23:42   
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/a362c560793b [^]

Maturity status: Test
(0061874)
egoitz   
2013-10-24 09:00   
verified