Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033096Openbravo ERP09. Financial managementpublic2016-06-01 09:412016-06-28 16:06
Reporteraferraz 
Assigned ToSanjota 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionProfessional Appliance
Product Version 
Target VersionFixed in Version3.0PR16Q3 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033096: 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.
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-06-01 09:41aferrazNew Issue
2016-06-01 09:41aferrazAssigned To => Triage Finance
2016-06-01 09:41aferrazModules => Core
2016-06-01 09:41aferrazTriggers an Emergency Pack => No
2016-06-01 09:49aferrazAssigned ToTriage Finance => Sanjota
2016-06-01 11:09shuehnerTag Attached: Performance
2016-06-27 10:57hgbotCheckin
2016-06-27 10:57hgbotNote Added: 0087951
2016-06-27 10:57hgbotStatusnew => resolved
2016-06-27 10:57hgbotResolutionopen => fixed
2016-06-27 10:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0efc6f3e9689c245c3ea7e0b7cde02075d8eee29 [^]
2016-06-27 10:58aferrazReview Assigned To => aferraz
2016-06-27 10:58aferrazNote Added: 0087952
2016-06-27 10:58aferrazStatusresolved => closed
2016-06-27 10:58aferrazFixed in Version => 3.0PR16Q3
2016-06-28 16:06hudsonbotCheckin
2016-06-28 16:06hudsonbotNote Added: 0088053

Notes
(0087951)
hgbot   
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   
2016-06-27 10:58   
Code review OK
(0088053)
hudsonbot   
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