Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013657Openbravo ERP07. Sales managementpublic2010-06-15 09:342010-09-09 13:13
Reporternetworkb 
Assigned Toadrianromero 
PriorityhighSeveritymajorReproducibilityalways
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
Summary0013657: The sales invoice 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
C_INVOICE 34507
C_INVOICELINE 1514699
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00133612.50MP18 closed sivaraman The General Ledger Report does not work well using the group by option with a big amount of data 
related to 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 
related to defect 00139002.50MP20 closed sivaraman The Payment Tracker does not work with a big amount of data 
related to defect 0039712 closed AtulOpenbravo Performance issue in Sales Dimensional Report 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-06-15 09:34networkbNew Issue
2010-06-15 09:34networkbAssigned 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: 0029087
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: 0029117
2010-07-12 16:02hgbotCheckin
2010-07-12 16:02hgbotNote Added: 0029236
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 addedrelated to 0013943
2010-07-14 04:43hudsonbotCheckin
2010-07-14 04:43hudsonbotNote Added: 0029285
2010-07-23 11:18psarobeNote Added: 0029512
2010-07-23 11:18psarobeStatusresolved => closed
2010-07-23 11:25networkbNote Added: 0029518
2010-07-24 00:00anonymoussf_bug_id0 => 3033796
2010-08-19 10:53adrianromeroRelationship addedrelated to 0013900
2010-09-09 13:12adrianromeroRelationship addeddepends on 0013361
2010-09-09 13:12adrianromeroRelationship deleteddepends on 0013361
2010-09-09 13:13adrianromeroRelationship addedrelated to 0013361
2018-12-26 16:03SandrahuguetRelationship addedrelated to 0039712

Notes
(0029087)
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
---
(0029117)
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 [^]
(0029236)
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
---
(0029285)
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 [^]
(0029512)
psarobe   
2010-07-23 11:18   
Cannot be review. Waiting for partner confirmation
(0029518)
networkb   
2010-07-23 11:25   
Partner has just confirmed that everything is OK