Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038119ModulesAdvanced Warehouse Operationspublic2018-03-13 13:422018-06-04 15:46
Reporterdmiguelez 
Assigned Toguilleaer 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toguilleaer
Support ticket
OBNetwork customer
Regression introduced in release
Summary0038119: Can not delete a Task that is related to a Errors while processing Tasks entry
DescriptionCan not delete a Task that is related to a Errors while processing Tasks entry
Steps To ReproduceFollow 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 SolutionThere should be an on delete cascade in the definition, if the Task is deleted, we do not need the Errors while processing Tasks entry
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-03-13 13:42dmiguelezNew Issue
2018-03-13 13:42dmiguelezAssigned To => dmiguelez
2018-03-13 13:50dmiguelezAssigned Todmiguelez => guilleaer
2018-04-18 15:49hgbotCheckin
2018-04-18 15:49hgbotNote Added: 0103971
2018-04-18 15:49hgbotStatusnew => resolved
2018-04-18 15:49hgbotResolutionopen => fixed
2018-04-18 15:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/e888feb6530de2974a4e5385f089f3e515b54ad6 [^]
2018-05-07 15:32hgbotCheckin
2018-05-07 15:32hgbotNote Added: 0104310
2018-05-07 15:54hgbotCheckin
2018-05-07 15:54hgbotNote Added: 0104311
2018-05-07 15:56hgbotCheckin
2018-05-07 15:56hgbotNote Added: 0104312
2018-05-07 15:57guilleaerReview Assigned To => guilleaer
2018-05-07 15:57guilleaerNote Added: 0104313
2018-05-07 15:57guilleaerStatusresolved => closed
2018-06-04 15:46hgbotCheckin
2018-06-04 15:46hgbotNote Added: 0104923
2022-09-06 17:18caristuCategoryAdvance Warehouse Operations => Advanced Warehouse Operations

Notes
(0103971)
hgbot   
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   
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   
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   
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   
2018-05-07 15:57   
Tested and reviewed. Backports for 17Q4 & 18Q1 done
(0104923)
hgbot   
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
---