Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013943Openbravo ERPI. Performancepublic2010-07-12 17:172012-09-18 11:22
Reporteradrianromero 
Assigned Tomirurita 
PriorityhighSeverityminorReproducibilityN/A
StatusnewResolutionopen 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0013943: Dimensional Reports and other reports does not work with a big amount of data using partner dimension or other dimensions
DescriptionWhen executing a Dimensional Report that will retrieve a lot of records (> 10000) The report is not shown but you don't get any error.
The applications seems locked.

The reports that needs to be fixed are:

Sales invoice Dimensional Report
Material Receipts Dimensional Report
Purchase Invoice Dimensional Report
Vendor Invoice Dimensional Report
Sales Order Returns Dimensional Report
etc.
Steps To ReproduceUse a database with a big amount of data and try to execute a Dimensional report without any filter and withing a big dates period. For example the Purchase Dimensional Report.
Proposed SolutionImplement a message that warns the user that the report has a big amount of records and it is required to add a filter to reduce the number of rows to show in the report

This is the solution adopted for Sales Dimensional Report, Sales invoice Dimensional Report and Shipments Dimensional Report and Sales O
Additional Information
TagsVMA-Reviewed
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 
depends on defect 00136582.50MP20 closed adrianromero The Shipment Dimensional Report does not work with a big amount of data using partner dimension. 
depends on defect 00136592.50MP20 closed adrianromero The sales Dimensional Report does not work with a big amount of data using partner dimension 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-07-12 17:17adrianromeroNew Issue
2010-07-12 17:17adrianromeroAssigned To => adrianromero
2010-07-12 17:17adrianromeroRelationship addedrelated to 0013657
2010-07-12 17:17adrianromeroRelationship addeddepends on 0013658
2010-07-12 17:18adrianromeroRelationship addeddepends on 0013659
2011-06-03 10:59dalsasuaAssigned Toadrianromero => dalsasua
2011-07-20 18:12dalsasuaAssigned Todalsasua => jonalegriaesarte
2012-02-15 19:05iciordiaAssigned Tojonalegriaesarte => vmromanos
2012-02-16 14:22vmromanosTag Attached: VMA-Reviewed
2012-04-03 11:06xabiermerinoResolution time => 1339970400
2012-04-03 11:06xabiermerinoPriorityurgent => high
2012-04-03 11:06xabiermerinoSeveritymajor => minor
2012-04-03 11:06xabiermerinoversionpi => 3.0MP9
2012-04-03 11:06xabiermerinoTarget Version => 3.0MP11
2012-04-03 11:15xabiermerinoResolution time1339970400 =>
2012-04-03 11:15xabiermerinoversion3.0MP9 => pi
2012-04-03 11:15xabiermerinoTarget Version3.0MP11 =>
2012-05-10 12:12gorka_gilAssigned Tovmromanos => mirurita
2012-09-18 11:22dmiguelezTypedefect => design defect

There are no notes attached to this issue.