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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013659
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2010-06-15 09:372010-07-24 00:00
ReporternetworkbView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision8f2a547a23b4
ProjectionnoneETAnoneTarget Version2.50MP20
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.50MP18SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0013659: The sales Dimensional Report does not work with a big amount of data using partner dimension

DescriptionThe sales Dimensional Report does not work with a big amount of data using partner dimension. The report is not shown but you don't get any error.
The applications seems locked.

Steps To Reproducewith the following amount of data execute the sales invoice dimensional report
using the business parter on the dimension.

C_BPARTNER 148093
C_ORDER 478000
C_ORDERLINE 2387630
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks design defect 0013943 newmirurita Dimensional Reports and other reports does not work with a big amount of data using partner dimension or other dimensions 

-  Notes
(0029089)
hgbot (developer)
2010-07-06 11:51

 Repository: erp/devel/pi
Changeset: a6c6cf35240e55239a7cb0ae7e8bb4a045495678
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Jul 06 11:51:07 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a6c6cf35240e55239a7cb0ae7e8bb4a045495678 [^]

Fixes issue 0013657: The sales invoice Dimensional Report does not work with a big amount of data using partner dimension
Fixes issue 0013658: The Shipment Dimensional Report does not work with a big amount of data using partner dimension.
Fixes issue 0013659: The sales Dimensional Report does not work with a big amount of data using partner dimension.
It has been added a new preference called ReportsLimit that if the estimated number of rows to display in these dimensional reports are reached, the execution is cancelled and it is notified to the user that must be more selective in the filter criteria to execute the report

---
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/referencedData/AD_PREFERENCE.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR_data.xsql
---
(0029119)
hudsonbot (developer)
2010-07-07 12:38

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/a6c6cf35240e [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/d555a35070ee [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17817.obx [^]
(0029238)
hgbot (developer)
2010-07-12 16:02

 Repository: erp/devel/pi
Changeset: 8f2a547a23b496cfe83afe419eb484222b662ab9
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Jul 12 16:01:38 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8f2a547a23b496cfe83afe419eb484222b662ab9 [^]

Fixes issue 0013657: The sales invoice Dimensional Report does not work with a big amount of data using partner dimension
Fixes issue 0013658: The Shipment Dimensional Report does not work with a big amount of data using partner dimension.
Fixes issue 0013659: The sales Dimensional Report does not work with a big amount of data using partner dimension.
Fixed SQL for Oracle

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR_data.xsql
---
(0029287)
hudsonbot (developer)
2010-07-14 04:43

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/8f2a547a23b4 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/2a91111beef4 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17878.obx [^]
(0029514)
psarobe (manager)
2010-07-23 11:18

 Cannot be reviewed. Waiting for partner confirmation
(0029515)
networkb (developer)
2010-07-23 11:25

 Partner has just confirmed that everything is OK

- Issue History
Date Modified Username Field Change
2010-06-15 09:37 networkb New Issue
2010-06-15 09:37 networkb Assigned To => adrianromero
2010-07-05 13:31 adrianromero Status new => scheduled
2010-07-05 13:31 adrianromero fix_in_branch => pi
2010-07-06 11:51 hgbot Checkin
2010-07-06 11:51 hgbot Note Added: 0029089
2010-07-06 11:51 hgbot Status scheduled => resolved
2010-07-06 11:51 hgbot Resolution open => fixed
2010-07-06 11:51 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a6c6cf35240e55239a7cb0ae7e8bb4a045495678 [^]
2010-07-07 12:38 hudsonbot Checkin
2010-07-07 12:38 hudsonbot Note Added: 0029119
2010-07-12 16:02 hgbot Checkin
2010-07-12 16:02 hgbot Note Added: 0029238
2010-07-12 16:02 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/a6c6cf35240e55239a7cb0ae7e8bb4a045495678 [^] => http://code.openbravo.com/erp/devel/pi/rev/8f2a547a23b496cfe83afe419eb484222b662ab9 [^]
2010-07-12 17:18 adrianromero Relationship added blocks 0013943
2010-07-14 04:43 hudsonbot Checkin
2010-07-14 04:43 hudsonbot Note Added: 0029287
2010-07-23 11:18 psarobe Note Added: 0029514
2010-07-23 11:18 psarobe Status resolved => closed
2010-07-23 11:25 networkb Note Added: 0029515
2010-07-24 00:00 anonymous sf_bug_id 0 => 3033798

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker