0018721: Create Shipments from Orders fails when you select a big number of orders

Description

Create Shipments from Orders process fails when you select a big number of orders.

~50 orders

oracle: @ERROR=ORA-06502: PL/SQL: numeric or value error: character string buffer too small

postgresql: value too long for type character varying(2000)

M_INOUT_CREATE procedure

Line 804
v_Message := 'First ' || v_logLines || ' result(s):' || '
' || v_Message;

when trying to concatenate v_Message variable with a 23 character ('First ' || v_logLines || ' result(s):' || '
') string it fails if the length of both is higher than 2000.

The v_Message variable is declared as v_Message VARCHAR2(2000):='';

Steps To Reproduce

1) Create 50 orders an set invoice terms: immediate
2) Go to Create Shipments from Orders
3) Select the organization filter and search
4) Select previously created 50 orders
5) Click on Process button

You will see an error

Proposed Solution

truncate the v_Message string if it will be longer than 2000 characters.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0018639

3.0MP5

closed

xabiermerino

Create Shipments from Orders fails when you select a big number of orders

Notes
(0042644) hgbot (developer) 2011-11-07 09:54	Repository: erp/stable/2.50 Changeset: 9f0bcc77b980b0a671913e44075236d6e36402c7 Author: Xabier Merino <xabier.merino <at> openbravo.com> Date: Mon Nov 07 09:53:15 2011 +0100 URL: http://code.openbravo.com/erp/stable/2.50/rev/9f0bcc77b980b0a671913e44075236d6e36402c7 [^] Fixed issue 18721. Create Shipments from Orders fails --- M src-db/database/model/functions/M_INOUT_CREATE.xml ---

Issue History
Date Modified	Username	Field	Change
2011-10-06 13:30	mirurita	Type	defect => backport
2011-10-06 13:30	mirurita	fix_in_branch	=> 2.50
2011-10-17 19:45	jonalegriaesarte	Assigned To	mirurita => xabiermerino
2011-10-17 19:46	jonalegriaesarte	version	pi => 2.50MP34
2011-10-17 19:46	jonalegriaesarte	Target Version	=> 2.50MP36
2011-11-07 09:54	hgbot	Checkin
2011-11-07 09:54	hgbot	Note Added: 0042644
2011-11-07 09:54	hgbot	Status	scheduled => resolved
2011-11-07 09:54	hgbot	Resolution	open => fixed
2011-11-07 09:54	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.50/rev/9f0bcc77b980b0a671913e44075236d6e36402c7 [^]
2011-11-09 18:16	mirurita	Status	resolved => closed