Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0033096 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | minor | always | 2016-06-01 09:41 | 2016-06-28 16:06 | |||
| Reporter | aferraz | View Status | public | |||||
| Assigned To | Sanjota | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0PR16Q3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 0efc6f3e9689 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Professional Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | SCM revision | |||||||
| Review Assigned To | aferraz | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0033096: Performance problem in aprm_fin_finacc_tran_check_trg trigger | |||||||
| Description | 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 | |||||||
| Steps To Reproduce | * | |||||||
| Proposed Solution | Define aprm_fin_finacc_tran_check_trg trigger to be run only before update or delete. | |||||||
| Tags | Performance | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
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 (manager) 2016-06-27 10:58 |
Code review OK |
|
(0088053) hudsonbot (developer) 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 |
|
Notes |
|
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 | 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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |