Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008714Openbravo ERP02. Master data managementpublic2009-04-22 18:062009-06-19 00:00
Reporterjtarbal 
Assigned Toshuehner 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50 
Target VersionFixed in Versionpi 
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
Summary0008714: Business Partner print icon pop-up: drilldown of categories is slow
DescriptionThe pop-up window that appears when clicking on the print icon of the business partner window does not work properly. The orders, shipments/receipts and invoices summary does not work properly. The expand + that appears does not work.

It has been tested with the Mozilla Firefox 3.0 and with Internet Explorer 7.0 and in both cases the behavior is the same.
Steps To Reproduce1) Go to Master Data Management || Business Partner
2) Select a customer business partner
3) Click on Print icon
4) Click on [+] icons in the business partner card

They do work but their load time is very high. Have a look at Firebug call in the screenshot.
Proposed Solution
Additional Information
Tags250MP1
Relationships
related to defect 0009489 closed shuehner api check: build 48 failed 
Attached Filespng BPCard.png (86,712) 2009-04-23 10:06
https://issues.openbravo.com/file_download.php?file_id=1213&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-04-22 18:06jtarbalNew Issue
2009-04-22 18:06jtarbalAssigned To => rafaroda
2009-04-23 10:06rafarodaAssigned Torafaroda => gmauleon
2009-04-23 10:06rafarodaPrioritynormal => high
2009-04-23 10:06rafarodaSeverityminor => major
2009-04-23 10:06rafarodaStatusnew => scheduled
2009-04-23 10:06rafarodaProposed Solution updated
2009-04-23 10:06rafarodaFile Added: BPCard.png
2009-04-23 16:04psarobeTag Attached: 250MP1
2009-04-24 11:23psarobePriorityhigh => urgent
2009-04-24 16:31rafarodaAssigned Togmauleon => iperdomo
2009-05-18 10:19iciordiaAssigned Toiperdomo => shuehner
2009-06-10 18:21shuehnerNote Added: 0017192
2009-06-10 18:21shuehnerSummaryBusiness Partner print icon pop-up does not work properly => Business Partner print icon pop-up: drilldown of categories is slow
2009-06-15 14:00shuehnerNote Added: 0017306
2009-06-15 20:05hgbotCheckin
2009-06-15 20:05hgbotNote Added: 0017331
2009-06-15 20:05hgbotStatusscheduled => resolved
2009-06-15 20:05hgbotResolutionopen => fixed
2009-06-15 20:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a836d5327749d2534dd9ff5fce5f4a6bdcc69559 [^]
2009-06-16 01:21shuehnerRelationship addedrelated to 0009489
2009-06-18 07:14sureshbabuNote Added: 0017413
2009-06-18 07:14sureshbabuStatusresolved => closed
2009-06-18 07:14sureshbabuFixed in Version => pi
2009-06-19 00:00anonymoussf_bug_id0 => 2808686

Notes
(0017192)
shuehner   
2009-06-10 18:21   
Update summary based on info in the description provided. The popup does work but openining the 2 ajax-based categories is slow.
(0017306)
shuehner   
2009-06-15 14:00   
Not reproducible on oracle.
Reproducible on postgres. Cause bad performance of the view AD_INTEGER used in the query for this page.
(0017331)
hgbot   
2009-06-15 20:05   
Repository: erp/devel/pi
Changeset: a836d5327749d2534dd9ff5fce5f4a6bdcc69559
Author: Stefan Huehner <stefan.huehner <at> openbravo.com>
Date: Mon Jun 15 20:05:06 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a836d5327749d2534dd9ff5fce5f4a6bdcc69559 [^]

Fixed 8714: Speed up ad_integer view on postgres thus improving performance of BP print view
- Split ad_integer in one definition for oracle/postgres each
- oracle definition unchanged
- new postgres definition using generate_series function

---
M src-db/database/model/postscript-Oracle.sql
M src-db/database/model/postscript-PostgreSql.sql
M src-db/src/com/openbravo/db/OpenbravoExcludeFilter.java
R src-db/database/model/views/AD_INTEGER.xml
---
(0017413)
sureshbabu   
2009-06-18 07:14   
Tested working fine