Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009943Openbravo ERP07. Sales managementpublic2009-07-17 15:472009-07-22 00:00
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP3 
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
Summary0009943: 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.
Proposed Solution
Additional Information
Tags250MP3releasecandidate
Relationships
related to defect 0009940 closed shuehner ReportSalesOrderInvoicedJasper does not work with many products... 
depends on backport 0009944 closed shuehner ReportSalesOrderProvidedJR (Delivered Sales Order Report) does not work with many products. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-17 15:47shuehnerNew Issue
2009-07-17 15:47shuehnerAssigned To => shuehner
2009-07-17 15:48shuehnerRelationship addedrelated to 0009940
2009-07-17 15:48shuehnerStatusnew => scheduled
2009-07-17 15:48shuehnerfix_in_branch => pi
2009-07-17 16:16shuehnerNote Added: 0018379
2009-07-17 16:16shuehnerfix_in_branchpi =>
2009-07-17 16:16shuehnerDescription Updated
2009-07-17 17:43hgbotCheckin
2009-07-17 17:43hgbotNote Added: 0018383
2009-07-17 17:43hgbotStatusscheduled => resolved
2009-07-17 17:43hgbotResolutionopen => fixed
2009-07-17 17:43hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ef1ab5f65d1bfffaa89fdb15a84e29a8027a78e9 [^]
2009-07-21 16:24psarobeFixed in Version => 2.50MP3
2009-07-21 16:26psarobeTag Attached: 250MP3releasecandidate
2009-07-21 17:51psarobeStatusresolved => closed
2009-07-21 17:51psarobeNote Added: 0018506
2009-07-22 00:00anonymoussf_bug_id0 => 2825071

Notes
(0018379)
shuehner   
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   
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   
2009-07-21 17:51   
Tested works fine