Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0024264
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminorhave not tried2013-07-03 17:192013-10-24 09:00
ReporterjonalegriaesarteView Statuspublic 
Assigned Tongarcia 
PrioritynormalResolutionfixedFixed in Version3.0MP29
StatusclosedFix in branchFixed in SCM revision5eedba0298f0
ProjectionnoneETAnoneTarget Version3.0MP29
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toegoitz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0024264: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0061836)
hgbot (developer)
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 (developer)
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 (developer)
2013-10-24 09:00

 verified

- Issue History
Date Modified Username Field Change
2013-07-03 17:19 jonalegriaesarte New Issue
2013-07-03 17:19 jonalegriaesarte Assigned To => jonalegriaesarte
2013-07-03 17:19 jonalegriaesarte Modules => Core
2013-07-03 17:19 jonalegriaesarte Triggers an Emergency Pack => No
2013-08-19 16:47 jonalegriaesarte Target Version 3.0MP27 => 3.0MP28
2013-09-16 13:18 jonalegriaesarte Target Version 3.0MP28 => 3.0MP29
2013-10-17 00:54 jonalegriaesarte Assigned To jonalegriaesarte => ngarcia
2013-10-17 17:20 ngarcia Summary The 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:20 ngarcia Description Updated View Revisions
2013-10-17 17:20 ngarcia Steps to Reproduce Updated View Revisions
2013-10-22 09:21 hgbot Checkin
2013-10-22 09:21 hgbot Note Added: 0061836
2013-10-22 09:21 hgbot Status new => resolved
2013-10-22 09:21 hgbot Resolution open => fixed
2013-10-22 09:21 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5eedba0298f0a461dcea6a5ba2a775263cf8a8b0 [^]
2013-10-22 23:42 hudsonbot Checkin
2013-10-22 23:42 hudsonbot Note Added: 0061856
2013-10-24 09:00 egoitz Review Assigned To => egoitz
2013-10-24 09:00 egoitz Note Added: 0061874
2013-10-24 09:00 egoitz Status resolved => closed
2013-10-24 09:00 egoitz Fixed in Version => 3.0MP29

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker