Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0036490Openbravo ERPA. Platformpublic2017-07-13 16:332017-07-14 10:45
ReporterJONHM 
Assigned Toplatform 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0036490: Goods shipment is not creating every lines from an order with +5000 lines
DescriptionGoods 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0036492 new Triage Omni OMS Create From does not perform for high number of lines 
Attached Filespng Screenshot from 2017-07-13 16-33-39.png (161,029) 2017-07-13 16:33
https://issues.openbravo.com/file_download.php?file_id=10911&type=bug
png

? a_createlines.sql (2,617) 2017-07-14 10:34
https://issues.openbravo.com/file_download.php?file_id=10912&type=bug
Issue History
Date ModifiedUsernameFieldChange
2017-07-13 16:33JONHMNew Issue
2017-07-13 16:33JONHMAssigned To => platform
2017-07-13 16:33JONHMFile Added: a_createlines
2017-07-13 16:33JONHMModules => Core
2017-07-13 16:33JONHMResolution time => 1501711200
2017-07-13 16:33JONHMTriggers an Emergency Pack => No
2017-07-13 16:33JONHMFile Added: Screenshot from 2017-07-13 16-33-39.png
2017-07-13 16:34JONHMSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=15503#r15503
2017-07-13 16:36JONHMSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=15504#r15504
2017-07-14 10:34alostaleFile Deleted: a_createlines
2017-07-14 10:34alostaleFile Added: a_createlines.sql
2017-07-14 10:35alostaleSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=15509#r15509
2017-07-14 10:42alostaleRelationship addedrelated to 0036492
2017-07-14 10:45alostaleNote Added: 0098074
2017-07-14 10:45alostaleStatusnew => closed
2017-07-14 10:45alostaleResolutionopen => no change required

Notes
(0098074)
alostale   
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 [^]