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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0034482
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 09. Financial managementmajoralways2016-11-14 10:062016-12-16 18:38
ReporterdmiguelezView Statuspublic 
Assigned ToTriage Omni OMS 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisioncc7556ffc10b
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0034482: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 0034221 closedSanjota Openbravo ERP Merge Valued Stock Report Enhanced with Valued Stock Report in Core 
has duplicate design defect 0031874 closedTriage Omni OMS Modules Performance problems in Valued Stock Report Enhanced 
has duplicate defect 0030197 closedpsarobe Modules Enhanced valued stock report's performance is bad when no warehouse is filtered. 
causes defect 0034509 closedTriage Omni OMS Openbravo ERP warning in OrganizationStructureProvider 

-  Notes
(0091477)
hgbot (developer)
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 (developer)
2016-11-14 18:41

 Code Review + Testing Ok
(0092619)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2016-11-14 10:06 dmiguelez New Issue
2016-11-14 10:06 dmiguelez Assigned To => Triage Finance
2016-11-14 10:06 dmiguelez Modules => Core
2016-11-14 10:06 dmiguelez Triggers an Emergency Pack => No
2016-11-14 18:13 hgbot Checkin
2016-11-14 18:13 hgbot Note Added: 0091477
2016-11-14 18:13 hgbot Status new => resolved
2016-11-14 18:13 hgbot Resolution open => fixed
2016-11-14 18:13 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cc7556ffc10b14bb6d75026461f06a06cc25feaa [^]
2016-11-14 18:15 dmiguelez Relationship added related to 0034221
2016-11-14 18:41 dmiguelez Review Assigned To => dmiguelez
2016-11-14 18:41 dmiguelez Note Added: 0091484
2016-11-14 18:41 dmiguelez Status resolved => closed
2016-11-15 08:40 alostale Relationship added causes 0034509
2016-12-16 18:38 hudsonbot Checkin
2016-12-16 18:38 hudsonbot Note Added: 0092619
2016-12-28 10:54 aferraz Relationship added has duplicate 0031874
2016-12-28 10:56 aferraz Relationship added has duplicate 0030197

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker