Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0038119
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Advanced Warehouse Operationsminoralways2018-03-13 13:422018-06-04 15:46
ReporterdmiguelezView Statuspublic 
Assigned Toguilleaer 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisione888feb6530d
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned Toguilleaer
Regression introduced in release
Summary

0038119: 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
TagsNo 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
Powered by Mantis Bugtracker