Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034031Openbravo ERP07. Sales managementpublic2016-09-20 12:352016-09-29 23:30
Reportermalsasua 
Assigned ToAtulOpenbravo 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q4 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034031: Return From Customer pick and edit is very slow with big data
Descriptionwith big data, the query executed during pick&edit process, in Return From Customer window, the response time is very high, more than 7 minutes.

We have applied the configuration
  - Add restriction in "Product - Pick / Edit Lines - RFC/RTV HQL Pick / Edit Lines" field to "Allow filtering by FK identifier" No
and we have applied the changeset of issue 32949, but the problem persists

Steps To Reproducewith big data
go to Return From Customer window
click in pick & Edit process
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0032949 closed AtulOpenbravo performance problem in pick and execute of Return to Vendor: RFC/RTV HQL Pick / Edit Lines 
related to defect 0035682 closed markmm82 Return From Customer pick and edit is very slow with big data 
causes defect 0034839 closed rqueralta Not possible to select a shipment in RFC window if that shipment has not been created from an order. 
Attached Fileslog logPostgres.log (22,513) 2016-09-20 12:49
https://issues.openbravo.com/file_download.php?file_id=9838&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-09-20 12:35malsasuaNew Issue
2016-09-20 12:35malsasuaAssigned To => Triage Finance
2016-09-20 12:35malsasuaModules => Core
2016-09-20 12:35malsasuaTriggers an Emergency Pack => No
2016-09-20 12:38malsasuaRelationship addedrelated to 0032949
2016-09-20 12:38malsasuaDescription Updatedbug_revision_view_page.php?rev_id=13137#r13137
2016-09-20 12:49malsasuaFile Added: logPostgres.log
2016-09-20 17:04aferrazAssigned ToTriage Finance => AtulOpenbravo
2016-09-28 14:34AtulOpenbravoStatusnew => scheduled
2016-09-29 14:32hgbotCheckin
2016-09-29 14:32hgbotNote Added: 0090375
2016-09-29 14:32hgbotStatusscheduled => resolved
2016-09-29 14:32hgbotResolutionopen => fixed
2016-09-29 14:32hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/17fbbe90b24ed38dc25ff8abdbf759bfffbbd134 [^]
2016-09-29 14:34aferrazReview Assigned To => aferraz
2016-09-29 14:34aferrazNote Added: 0090378
2016-09-29 14:34aferrazStatusresolved => closed
2016-09-29 14:34aferrazFixed in Version => 3.0PR16Q4
2016-09-29 23:30hudsonbotCheckin
2016-09-29 23:30hudsonbotNote Added: 0090394
2017-01-05 19:10markmm82Relationship addedcauses 0034839
2017-04-04 12:26JONHMRelationship addedrelated to 0035682

Notes
(0090375)
hgbot   
2016-09-29 14:32   
Repository: erp/devel/pi
Changeset: 17fbbe90b24ed38dc25ff8abdbf759bfffbbd134
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Sep 28 17:57:08 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/17fbbe90b24ed38dc25ff8abdbf759bfffbbd134 [^]

Fixes issue 34031: Return From Customer pick and edit is slow with big data

Removed unnescessary join with M_Inoutline, M_Inout.
Restructured HQL inserter query for discount using exists clause.

---
M src-db/database/sourcedata/AD_TABLE.xml
M src/org/openbravo/common/datasource/ReturnFromCustomerHQLInserter.java
M src/org/openbravo/common/datasource/ReturnToFromCustomerVendorHQLTransformer.java
---
(0090378)
aferraz   
2016-09-29 14:34   
Code review + Testing OK
(0090394)
hudsonbot   
2016-09-29 23:30   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9f5481831914 [^]
Maturity status: Test