Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021585Openbravo ERP07. Sales managementpublic2012-09-10 10:582012-09-26 17:31
Reporteregoitz 
Assigned ToioritzCia 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP12 
Target Version3.0MP15Fixed in Version3.0MP15 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression levelProduction - QA Approved
Regression date2012-05-09
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/8b2d0f4ae3fe [^]
Triggers an Emergency Packyes
Summary0021585: Not possible to complete some good shipment susing a product whose name is longer than 40 characters
DescriptionNot possible to complete somegood shipments using a product whose name is longer than 40 characters
Steps To Reproduce-Define a product with a name with more than 40 characters and under some concrete conditions it can not be completed.

SEe that line on the m_inout_post
 SELECT name INTO v_ProductName FROM M_Product WHERE M_Product_id = Cur_InOutLine.M_Product_ID;

v_ProductName is defined with length 40 and m_product.name column has lenght 60.
Proposed SolutionModify the variable v_ProductName to at leaset 60 characters.

For the cases where the client has increase the lenght to a higher value that solution won't work so a trunc could be usefull.
Additional Information
TagsNo tags attached.
Relationships
related to defect 00202803.0MP12 closed ioritzCia Insufficient stock message needs to be improved 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-09-10 10:58egoitzNew Issue
2012-09-10 10:58egoitzAssigned To => dmiguelez
2012-09-10 10:58egoitzModules => Core
2012-09-10 10:58egoitzOBNetwork customer => Yes
2012-09-10 11:00egoitzPriorityurgent => immediate
2012-09-10 11:29egoitzAssigned Todmiguelez => ioritzCia
2012-09-10 11:32shuehnerIssue Monitored: shuehner
2012-09-10 12:13egoitzRegression level => Production - Confirmed Stable
2012-09-10 12:13egoitzRegression date => 2012-05-09
2012-09-10 12:13egoitzRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/8b2d0f4ae3fe [^]
2012-09-10 12:17egoitzRegression levelProduction - Confirmed Stable => Production - QA Approved
2012-09-10 12:49ioritzCiaRelationship addedrelated to 0020280
2012-09-10 12:53hgbotCheckin
2012-09-10 12:53hgbotNote Added: 0051955
2012-09-10 12:53hgbotStatusnew => resolved
2012-09-10 12:53hgbotResolutionopen => fixed
2012-09-10 12:53hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f81066133c89f108434089a156458cb12f8984b7 [^]
2012-09-10 12:54ioritzCiaNote Added: 0051956
2012-09-10 12:54ioritzCiaStatusresolved => new
2012-09-10 12:54ioritzCiaResolutionfixed => open
2012-09-10 12:54ioritzCiaStatusnew => scheduled
2012-09-10 12:54ioritzCiafix_in_branch => pi
2012-09-10 12:55ioritzCiaStatusscheduled => resolved
2012-09-10 12:55ioritzCiaResolutionopen => fixed
2012-09-10 13:15ioritzCiaStatusresolved => new
2012-09-10 13:15ioritzCiaResolutionfixed => open
2012-09-10 13:16ioritzCiaNote Added: 0051957
2012-09-10 13:16ioritzCiaversion3.0MP14 => 3.0MP12
2012-09-10 13:16ioritzCiafix_in_branchpi =>
2012-09-10 13:16ioritzCiaStatusnew => scheduled
2012-09-10 13:16ioritzCiafix_in_branch => pi
2012-09-10 13:17ioritzCiaStatusscheduled => resolved
2012-09-10 13:17ioritzCiaResolutionopen => fixed
2012-09-10 18:21egoitzClosed by => egoitz
2012-09-10 18:21egoitzNote Added: 0051976
2012-09-10 18:21egoitzStatusresolved => closed
2012-09-10 18:21egoitzFixed in Version => 3.0MP15
2012-09-26 17:15hgbotCheckin
2012-09-26 17:15hgbotNote Added: 0052658
2012-09-26 17:15hgbotStatusclosed => resolved
2012-09-26 17:15hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/f81066133c89f108434089a156458cb12f8984b7 [^] => http://code.openbravo.com/erp/devel/pi/rev/1b6fa27a5aa452adbe3448e2748fbafcb01d5291 [^]
2012-09-26 17:18hudsonbotCheckin
2012-09-26 17:18hudsonbotNote Added: 0052721
2012-09-26 17:31gorka_gilStatusresolved => closed

Notes
(0051955)
hgbot   
2012-09-10 12:53   
Repository: erp/devel/pi
Changeset: f81066133c89f108434089a156458cb12f8984b7
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Mon Sep 10 12:49:12 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f81066133c89f108434089a156458cb12f8984b7 [^]

Fixes issue 21585: Not possible to complete some good shipment
using a product whose name is longer than 40 characters.

---
M src-db/database/model/functions/M_INOUT_POST.xml
---
(0051956)
ioritzCia   
2012-09-10 12:54   
Testing plan:

- Go to physical inventory and create one.
- In the lines set the product quentity below the one you are going to request. Take care of the warehouse and the bin, they must be the same to be used later.
- Process it.
- Go to product and change the name to be longer than 40 characters.
- Go to Goods Shipment and create one for the product, warehouse and bin previously told.
- Complete it. The message appears.
(0051957)
ioritzCia   
2012-09-10 13:16   
The regression affects from 3.0MP12 to 3.0MP15
(0051976)
egoitz   
2012-09-10 18:21   
verified with the testing plan
(0052658)
hgbot   
2012-09-26 17:15   
Repository: erp/devel/pi
Changeset: 1b6fa27a5aa452adbe3448e2748fbafcb01d5291
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Mon Sep 10 12:49:12 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1b6fa27a5aa452adbe3448e2748fbafcb01d5291 [^]

Fixes issue 21585: Not possible to complete some good shipment
using a product whose name is longer than 40 characters.

---
M src-db/database/model/functions/M_INOUT_POST.xml
---
(0052721)
hudsonbot   
2012-09-26 17:18   
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/b780e90c6452 [^]

Maturity status: Test