Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0013659Openbravo ERP07. Sales managementpublic2010-06-15 09:372010-07-24 00:00
networkb 
adrianromero 
urgentmajoralways
closedfixed 
5
2.50MP18 
2.50MP20 
Core
No
0013659: The sales Dimensional Report does not work with a big amount of data using partner dimension
The 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.

with 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
No tags attached.
blocks design defect 0013943 new mirurita Dimensional Reports and other reports does not work with a big amount of data using partner dimension or other dimensions 
Issue History
2010-06-15 09:37networkbNew Issue
2010-06-15 09:37networkbAssigned To => adrianromero
2010-07-05 13:31adrianromeroStatusnew => scheduled
2010-07-05 13:31adrianromerofix_in_branch => pi
2010-07-06 11:51hgbotCheckin
2010-07-06 11:51hgbotNote Added: 0029089
2010-07-06 11:51hgbotStatusscheduled => resolved
2010-07-06 11:51hgbotResolutionopen => fixed
2010-07-06 11:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a6c6cf35240e55239a7cb0ae7e8bb4a045495678 [^]
2010-07-07 12:38hudsonbotCheckin
2010-07-07 12:38hudsonbotNote Added: 0029119
2010-07-12 16:02hgbotCheckin
2010-07-12 16:02hgbotNote Added: 0029238
2010-07-12 16:02hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/a6c6cf35240e55239a7cb0ae7e8bb4a045495678 [^] => http://code.openbravo.com/erp/devel/pi/rev/8f2a547a23b496cfe83afe419eb484222b662ab9 [^]
2010-07-12 17:18adrianromeroRelationship addedblocks 0013943
2010-07-14 04:43hudsonbotCheckin
2010-07-14 04:43hudsonbotNote Added: 0029287
2010-07-23 11:18psarobeNote Added: 0029514
2010-07-23 11:18psarobeStatusresolved => closed
2010-07-23 11:25networkbNote Added: 0029515
2010-07-24 00:00anonymoussf_bug_id0 => 3033798

Notes
(0029089)
hgbot   
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   
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   
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   
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   
2010-07-23 11:18   
Cannot be reviewed. Waiting for partner confirmation
(0029515)
networkb   
2010-07-23 11:25   
Partner has just confirmed that everything is OK