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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009943
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajorhave not tried2009-07-17 15:472009-07-22 00:00
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version2.50MP3
StatusclosedFix in branchFixed in SCM revisionef1ab5f65d1b
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009943: ReportSalesOrderProvidedJR (Delivered Sales Order Report) does not work with many products.

DescriptionWhen trying to use this report with i.e 100k products (but probably even with less) the system just uses 100% cpu in the java process and you do never (waited for >=5min) a result.

In addition the product category filter does not work (it is ignored)
Steps To ReproduceUse the database with many products
Go to Sales Management
Go to Analysis tools
Go to Delivered Sales Order report

The parameter page of the report will not appear and the tomcat process will use up 100% cpu for a long time.
Tags250MP3releasecandidate
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0009940 closedshuehner ReportSalesOrderInvoicedJasper does not work with many products... 
depends on backport 0009944 closedshuehner ReportSalesOrderProvidedJR (Delivered Sales Order Report) does not work with many products. 

-  Notes
(0018379)
shuehner (administrator)
2009-07-17 16:16

@qa: testing needed: if the report is working fine, especially with regards, to display of the product categories in the dropdown of the filter window and if filtering by product category and/or product is working fine.
(0018383)
hgbot (developer)
2009-07-17 17:43

Repository: erp/devel/pi
Changeset: ef1ab5f65d1bfffaa89fdb15a84e29a8027a78e9
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Fri Jul 17 16:53:40 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ef1ab5f65d1bfffaa89fdb15a84e29a8027a78e9 [^]

Fixed 9943: Fix Delivered Sales Order Report with many products, Fix product category filter in same report
- remove (unused) javascript array containing all products
- removed two unsused structure from xmlEngine control file containing categories & products
- remove onchange event on product category combo
- fix name+id no product category combo

---
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.xml
---
(0018506)
psarobe (manager)
2009-07-21 17:51

Tested works fine

- Issue History
Date Modified Username Field Change
2009-07-17 15:47 shuehner New Issue
2009-07-17 15:47 shuehner Assigned To => shuehner
2009-07-17 15:48 shuehner Relationship added related to 0009940
2009-07-17 15:48 shuehner Status new => scheduled
2009-07-17 15:48 shuehner fix_in_branch => pi
2009-07-17 16:16 shuehner Note Added: 0018379
2009-07-17 16:16 shuehner fix_in_branch pi =>
2009-07-17 16:16 shuehner Description Updated
2009-07-17 17:43 hgbot Checkin
2009-07-17 17:43 hgbot Note Added: 0018383
2009-07-17 17:43 hgbot Status scheduled => resolved
2009-07-17 17:43 hgbot Resolution open => fixed
2009-07-17 17:43 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ef1ab5f65d1bfffaa89fdb15a84e29a8027a78e9 [^]
2009-07-21 16:24 psarobe Fixed in Version => 2.50MP3
2009-07-21 16:26 psarobe Tag Attached: 250MP3releasecandidate
2009-07-21 17:51 psarobe Status resolved => closed
2009-07-21 17:51 psarobe Note Added: 0018506
2009-07-22 00:00 anonymous sf_bug_id 0 => 2825071


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker