0035682: Return From Customer pick and edit is very slow with big data - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

ID

Project

Category

View Status

Date Submitted

Last Update

0035682

Openbravo ERP

07. Sales management

public

2017-04-04 11:38

2017-05-29 17:43

Reporter

JONHM

Assigned To

markmm82

Priority

high

Severity

major

Reproducibility

sometimes

Status

closed

Resolution

fixed

Platform

OS

5

OS Version

Product Version

3.0PR16Q4.2

Target Version

Fixed in Version

3.0PR17Q3

Merge Request Status

Review Assigned To

aferraz

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0035682: Return From Customer pick and edit is very slow with big data

Description

with big data, the query executed during pick&edit process, in Return From Customer window, the response time is high, almost 3 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 34031, but the problem persists

Steps To Reproduce

with big data
go to Return From Customer window
select the record of Business Partner 'CC000 - Cliente Publico'
click in pick & Edit process

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0034031		closed	AtulOpenbravo	Return From Customer pick and edit is very slow with big data
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	0034839		closed	rqueralta	Not possible to select a shipment in RFC window if that shipment has not been created from an order.
related to	design defect	0034612	3.0PR17Q1	closed	vmromanos	Performance problem in Return To Vendor Shipment
has duplicate	defect	0037088		closed	Triage Omni OMS	Pick and edit of return to vendor not working properly
blocks	design defect	0039815		scheduled	markmm82	Module script UpdateIsCompletelyInvoiced cannot be executed due to poor performance

Attached Files

txt

RFCperformance.txt (47,041) 2017-04-04 11:38
https://issues.openbravo.com/file_download.php?file_id=10645&type=bug

Issue History

Date Modified

Username

Field

Change

2017-04-04 11:38

New Issue

2017-04-04 11:38

Assigned To

=> Triage Finance

2017-04-04 11:38

File Added: RFCperformance.txt

2017-04-04 11:38

Modules

=> Core

2017-04-04 11:38

Resolution time

=> 1493071200

2017-04-04 11:38

Triggers an Emergency Pack

=> No

2017-04-04 12:26

Relationship added

related to 0034031

2017-04-04 12:26

Relationship added

related to 0032949

2017-04-04 12:28

Relationship added

related to 0034839

2017-04-04 12:29

Relationship added

related to 0034612

2017-04-04 12:31

Assigned To

Triage Finance => markmm82

2017-04-04 16:56

Issue Monitored: heccam

2017-04-17 18:37

Status

new => scheduled

2017-04-27 17:11

Note Added: 0096236

2017-04-27 21:01

Checkin

2017-04-27 21:01

Note Added: 0096241

2017-04-27 21:01

Status

scheduled => resolved

2017-04-27 21:01

Resolution

open => fixed

2017-04-27 21:01

Fixed in SCM revision

=> http://code.openbravo.com/erp/devel/pi/rev/3f0bb1b574c3f9c2c6ea59f41c0548c977a8f013 [^]

2017-04-27 21:06

Review Assigned To

=> aferraz

2017-04-27 21:06

Note Added: 0096244

2017-04-27 21:06

Status

resolved => closed

2017-04-27 21:06

Fixed in Version

=> 3.0PR17Q3

2017-05-29 17:43

Checkin

2017-05-29 17:43

Note Added: 0096913

2017-10-24 12:35

Relationship added

has duplicate 0037088

2018-12-17 12:34

Relationship added

blocks 0039815

Notes

In environment with big data

Test Plan 1:
  Go to Return From Customer window
  Select the record of Business Partner 'CC000 - Cliente Publico'
  Click in pick & Edit process and notice grid is loaded in about 7 seconds.

Test Plan 2 (testing scenario of 34839):
As F&B International Group Admin

- Go to Product window
   Create a new one named Product 1 for F&B España.
   Enter a purchase price list (Tarifa Bebidas Alegres) and a sales price list (Tarifa de Ventas) in tab "Price".
   Enter any unit and list price.

- Go to Purchase Order window
   Create a new one for F&B España, Bebidas Alegres business partner.
   Go to Lines and select the product. Enter an ordered Qty = 500 Units.
   Book the order.

- Go to Goods Receipt window
   Create a new one for F&B España, Bebidas Alegres business partner.
   Use Create Lines From. Select the order. Enter a storage bin (RN-0-0-0) and receipt all quanity.
   Complete the receipt.

- Go to Sales Order window
   Create a new one for F&B España, Alimentos y Supermercados business partner.
   Go to Lines and select Product 1. Enter an ordered quantity = 10.
   Book the order.

- Go to Goods Shipment window
   Create a new one for F&B España, Alimentos y Supermercados business partner.
   Use Create Lines From. Select the sales order just created. Enter a warehouse position RN-0-0-0, and select all lines. Press OK.
   Complete the shipment. Write down shipment order number 210, for instance.

- In Goods Shipment window create another one for F&B España, Alimentos y Supermercados business partner.
   Go to lines tab and create a new one. Select Product 1. Change Movement quantity to 15. Storage bin RN-0-0-0.
   Complete the shipment. Write down shipment order number 211, for instance.

- Go to Return from Customer window
   Create a new one for F&B España, Alimentos y Supermercados business partner.
   Click on Pick/Edit Lines.

- Verify that shipment number 210 (the one created from the sales order) is shown, and that shipment number 211 (the one created from scrath) is shown too.