Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018721Openbravo ERP07. Sales managementpublic2011-09-28 12:562011-11-09 18:16
Reportermirurita 
Assigned Toxabiermerino 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP34 
Target Version2.50MP36Fixed 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
Summary0018721: Create Shipments from Orders fails when you select a big number of orders
DescriptionCreate 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 Reproduce1) 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 Solutiontruncate the v_Message string if it will be longer than 2000 characters.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00186393.0MP5 closed xabiermerino Create Shipments from Orders fails when you select a big number of orders 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-10-06 13:30miruritaTypedefect => backport
2011-10-06 13:30miruritafix_in_branch => 2.50
2011-10-17 19:45jonalegriaesarteAssigned Tomirurita => xabiermerino
2011-10-17 19:46jonalegriaesarteversionpi => 2.50MP34
2011-10-17 19:46jonalegriaesarteTarget Version => 2.50MP36
2011-11-07 09:54hgbotCheckin
2011-11-07 09:54hgbotNote Added: 0042644
2011-11-07 09:54hgbotStatusscheduled => resolved
2011-11-07 09:54hgbotResolutionopen => fixed
2011-11-07 09:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/9f0bcc77b980b0a671913e44075236d6e36402c7 [^]
2011-11-09 18:16miruritaStatusresolved => closed

Notes
(0042644)
hgbot   
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
---