Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030281Openbravo ERP04. Warehouse managementpublic2015-06-29 14:002016-06-17 19:38
Reportershuehner 
Assigned ToSanjota 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q3 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030281: m_stock_proposed table should be added to log cleanup default configuration
DescriptionThat table has temporary data only which is not needed after the calling process has finished.

In newer version calling code should auto-cleanup after itself but in some cases that maybe does not work correctly.

i.e. external modules
bugs like: 30278

note: The rows should only be removed after all calling process finish. By having a config only deleting 15days or older that should indirectly be good enough as no process should be running that long without being itself a very very big problem.
Steps To Reproduce-
Proposed SolutionAdd m_stock_proposed table to log cleanup default config with 15 days retention similar to ad_pinstance
Additional Information
TagsNo tags attached.
Relationships
related to defect 0030280 closed ranjith_qualiantech_com Retail Modules obmobc_logclient table is missing in the new Log Cleanup default config added to ERP in Q2 
related to defect 0030278 scheduled inigo_lerga Openbravo ERP Stock Proposed records not deleted on M_InOut_Create 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-06-29 14:00shuehnerNew Issue
2015-06-29 14:00shuehnerAssigned To => Triage Finance
2015-06-29 14:00shuehnerModules => Core
2015-06-29 14:00shuehnerTriggers an Emergency Pack => No
2015-06-29 14:00shuehnerRelationship addedrelated to 0030280
2015-06-29 14:03shuehnerRelationship addedrelated to 0030278
2016-06-02 18:53ngarciaIssue Monitored: ngarcia
2016-06-02 18:55ngarciaResolution time => 1466632800
2016-06-02 18:55ngarciaPrioritynormal => urgent
2016-06-06 12:01aferrazSummarym_proposed_stock table should be added to log cleanup default configuration => m_stock_proposed table should be added to log cleanup default configuration
2016-06-06 12:01aferrazProposed Solution updated
2016-06-06 12:50aferrazAssigned ToTriage Finance => Sanjota
2016-06-07 16:36SanjotaNote Added: 0087068
2016-06-07 16:36SanjotaStatusnew => scheduled
2016-06-08 10:53hgbotCheckin
2016-06-08 10:53hgbotNote Added: 0087084
2016-06-08 10:53hgbotStatusscheduled => resolved
2016-06-08 10:53hgbotResolutionopen => fixed
2016-06-08 10:53hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0b89973697609618bf92e03b3afe63fa16380d57 [^]
2016-06-08 10:56aferrazReview Assigned To => aferraz
2016-06-08 10:56aferrazNote Added: 0087085
2016-06-08 10:56aferrazStatusresolved => closed
2016-06-08 10:56aferrazFixed in Version => 3.0PR16Q3
2016-06-08 17:16SanjotaNote Edited: 0087068bug_revision_view_page.php?bugnote_id=0087068#r12335
2016-06-17 19:38hudsonbotCheckin
2016-06-17 19:38hudsonbotNote Added: 0087596

Notes
(0087068)
Sanjota   
2016-06-07 16:36   
(edited on: 2016-06-08 17:16)
Test Plan:

Added the table "m_stock_proposed" to log cleanup default config with 15 days retention.
(0087084)
hgbot   
2016-06-08 10:53   
Repository: erp/devel/pi
Changeset: 0b89973697609618bf92e03b3afe63fa16380d57
Author: Sanjota <sanjota.nelagi <at> promantia.com>
Date: Tue Jun 07 19:59:56 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/0b89973697609618bf92e03b3afe63fa16380d57 [^]

Fixes issue 30281: m_stock_proposed added to log cleanup default configuration

m_stock_proposed table data should be cleaned up once the process is finished. So should add the same table to log cleanup default configuration.

---
M modules/org.openbravo.utility.cleanup.log/referencedata/standard/Log_Clean_Up_Default_Configuration.xml
---
(0087085)
aferraz   
2016-06-08 10:56   
Code review + Testing OK
(0087596)
hudsonbot   
2016-06-17 19:38   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/0dc7be081b1c [^]
Maturity status: Test