Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034482Openbravo ERP09. Financial managementpublic2016-11-14 10:062016-12-16 18:38
Reporterdmiguelez 
Assigned ToTriage Omni OMS 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034482: Improve performance in Enhanced Valued Stock Report
DescriptionThe Enhanced Valued Stock Report does not have an acceptable performance with large sets of data.
Since it needs to loop through all the information it does not escalate either.
It is necessary to persist information to avoid this two limitations.
Steps To ReproduceThe Enhanced Valued Stock Report does not have an acceptable performance with large sets of data.
Since it needs to loop through all the information it does not escalate either.
It is necessary to persist information to avoid this two limitations.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0034221 closed Sanjota Openbravo ERP Merge Valued Stock Report Enhanced with Valued Stock Report in Core 
has duplicate design defect 0031874 closed Triage Omni OMS Modules Performance problems in Valued Stock Report Enhanced 
has duplicate defect 0030197 closed psarobe Modules Enhanced valued stock report's performance is bad when no warehouse is filtered. 
causes defect 0034509 closed Triage Omni OMS Openbravo ERP warning in OrganizationStructureProvider 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-11-14 10:06dmiguelezNew Issue
2016-11-14 10:06dmiguelezAssigned To => Triage Finance
2016-11-14 10:06dmiguelezModules => Core
2016-11-14 10:06dmiguelezTriggers an Emergency Pack => No
2016-11-14 18:13hgbotCheckin
2016-11-14 18:13hgbotNote Added: 0091477
2016-11-14 18:13hgbotStatusnew => resolved
2016-11-14 18:13hgbotResolutionopen => fixed
2016-11-14 18:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cc7556ffc10b14bb6d75026461f06a06cc25feaa [^]
2016-11-14 18:15dmiguelezRelationship addedrelated to 0034221
2016-11-14 18:41dmiguelezReview Assigned To => dmiguelez
2016-11-14 18:41dmiguelezNote Added: 0091484
2016-11-14 18:41dmiguelezStatusresolved => closed
2016-11-15 08:40alostaleRelationship addedcauses 0034509
2016-12-16 18:38hudsonbotCheckin
2016-12-16 18:38hudsonbotNote Added: 0092619
2016-12-28 10:54aferrazRelationship addedhas duplicate 0031874
2016-12-28 10:56aferrazRelationship addedhas duplicate 0030197

Notes
(0091477)
hgbot   
2016-11-14 18:13   
Repository: erp/devel/pi
Changeset: cc7556ffc10b14bb6d75026461f06a06cc25feaa
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Nov 14 11:32:21 2016 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/cc7556ffc10b14bb6d75026461f06a06cc25feaa [^]

Fixes Issue 34482. Aggregates and Persist information related to Stock
to improve performance of Valued Stock Report.

*New Table created to persist information related to stock per each
closed Accounting Period
*New Background Process created to populate this table
*New Reset Process created to reset the information of this table

---
M src-db/database/model/functions/C_PERIOD_PROCESS.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_MENU.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_PROCESS.xml
M src-db/database/sourcedata/AD_TABLE.xml
M src-db/database/sourcedata/AD_TREENODE.xml
M src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
M src-db/database/sourcedata/OBUIAPP_PROCESS.xml
M src/org/openbravo/dal/security/OrganizationStructureProvider.java
A src-db/database/model/tables/M_VALUED_STOCK_AGG.xml
A src/org/openbravo/materialmgmt/GenerateAggregatedDataBackground.java
A src/org/openbravo/materialmgmt/GenerateValuedStockAggregated_data.xsql
A src/org/openbravo/materialmgmt/ResetValuedStockAggregated.java
---
(0091484)
dmiguelez   
2016-11-14 18:41   
Code Review + Testing Ok
(0092619)
hudsonbot   
2016-12-16 18: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/dc8bf00badd0 [^]
Maturity status: Test