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

Description

Goods shipment is not creating every lines from an order with +5000 lines. It creates only the 4992 first ones.

Steps To Reproduce

** First of all, could be useful to activate the 'Lines quantity to count per Window' preference for [Sales Order] and [Goods Shipment] windows:

Logged as F&B Admin:
- Property: Lines quantity to count per Window
  - Value: 10000
  - Organization: *
  - Window: Sales Order / Goods Shipment.

This way, we can see the total amount of lines in both windows.

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. Wait the records to be loaded and select some warehouse position.
Finally, select every fields and press OK button.

--> Only 4992 records are created.

Tags

No tags attached.

Attached Files

Screenshot from 2017-07-13 16-33-39.png [^] (161,029 bytes) 2017-07-13 16:33

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

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

design defect

0036492

new

Triage Omni OMS

Create From does not perform for high number of lines

Notes
(0098074) alostale (manager) 2017-07-14 10:45	This is caused by default Tomcat configuration that prevents parsing more than 10K parameters. Note that first time this occurs this message is logged in catalina.out: INFO: More than the maximum number of request parameters (GET plus POST) for a single request ([10,000]) were detected. Any parameters beyond this limit have been ignored. To change this limit, set the maxParameterCount attribute on the Connector. Note: further occurrences of this error will be logged at DEBUG level. Till issue 0036492 is fixed, this can be workarrounded setting maxParameterCount="-1" in Tomcat's Connector (see doc [1]). [1] https://tomcat.apache.org/tomcat-7.0-doc/config/http.html#Common_Attributes [^]

Issue History
Date Modified	Username	Field	Change
2017-07-13 16:33	JONHM	New Issue
2017-07-13 16:33	JONHM	Assigned To	=> platform
2017-07-13 16:33	JONHM	File Added: a_createlines
2017-07-13 16:33	JONHM	Modules	=> Core
2017-07-13 16:33	JONHM	Resolution time	=> 1501711200
2017-07-13 16:33	JONHM	Triggers an Emergency Pack	=> No
2017-07-13 16:33	JONHM	File Added: Screenshot from 2017-07-13 16-33-39.png
2017-07-13 16:34	JONHM	Steps to Reproduce Updated	View Revisions
2017-07-13 16:36	JONHM	Steps to Reproduce Updated	View Revisions
2017-07-14 10:34	alostale	File Deleted: a_createlines
2017-07-14 10:34	alostale	File Added: a_createlines.sql
2017-07-14 10:35	alostale	Steps to Reproduce Updated	View Revisions
2017-07-14 10:42	alostale	Relationship added	related to 0036492
2017-07-14 10:45	alostale	Note Added: 0098074
2017-07-14 10:45	alostale	Status	new => closed
2017-07-14 10:45	alostale	Resolution	open => no change required