Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0018639
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2011-09-28 12:562011-11-04 13:57
ReportermiruritaView Statuspublic 
Assigned Toxabiermerino 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision651482348d7b
ProjectionnoneETAnoneTarget Version3.0MP5
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket12754
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018639: 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.
TagsNo tags attached.
Attached Filespng file icon Generar albaranes (manualmente) .png [^] (143,971 bytes) 2011-09-28 12:56

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 00187212.50MP36 closedxabiermerino Create Shipments from Orders fails when you select a big number of orders 

-  Notes
(0042169)
hgbot (developer)
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 (viewer)
2011-11-02 18:32

 Verified.
(0042584)
hudsonbot (viewer)
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

- Issue History
Date Modified Username Field Change
2011-09-28 12:56 mirurita New Issue
2011-09-28 12:56 mirurita Assigned To => jonalegriaesarte
2011-09-28 12:56 mirurita File Added: Generar albaranes (manualmente) .png
2011-09-28 12:56 mirurita Modules => Core
2011-09-28 12:56 mirurita OBNetwork customer => Yes
2011-09-28 12:56 mirurita Support ticket => 12754
2011-09-28 12:56 mirurita Resolution time => 1320102000
2011-10-06 13:30 mirurita Assigned To jonalegriaesarte => mirurita
2011-10-06 13:30 mirurita Status new => scheduled
2011-10-06 13:30 mirurita fix_in_branch => pi
2011-10-17 19:45 jonalegriaesarte Assigned To mirurita => xabiermerino
2011-10-17 19:46 jonalegriaesarte Target Version => 3.0MP5
2011-10-17 19:46 jonalegriaesarte fix_in_branch pi =>
2011-10-27 18:28 hgbot Checkin
2011-10-27 18:28 hgbot Note Added: 0042169
2011-10-27 18:28 hgbot Status scheduled => resolved
2011-10-27 18:28 hgbot Resolution open => fixed
2011-10-27 18:28 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/651482348d7bcbf3d0231bf1ad4e5939a270c4cd [^]
2011-11-02 18:32 mirurita Note Added: 0042472
2011-11-02 18:32 mirurita Status resolved => closed
2011-11-04 13:57 hudsonbot Checkin
2011-11-04 13:57 hudsonbot Note Added: 0042584

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker