Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032949Openbravo ERPA. Platformpublic2016-05-13 10:492016-06-17 19:38
Reportermalsasua 
Assigned ToAtulOpenbravo 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version3.0PR15Q3.5 
Target VersionFixed in Version3.0PR16Q3 
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
Summary0032949: performance problem in pick and execute of Return to Vendor: RFC/RTV HQL Pick / Edit Lines
Descriptionwith a big data, the pick & edit of return to vendor window, the results are not displayed.

We have applied the configration
  - Add restriction in "Product - Pick / Edit Lines - RFC/RTV HQL Pick / Edit Lines" field to "Allow filtering by FK identifier" No

but the problem persist.
Steps To Reproduce. in a environment with big data (# records):
- m_inoutline: 2.583.661
- m_inout: 647.101
- c_bpartner: 504
- m_product: 5.500

. access to "Return to vendor" window, and click in pick&Edit:
never finished

. to reproduce it, please, contact with MAL. A environment will be provided
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0033191 closed Triage Finance Slow behaviour of Pick/Edit Lines on "Return to vendor" window 
related to defect 0034031 closed AtulOpenbravo Return From Customer pick and edit is very slow with big data 
related to defect 0035682 closed markmm82 Return From Customer pick and edit is very slow with big data 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-05-13 10:49malsasuaNew Issue
2016-05-13 10:49malsasuaAssigned To => platform
2016-05-13 10:49malsasuaModules => Core
2016-05-13 10:49malsasuaResolution time => 1464386400
2016-05-13 10:49malsasuaTriggers an Emergency Pack => No
2016-05-13 10:50malsasuaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=12093#r12093
2016-05-17 10:18alostaleAssigned Toplatform => Triage Finance
2016-05-19 09:20aferrazAssigned ToTriage Finance => AtulOpenbravo
2016-06-03 15:41hgbotCheckin
2016-06-03 15:41hgbotNote Added: 0086991
2016-06-03 15:41hgbotStatusnew => resolved
2016-06-03 15:41hgbotResolutionopen => fixed
2016-06-03 15:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ef154325c6cf3d97d5fd08aaa5a50d496f3e5e0b [^]
2016-06-03 15:41hgbotCheckin
2016-06-03 15:41hgbotNote Added: 0086992
2016-06-03 16:00aferrazReview Assigned To => aferraz
2016-06-03 16:00aferrazNote Added: 0086995
2016-06-03 16:00aferrazStatusresolved => closed
2016-06-03 16:00aferrazFixed in Version => 3.0PR16Q3
2016-06-13 13:15aferrazRelationship addedhas duplicate 0033191
2016-06-17 19:38hudsonbotCheckin
2016-06-17 19:38hudsonbotNote Added: 0087591
2016-06-17 19:38hudsonbotCheckin
2016-06-17 19:38hudsonbotNote Added: 0087592
2016-09-20 12:38malsasuaRelationship addedrelated to 0034031
2017-04-04 12:26aferrazRelationship addedrelated to 0035682

Notes
(0086991)
hgbot   
2016-06-03 15:41   
Repository: erp/devel/pi
Changeset: ef154325c6cf3d97d5fd08aaa5a50d496f3e5e0b
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Jun 01 18:31:57 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/ef154325c6cf3d97d5fd08aaa5a50d496f3e5e0b [^]

Fixes issue 32949: Improve performance in Return to Vendor Pick and Execute

In order to avoid unnecessary joins to M_InoutLine table, replace ol.goodsShipmentLine = iol with ol.goodsShipmentLine.id = iol.

---
M src-db/database/sourcedata/AD_TABLE.xml
M src/org/openbravo/common/datasource/ReturnToFromCustomerVendorHQLTransformer.java
---
(0086992)
hgbot   
2016-06-03 15:41   
Repository: erp/devel/pi
Changeset: f3f815904ffdd66f815aff52f517124413724a3d
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri Jun 03 15:32:03 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f3f815904ffdd66f815aff52f517124413724a3d [^]

Related to issue 32949: Code review improvements

- Use inner join instead of left join between OrderLine and Order tables.
- Avoid unnecessary join with Tax table.
- Add index in M_MatchPO table to M_InoutLine_Id column.

---
M src-db/database/model/tables/M_MATCHPO.xml
M src-db/database/sourcedata/AD_TABLE.xml
M src/org/openbravo/common/datasource/ReturnToFromCustomerVendorHQLTransformer.java
---
(0086995)
aferraz   
2016-06-03 16:00   
Code review + Testing OK
(0087591)
hudsonbot   
2016-06-17 19:38   
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/0dc7be081b1c [^]
Maturity status: Test
(0087592)
hudsonbot   
2016-06-17 19:38   
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/0dc7be081b1c [^]
Maturity status: Test