Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018639Openbravo ERP07. Sales managementpublic2011-09-28 12:562011-11-04 13:57
Reportermirurita 
Assigned Toxabiermerino 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP5Fixed 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
Summary0018639: 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
depends on backport 00187212.50MP36 closed xabiermerino Create Shipments from Orders fails when you select a big number of orders 
Attached Filespng Generar albaranes (manualmente) .png (143,971) 2011-09-28 12:56
https://issues.openbravo.com/file_download.php?file_id=4600&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2011-09-28 12:56miruritaNew Issue
2011-09-28 12:56miruritaAssigned To => jonalegriaesarte
2011-09-28 12:56miruritaFile Added: Generar albaranes (manualmente) .png
2011-09-28 12:56miruritaModules => Core
2011-09-28 12:56miruritaResolution time => 1320102000
2011-10-06 13:30miruritaAssigned Tojonalegriaesarte => mirurita
2011-10-06 13:30miruritaStatusnew => scheduled
2011-10-06 13:30miruritafix_in_branch => pi
2011-10-17 19:45jonalegriaesarteAssigned Tomirurita => xabiermerino
2011-10-17 19:46jonalegriaesarteTarget Version => 3.0MP5
2011-10-17 19:46jonalegriaesartefix_in_branchpi =>
2011-10-27 18:28hgbotCheckin
2011-10-27 18:28hgbotNote Added: 0042169
2011-10-27 18:28hgbotStatusscheduled => resolved
2011-10-27 18:28hgbotResolutionopen => fixed
2011-10-27 18:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/651482348d7bcbf3d0231bf1ad4e5939a270c4cd [^]
2011-11-02 18:32miruritaNote Added: 0042472
2011-11-02 18:32miruritaStatusresolved => closed
2011-11-04 13:57hudsonbotCheckin
2011-11-04 13:57hudsonbotNote Added: 0042584

Notes
(0042169)
hgbot   
2011-10-27 18:28   
Repository: erp/devel/pi
Changeset: 651482348d7bcbf3d0231bf1ad4e5939a270c4cd
Author: Xabier Merino <xabier.merino <at> openbravo.com>
Date: Thu Oct 27 18:23:21 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/651482348d7bcbf3d0231bf1ad4e5939a270c4cd [^]

Fixed issue 18639: Create Shipments from Orders fails

---
M src-db/database/model/functions/M_INOUT_CREATE.xml
---
(0042472)
mirurita   
2011-11-02 18:32   
Verified.
(0042584)
hudsonbot   
2011-11-04 13:57   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/d10da320df2a [^]

Maturity status: Test