Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0043368Openbravo ERP04. Warehouse managementpublic2020-02-28 11:292020-03-30 15:57
ReporterAtulOpenbravo 
Assigned ToAtulOpenbravo 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR20Q2 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0043368: API Change: Foreign Key Definition for M_Product_ID in M_Storage_Pending changed
DescriptionForeign key for column M_Product_ID in M_Storage_Pending is now defined as
ON DELETE CASCADE instead of NO ACTION. This way when there are no records associated to product in any of the transactions still there exists a linked record in M_Storage_Pending then it automatically gets deleted when deleting the product. This change is safe and hence has no risk.
Steps To Reproduce-
Proposed Solution
Additional Information
TagsApproved
Relationships
blocks defect 0043215 closed AtulOpenbravo IIt is impossible to delete products because of dependency with m_store_pending table 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-02-28 11:29AtulOpenbravoNew Issue
2020-02-28 11:29AtulOpenbravoAssigned To => dmitry_mezentsev
2020-02-28 11:29AtulOpenbravoOBNetwork customer => No
2020-02-28 11:29AtulOpenbravoModules => Core
2020-02-28 11:29AtulOpenbravoTriggers an Emergency Pack => No
2020-02-28 11:29AtulOpenbravoRelationship addedblocks 0043215
2020-02-28 12:30PracticsIssue Monitored: Practics
2020-02-28 14:21dmitry_mezentsevTag Attached: Approved
2020-02-28 14:21dmitry_mezentsevAssigned Todmitry_mezentsev => AtulOpenbravo
2020-03-02 10:09AtulOpenbravoStatusnew => scheduled
2020-03-02 10:16hgbotCheckin
2020-03-02 10:16hgbotNote Added: 0118225
2020-03-02 10:16hgbotStatusscheduled => resolved
2020-03-02 10:16hgbotResolutionopen => fixed
2020-03-02 10:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/d87542e99c58a2c93e496fdc481e19d9497a14d9 [^]
2020-03-02 18:12AtulOpenbravoIssue cloned0043391
2020-03-03 11:24dmiguelezReview Assigned To => dmiguelez
2020-03-03 11:24dmiguelezNote Added: 0118290
2020-03-03 11:24dmiguelezStatusresolved => closed
2020-03-03 11:24dmiguelezFixed in Version => 3.0PR20Q2
2020-03-18 08:35hgbotCheckin
2020-03-18 08:35hgbotNote Added: 0118657
2020-03-18 08:35hgbotStatusclosed => resolved
2020-03-18 08:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/api-checks/rev/d87542e99c58a2c93e496fdc481e19d9497a14d9 [^] => http://code.openbravo.com/erp/devel/api-checks/rev/207fb32a895a367e90f0eb7aa84538e27bcf4aeb [^]
2020-03-30 15:57dmiguelezNote Added: 0118878
2020-03-30 15:57dmiguelezStatusresolved => closed

Notes
(0118225)
hgbot   
2020-03-02 10:16   
Repository: erp/devel/api-checks
Changeset: d87542e99c58a2c93e496fdc481e19d9497a14d9
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Mon Mar 02 14:38:04 2020 +0530
URL: http://code.openbravo.com/erp/devel/api-checks/rev/d87542e99c58a2c93e496fdc481e19d9497a14d9 [^]

Fixes BUG-0043368: API Change - Foreign Key Definition
for M_Product_ID in M_Storage_Pending changed

**Foreign Key for M_PRODUCT_ID in M_STORAGE_PENDING is
set as ON DELETE CASCADE so that when product is being
deleted and is not associated with any transaction,
then record associated with M_Storage_Pending gets
deleted.

---
M model/src-db/database/model/tables/M_STORAGE_PENDING.xml
---
(0118290)
dmiguelez   
2020-03-03 11:24   
Code Review + Testing Ok
(0118657)
hgbot   
2020-03-18 08:35   
Repository: erp/devel/api-checks
Changeset: 207fb32a895a367e90f0eb7aa84538e27bcf4aeb
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Mon Mar 02 14:38:04 2020 +0530
URL: http://code.openbravo.com/erp/devel/api-checks/rev/207fb32a895a367e90f0eb7aa84538e27bcf4aeb [^]

Fixes BUG-0043368: API Change - Foreign Key Definition
for M_Product_ID in M_Storage_Pending changed

**Foreign Key for M_PRODUCT_ID in M_STORAGE_PENDING is
set as ON DELETE CASCADE so that when product is being
deleted and is not associated with any transaction,
then record associated with M_Storage_Pending gets
deleted.

---
M model/src-db/database/model/tables/M_STORAGE_PENDING.xml
---
(0118878)
dmiguelez   
2020-03-30 15:57   
Code Review + Testing Ok