Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039687ModulesExternal Data Integrationpublic2018-11-23 11:552018-12-10 16:26
Reportercaristu 
Assigned Tocaristu 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned ToAugustoMauch
Support ticket
OBNetwork customer
Regression introduced in release
Summary0039687: Log Clean Up does not clear EDL Requests that have dependencies
DescriptionLog Clean Up does not clear EDL Requests that have dependencies
Steps To Reproduce1) Create an EDL Request with dependencies
2) Process all the requests
3) Run the Log Clean Up process to clear the processed requests
4) Note that the EDL requests are not removed. The following text can be found in the process log:

2018-11-23 11:49:01.466 - Cleaning up entity OBEDL_Request
2018-11-23 11:49:38.539 - Error executing cleanup query "delete from OBEDL_Request where (processed is true) and client.id = '39363B0921BB4293B48383844325E84C'": could not execute statement
2018-11-23 11:49:38.539 - Deleted 0 rows
2018-11-23 11:49:38.539 - Entity OBEDL_Request cleaned up in 3ms
Proposed SolutionAdd missing on delete cascade
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0038503 closed AugustoMauch Allow to define dependencies between EDL Requests 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-11-23 11:55caristuNew Issue
2018-11-23 11:55caristuAssigned To => caristu
2018-11-23 11:55caristuIssue generated from0039685
2018-11-23 11:56caristuRelationship addedrelated to 0038503
2018-11-23 11:56caristuReview Assigned To => AugustoMauch
2018-11-23 14:12hgbotCheckin
2018-11-23 14:12hgbotNote Added: 0108089
2018-11-23 14:12hgbotStatusnew => resolved
2018-11-23 14:12hgbotResolutionopen => fixed
2018-11-23 14:12hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.externaldata.integration/rev/ecde0bb36391b0d48129bb2d407e87f07349bdb8 [^]
2018-11-23 14:14caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=17960#r17960
2018-12-10 16:26AugustoMauchNote Added: 0108370
2018-12-10 16:26AugustoMauchStatusresolved => closed

Notes
(0108089)
hgbot   
2018-11-23 14:12   
Repository: erp/pmods/org.openbravo.externaldata.integration
Changeset: ecde0bb36391b0d48129bb2d407e87f07349bdb8
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Fri Nov 23 14:11:41 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.externaldata.integration/rev/ecde0bb36391b0d48129bb2d407e87f07349bdb8 [^]

fixes bug 39687: Log Clean Up doesn't clear EDL Requests that have dependencies

  Added missing "on delete cascade" constraints

---
M src-db/database/model/tables/OBEDL_REQUEST_DEPENDENCY.xml
---
(0108370)
AugustoMauch   
2018-12-10 16:26   
Code reviewed and verified