0036492: Create From does not perform for high number of lines

Description

Create From process does not perform well when trying to add a high number of lines.

Steps To Reproduce

1) Create a new [Sales Order] for 'Alimentos y Supermercados' business partner. Then, create a new line of 'Agua sin gas 1L' product.

2) Run the attached script in database to create 7000 lines for the previous order
Then run the following command to execute the function:
select a_createlines();

3) Go back to [Sales Order] window and book the previous order.

4) Open [Goods Shipment] window and create a new shipment for 'Alimentos y Supermercados' business partner. Then press button 'Create Lines From', and select the previously booked order.

-> Lines are requested without pagination, in this case >10MB are retrieved taking >10s

5) Select some warehouse position. Finally, select every fields and press OK button.

-> More than 10K paramters are sent backend, with default tomcat config, after parsing 10K, the rest is silently ignored, see 0036490

Tags

No tags attached.

Attached Files

a_createlines.sql [^] (2,617 bytes) 2017-07-14 10:42

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0036490

closed

platform

Goods shipment is not creating every lines from an order with +5000 lines

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2017-07-14 10:42	alostale	New Issue
2017-07-14 10:42	alostale	Assigned To	=> Triage Finance
2017-07-14 10:42	alostale	Modules	=> Core
2017-07-14 10:42	alostale	Triggers an Emergency Pack	=> No
2017-07-14 10:42	alostale	Relationship added	related to 0036490
2017-07-14 10:42	alostale	File Added: a_createlines.sql