Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0038119 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Modules] Advanced Warehouse Operations | minor | always | 2018-03-13 13:42 | 2018-06-04 15:46 | |||
Reporter | dmiguelez | View Status | public | |||||
Assigned To | guilleaer | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | e888feb6530d | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Regression date | ||||||||
Regression introduced by commit | ||||||||
Regression level | ||||||||
Review Assigned To | guilleaer | |||||||
Regression introduced in release | ||||||||
Summary | 0038119: Can not delete a Task that is related to a Errors while processing Tasks entry | |||||||
Description | Can not delete a Task that is related to a Errors while processing Tasks entry | |||||||
Steps To Reproduce | Follow steps to reproduce issue 38116. If fix revert the fix. As Openbravo user, in the Backend, select the Sales Order created. Move to Lines|Task Tab and try to delte the Task. It does not allow to do so due to linked items | |||||||
Proposed Solution | There should be an on delete cascade in the definition, if the Task is deleted, we do not need the Errors while processing Tasks entry | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0103971) hgbot (developer) 2018-04-18 15:49 |
Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations Changeset: e888feb6530de2974a4e5385f089f3e515b54ad6 Author: Alejandro <alekosmp86 <at> gmail.com> Date: Wed Apr 18 09:43:21 2018 -0400 URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/e888feb6530de2974a4e5385f089f3e515b54ad6 [^] Fixes issue 38119: It is now possible to delete a Task that is related to a Errors while processing Tasks entry. Two triggers have been created - When deleting a task, the first trigger will fire and try to delete the associated record(s) in table obawo_errortask. - If any record in obawo_errortask table was deleted, then the second trigger fires, and it will try to delete associated records in obawo_errors table, but only if there are no more references to that record in another table. --- A src-db/database/model/triggers/OBAWO_ERRORTASK_TRG.xml A src-db/database/model/triggers/OBAWO_TASK_TRG_DELETELINKERROR.xml --- |
(0104310) hgbot (developer) 2018-05-07 15:32 |
Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations Changeset: 132895f63fa63fa1bfe370bf334a405a0968f24b Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com> Date: Mon May 07 13:45:25 2018 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/132895f63fa63fa1bfe370bf334a405a0968f24b [^] Related to issue 38119: Remove uneeded trigger and add delete cascade instead --- M src-db/database/model/tables/OBAWO_ERROR_TASK.xml R src-db/database/model/triggers/OBAWO_TASK_TRG_DELETELINKERROR.xml --- |
(0104311) hgbot (developer) 2018-05-07 15:54 |
Repository: retail/backports/AWO/3.0RR17Q4/org.openbravo.warehouse.advancedwarehouseoperations Changeset: ba306071816ccb07aab44f7e6b937d1dfceca5d6 Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com> Date: Mon May 07 13:45:25 2018 +0200 URL: http://code.openbravo.com/retail/backports/AWO/3.0RR17Q4/org.openbravo.warehouse.advancedwarehouseoperations/rev/ba306071816ccb07aab44f7e6b937d1dfceca5d6 [^] Related to issue 38119: Remove uneeded trigger and add delete cascade instead --- M src-db/database/model/tables/OBAWO_ERROR_TASK.xml A src-db/database/model/triggers/OBAWO_ERRORTASK_TRG.xml --- |
(0104312) hgbot (developer) 2018-05-07 15:56 |
Repository: retail/backports/AWO/3.0RR18Q1/org.openbravo.warehouse.advancedwarehouseoperations Changeset: 519b3129882afc320a59fd8ba1677a2978b58fd9 Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com> Date: Mon May 07 13:45:25 2018 +0200 URL: http://code.openbravo.com/retail/backports/AWO/3.0RR18Q1/org.openbravo.warehouse.advancedwarehouseoperations/rev/519b3129882afc320a59fd8ba1677a2978b58fd9 [^] Related to issue 38119: Remove uneeded trigger and add delete cascade instead --- M src-db/database/model/tables/OBAWO_ERROR_TASK.xml A src-db/database/model/triggers/OBAWO_ERRORTASK_TRG.xml --- |
(0104313) guilleaer (developer) 2018-05-07 15:57 |
Tested and reviewed. Backports for 17Q4 & 18Q1 done |
(0104923) hgbot (developer) 2018-06-04 15:46 |
Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations Changeset: c500d71029785a6d420801766f61c5414c6c36b0 Author: Alejandro <alekosmp86 <at> gmail.com> Date: Fri Jun 01 15:00:10 2018 -0400 URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/c500d71029785a6d420801766f61c5414c6c36b0 [^] Related to issue 38119: Removed triggers and implemented deletion logic in an EventObserver. --- A src/org/openbravo/warehouse/advancedwarehouseoperations/eventobserver/TasksErrorsEventObserver.java R src-db/database/model/triggers/OBAWO_ERRORTASK_TRG.xml --- |
Issue History | |||
Date Modified | Username | Field | Change |
2018-03-13 13:42 | dmiguelez | New Issue | |
2018-03-13 13:42 | dmiguelez | Assigned To | => dmiguelez |
2018-03-13 13:50 | dmiguelez | Assigned To | dmiguelez => guilleaer |
2018-04-18 15:49 | hgbot | Checkin | |
2018-04-18 15:49 | hgbot | Note Added: 0103971 | |
2018-04-18 15:49 | hgbot | Status | new => resolved |
2018-04-18 15:49 | hgbot | Resolution | open => fixed |
2018-04-18 15:49 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/e888feb6530de2974a4e5385f089f3e515b54ad6 [^] |
2018-05-07 15:32 | hgbot | Checkin | |
2018-05-07 15:32 | hgbot | Note Added: 0104310 | |
2018-05-07 15:54 | hgbot | Checkin | |
2018-05-07 15:54 | hgbot | Note Added: 0104311 | |
2018-05-07 15:56 | hgbot | Checkin | |
2018-05-07 15:56 | hgbot | Note Added: 0104312 | |
2018-05-07 15:57 | guilleaer | Review Assigned To | => guilleaer |
2018-05-07 15:57 | guilleaer | Note Added: 0104313 | |
2018-05-07 15:57 | guilleaer | Status | resolved => closed |
2018-06-04 15:46 | hgbot | Checkin | |
2018-06-04 15:46 | hgbot | Note Added: 0104923 | |
2022-09-06 17:18 | caristu | Category | Advance Warehouse Operations => Advanced Warehouse Operations |
Copyright © 2000 - 2009 MantisBT Group |