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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013657
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2010-06-15 09:342010-09-09 13:13
ReporternetworkbView Statuspublic 
Assigned Toadrianromero 
PriorityhighResolutionfixedFixed 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

0013657: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00133612.50MP18 closedsivaraman The General Ledger Report does not work well using the group by option with a big amount of data 
related to design defect 0013943 newmirurita 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 closedsivaraman The Payment Tracker does not work with a big amount of data 
related to defect 0039712 closedAtulOpenbravo Performance issue in Sales Dimensional Report 

-  Notes
(0029087)
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
---
(0029117)
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 [^]
(0029236)
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
---
(0029285)
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 [^]
(0029512)
psarobe (manager)
2010-07-23 11:18

 Cannot be review. Waiting for partner confirmation
(0029518)
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:34 networkb New Issue
2010-06-15 09:34 networkb Assigned To => adrianromero
2010-07-05 13:32 adrianromero Status new => scheduled
2010-07-05 13:32 adrianromero fix_in_branch => pi
2010-07-06 11:51 hgbot Checkin
2010-07-06 11:51 hgbot Note Added: 0029087
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: 0029117
2010-07-12 16:02 hgbot Checkin
2010-07-12 16:02 hgbot Note Added: 0029236
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:17 adrianromero Relationship added related to 0013943
2010-07-14 04:43 hudsonbot Checkin
2010-07-14 04:43 hudsonbot Note Added: 0029285
2010-07-23 11:18 psarobe Note Added: 0029512
2010-07-23 11:18 psarobe Status resolved => closed
2010-07-23 11:25 networkb Note Added: 0029518
2010-07-24 00:00 anonymous sf_bug_id 0 => 3033796
2010-08-19 10:53 adrianromero Relationship added related to 0013900
2010-09-09 13:12 adrianromero Relationship added depends on 0013361
2010-09-09 13:12 adrianromero Relationship deleted depends on 0013361
2010-09-09 13:13 adrianromero Relationship added related to 0013361
2018-12-26 16:03 Sandrahuguet Relationship added related to 0039712

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker