Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0027437Openbravo ERP09. Financial managementpublic2014-08-23 16:012015-08-20 23:16
shuehner 
AtulOpenbravo 
normaltrivialhave not tried
closedfixed 
5
 
 
vmromanos
Core
No
0027437: Trigger A_AMORTIZATIONLINE_TRG2 is useless and should be deleted
That trigger does not contain any useful body.

But all of it is commented out with some comment: mutating table.

Hg log shows that to be the case since revision '0' (2007).

The trigger should just be deleted as it does serve no purpose as it is.

Important note: When deleting it should be checked if that commented code is functionally needed as if so needs to be added elsewhere.

Note: If that is needed it should be reported as a separate related issue and fixed there. It should not stop the trigger deletion as it has been like this forever (a long time at least)
Check trigger body + hg history.
No tags attached.
Issue History
2014-08-23 16:01shuehnerNew Issue
2014-08-23 16:01shuehnerAssigned To => dmiguelez
2014-08-23 16:01shuehnerModules => Core
2014-08-23 16:01shuehnerTriggers an Emergency Pack => No
2014-08-23 16:01shuehnerNote Added: 0069640
2014-09-03 14:10eduardo_ArgalAssigned Todmiguelez => eduardo_Argal
2015-07-13 13:26AtulOpenbravoAssigned Toeduardo_Argal => AtulOpenbravo
2015-07-13 13:26AtulOpenbravoStatusnew => scheduled
2015-07-13 13:28AtulOpenbravoNote Added: 0078774
2015-07-13 13:29AtulOpenbravoNote Edited: 0078774bug_revision_view_page.php?bugnote_id=0078774#r9003
2015-07-14 09:50hgbotCheckin
2015-07-14 09:50hgbotNote Added: 0078784
2015-07-14 09:50hgbotStatusscheduled => resolved
2015-07-14 09:50hgbotResolutionopen => fixed
2015-07-14 09:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ed5b74af3fa682bd2748163f83f89f6adb423071 [^]
2015-07-14 09:51vmromanosReview Assigned To => vmromanos
2015-07-14 09:51vmromanosNote Added: 0078785
2015-07-14 09:51vmromanosStatusresolved => closed
2015-07-16 12:04gorka_gilFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/ed5b74af3fa682bd2748163f83f89f6adb423071 [^] => http://code.openbravo.com/erp/devel/pi/rev/8d4487cdedc9 [^]
2015-07-16 12:04gorka_gilNote Edited: 0078784bug_revision_view_page.php?bugnote_id=0078784#r9052
2015-08-20 23:16hudsonbotCheckin
2015-08-20 23:16hudsonbotNote Added: 0079492

Notes
(0069640)
shuehner   
2014-08-23 16:01   
Found by 'Unreachable code' warning of oracle
(0078774)
AtulOpenbravo   
2015-07-13 13:28   
(edited on: 2015-07-13 13:29)
Commented code in the trigger A_AMORTIZATIONLINE_TRG2 is implemented as a part of the commit https://code.openbravo.com/erp/devel/pi/rev/39a40ec8d089a2075b806fdc2e0175ff1446c4d3 [^] for the issue https://issues.openbravo.com/view.php?id=12460 [^]

(0078784)
hgbot   
2015-07-14 09:50   
(edited on: 2015-07-16 12:04)
Repository: erp/devel/pi
Changeset: 8d4487cdedc9
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Mon Jul 13 16:37:22 2015 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/8d4487cdedc9 [^]

Fixes Issue 27437: Trigger A_AMORTIZATIONLINE_TRG2 is useless and should be
deleted

Removed trigger A_AMORIZATIONLINE_TRG2. Code to update DepreciatedPlan is
implemented in A_AMORTIZATIONLINE_TRG so there is no harm in removing this
trigger.

---
R src-db/database/model/triggers/A_AMORTIZATIONLINE_TRG2.xml
---

(0078785)
vmromanos   
2015-07-14 09:51   
Verified
(0079492)
hudsonbot   
2015-08-20 23:16   
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/8c91718397a5 [^]
Maturity status: Test