Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039712Openbravo ERP02. Master data managementpublic2018-11-28 16:102018-12-27 21:34
ReporterJONHM 
Assigned ToAtulOpenbravo 
PriorityhighSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q1 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039712: Performance issue in Sales Dimensional Report
DescriptionThere is a performance issue in sales dimensional report when executing on an environment with high loads of data. It creates high memory usage and slowness.
Steps To ReproduceRun [Sales Dimensional Report] on an environment with high loads of data.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00136572.50MP20 closed adrianromero The sales invoice Dimensional Report does not work with a big amount of data using partner dimension 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-11-28 16:10JONHMNew Issue
2018-11-28 16:10JONHMAssigned To => Triage Finance
2018-11-28 16:10JONHMModules => Core
2018-11-28 16:10JONHMResolution time => 1545174000
2018-11-28 16:10JONHMTriggers an Emergency Pack => No
2018-11-28 16:31JONHMDescription Updatedbug_revision_view_page.php?rev_id=17988#r17988
2018-11-28 16:31JONHMSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=17990#r17990
2018-11-28 16:53martinsdanIssue Monitored: martinsdan
2018-11-28 16:57SandrahuguetAssigned ToTriage Finance => AtulOpenbravo
2018-11-30 08:28AtulOpenbravoStatusnew => scheduled
2018-12-26 16:03SandrahuguetRelationship addedrelated to 0013657
2018-12-26 16:06SandrahuguetNote Added: 0108749
2018-12-26 16:06hgbotCheckin
2018-12-26 16:06hgbotNote Added: 0108750
2018-12-26 16:06hgbotStatusscheduled => resolved
2018-12-26 16:06hgbotResolutionopen => fixed
2018-12-26 16:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e7d94cdd24743f7b5854c7a5ab333913f81a68fb [^]
2018-12-26 16:07SandrahuguetReview Assigned To => Sandrahuguet
2018-12-26 16:07SandrahuguetNote Added: 0108751
2018-12-26 16:07SandrahuguetStatusresolved => closed
2018-12-26 16:07SandrahuguetFixed in Version => 3.0PR19Q1
2018-12-27 21:34hudsonbotCheckin
2018-12-27 21:34hudsonbotNote Added: 0108770

Notes
(0108749)
Sandrahuguet   
2018-12-26 16:06   
Implemented properly the "reportlimit" functionality.
At least the report will be loaded in half time as before.
(0108750)
hgbot   
2018-12-26 16:06   
Repository: erp/devel/pi
Changeset: e7d94cdd24743f7b5854c7a5ab333913f81a68fb
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Dec 12 11:55:22 2018 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/e7d94cdd24743f7b5854c7a5ab333913f81a68fb [^]

Fixes Issue 39712:Performance issue in Sales Dimensional Report

For avoiding system crash, data is fetched with limit of preference
ReportLimit. If data count is more than ReportLimit, warning message
is shown to use apply more selective filters.

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
---
(0108751)
Sandrahuguet   
2018-12-26 16:07   
Code review + testing OK
(0108770)
hudsonbot   
2018-12-27 21:34   
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/45fbe14cead8 [^]
Maturity status: Test