Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013658Openbravo ERP07. Sales managementpublic2010-06-15 09:362010-07-24 00:00
Reporternetworkb 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP18 
Target Version2.50MP20Fixed 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
Summary0013658: The Shipment Dimensional Report does not work with a big amount of data using partner dimension.
DescriptionThe sales invoice 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
M_SHIPMENT 287332
M_SHIPMENT_LINE 1434016
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-06-15 09:36networkbNew Issue
2010-06-15 09:36networkbAssigned To => adrianromero
2010-07-05 13:32adrianromeroStatusnew => scheduled
2010-07-05 13:32adrianromerofix_in_branch => pi
2010-07-06 11:51hgbotCheckin
2010-07-06 11:51hgbotNote Added: 0029088
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: 0029118
2010-07-12 16:02hgbotCheckin
2010-07-12 16:02hgbotNote Added: 0029237
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:17adrianromeroRelationship addedblocks 0013943
2010-07-14 04:43hudsonbotCheckin
2010-07-14 04:43hudsonbotNote Added: 0029286
2010-07-23 11:18psarobeNote Added: 0029513
2010-07-23 11:18psarobeStatusresolved => closed
2010-07-23 11:25networkbNote Added: 0029516
2010-07-24 00:00anonymoussf_bug_id0 => 3033797

Notes
(0029088)
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
---
(0029118)
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 [^]
(0029237)
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
---
(0029286)
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 [^]
(0029513)
psarobe   
2010-07-23 11:18   
Cannot be reviewed. Waiting for partner confirmation
(0029516)
networkb   
2010-07-23 11:25   
Partner has just confirmed that everything is OK