Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0036492Openbravo ERP07. Sales managementpublic2017-07-14 10:422017-07-14 10:42
alostale 
Triage Omni OMS 
normalmajorhave not tried
newopen 
5
 
 
Core
No
0036492: Create From does not perform for high number of lines
Create From process does not perform well when trying to add a high number of lines.
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
No tags attached.
related to defect 0036490 closed platform Goods shipment is not creating every lines from an order with +5000 lines 
? a_createlines.sql (2,617) 2017-07-14 10:42
https://issues.openbravo.com/file_download.php?file_id=10913&type=bug
Issue History
2017-07-14 10:42alostaleNew Issue
2017-07-14 10:42alostaleAssigned To => Triage Finance
2017-07-14 10:42alostaleModules => Core
2017-07-14 10:42alostaleTriggers an Emergency Pack => No
2017-07-14 10:42alostaleRelationship addedrelated to 0036490
2017-07-14 10:42alostaleFile Added: a_createlines.sql

There are no notes attached to this issue.