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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0033096
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2016-06-01 09:412016-06-28 16:06
ReporteraferrazView Statuspublic 
Assigned ToSanjota 
PrioritynormalResolutionfixedFixed in Version3.0PR16Q3
StatusclosedFix in branchFixed in SCM revision0efc6f3e9689
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionProfessional ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033096: Performance problem in aprm_fin_finacc_tran_check_trg trigger

DescriptionTable fin_finacc_transaction has trigger defined on insert+update+delete, but reading trigger code seems to have no code at all running for insert case
Steps To Reproduce*
Proposed SolutionDefine aprm_fin_finacc_tran_check_trg trigger to be run only before update or delete.
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0087951)
hgbot (developer)
2016-06-27 10:57

 Repository: erp/devel/pi
Changeset: 0efc6f3e9689c245c3ea7e0b7cde02075d8eee29
Author: Sanjota <sanjota.nelagi <at> promantia.com>
Date: Thu Jun 09 22:17:33 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/0efc6f3e9689c245c3ea7e0b7cde02075d8eee29 [^]

Fixes issue 33096: Performance problem in aprm_fin_finacc_tran_check_trg()

Table fin_finacc_transaction has trigger defined on insert+update+delete, but reading trigger code seems to have no code at all running for insert case, so removed insert action definition.

---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_FIN_FINACC_TRAN_CHECK_TRG.xml
---
(0087952)
aferraz (viewer)
2016-06-27 10:58

 Code review OK
(0088053)
hudsonbot (viewer)
2016-06-28 16:06

 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/865878a5d292 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2016-06-01 09:41 aferraz New Issue
2016-06-01 09:41 aferraz Assigned To => Triage Finance
2016-06-01 09:41 aferraz OBNetwork customer => No
2016-06-01 09:41 aferraz Modules => Core
2016-06-01 09:41 aferraz Triggers an Emergency Pack => No
2016-06-01 09:49 aferraz Assigned To Triage Finance => Sanjota
2016-06-01 11:09 shuehner Tag Attached: Performance
2016-06-27 10:57 hgbot Checkin
2016-06-27 10:57 hgbot Note Added: 0087951
2016-06-27 10:57 hgbot Status new => resolved
2016-06-27 10:57 hgbot Resolution open => fixed
2016-06-27 10:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0efc6f3e9689c245c3ea7e0b7cde02075d8eee29 [^]
2016-06-27 10:58 aferraz Review Assigned To => aferraz
2016-06-27 10:58 aferraz Note Added: 0087952
2016-06-27 10:58 aferraz Status resolved => closed
2016-06-27 10:58 aferraz Fixed in Version => 3.0PR16Q3
2016-06-28 16:06 hudsonbot Checkin
2016-06-28 16:06 hudsonbot Note Added: 0088053

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker