Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027443Openbravo ERP04. Warehouse managementpublic2014-08-23 17:282014-10-29 17:14
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR15Q1 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027443: pl-function m_inout_updatequantityes has uuid bug
DescriptionThat function has this variable defined

v_Lines_Aux NUMERIC(10) ;

But is using it like this:
128 v_StrSQL:='SELECT MIN(M_INOUTLINE_ID) FROM M_INOUTLINE ';
139 EXECUTE v_StrSQL INTO v_Lines_Aux;
148 WHERE M_INOUTLINE.M_INOUTLINE_ID=v_Lines_Aux;

As it is being used as an uuid.

Note: Used in probably inactive window ("Update attributes from shipment")
only but should be fixed nevertheless to get rid of the errror
Steps To Reproducereview pl body
Proposed Solutionredefine as varchar2(32)
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-08-23 17:28shuehnerNew Issue
2014-08-23 17:28shuehnerAssigned To => dmiguelez
2014-08-23 17:28shuehnerOBNetwork customer => No
2014-08-23 17:28shuehnerModules => Core
2014-08-23 17:28shuehnerTriggers an Emergency Pack => No
2014-08-23 17:29shuehnerNote Added: 0069653
2014-09-03 13:58eduardo_ArgalAssigned Todmiguelez => shuehner
2014-10-08 12:48shuehnerNote Added: 0070807
2014-10-08 12:49shuehnerReview Assigned To => eduardo_Argal
2014-10-08 12:49shuehnerFixed in SCM revision => https://code.openbravo.com/erp/devel/pi/rev/c860b3092ded [^]
2014-10-08 12:49shuehnerStatusnew => scheduled
2014-10-08 12:49shuehnerStatusscheduled => resolved
2014-10-08 12:49shuehnerFixed in Version => 3.0PR15Q1
2014-10-08 12:49shuehnerResolutionopen => fixed
2014-10-29 17:14SandrahuguetReview Assigned Toeduardo_Argal => Sandrahuguet
2014-10-29 17:14SandrahuguetNote Added: 0071250
2014-10-29 17:14SandrahuguetStatusresolved => closed

Notes
(0069653)
shuehner   
2014-08-23 17:29   
Found using plpgsql-check
(0070807)
shuehner   
2014-10-08 12:48   
changeset: 25021:c860b3092ded
tag: tip
user: Stefan Hühner <stefan.huehner@openbravo.com>
date: Tue Oct 07 18:35:13 2014 +0200
files: src-db/database/model/functions/M_INOUT_UPDATEQUANTITYES.xml
description:
Fix 27443. Fix uuid bug in pl-function m_inout_updatequantities
The variable v_lines_aux in that pl-function is defined as numeric(10) but is
clearly used to hold uuid.
Redefine it to have correct datatype.
(0071250)
Sandrahuguet   
2014-10-29 17:14   
Code review + testing Ok