Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029218Openbravo ERP04. Warehouse managementpublic2015-03-10 12:542015-03-25 22:20
Reporterngarcia 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelPre packaging ( pi )
Regression date2014-01-21
Regression introduced in releasepi
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/7091c40b9be09114b26b6cefeb45bc30c2650bf3 [^]
Triggers an Emergency PackNo
Summary0029218: Cannot save a Stock Reservation in PostgreSQL 8.4
DescriptionCannot save a Stock Reservation in PostgreSQL 8.4
Steps To ReproduceAs group admin role:
   Create the Enable Stock Reservations preference
   Log out and log in again
   Create a record in the Stock Reservation window
   Check you get the following error when saving it
      "Saving failed. ERROR: record "old" is not assigned yet Detail: The tuple structure of a not-yet-assigned record is indeterminate. Where: PL/pgSQL function "m_reservation_trg" line 49 at IF"
   
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by defect 0027160 closed eduardo_Argal C_Order_Post poor performance 
related to design defect 00280513.0PR15Q2 closed umartirena Reserved quantity is not correct under certain circumstancies 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-03-10 12:54ngarciaNew Issue
2015-03-10 12:54ngarciaAssigned To => eduardo_Argal
2015-03-10 12:54ngarciaModules => Core
2015-03-10 12:54ngarciaRegression date => 2014-01-21
2015-03-10 12:54ngarciaRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/7091c40b9be09114b26b6cefeb45bc30c2650bf3 [^]
2015-03-10 12:54ngarciaTriggers an Emergency Pack => No
2015-03-10 12:55ngarciaIssue Monitored: networkb
2015-03-10 12:57ngarciaRelationship addedcaused by 0027160
2015-03-10 13:56eduardo_ArgalStatusnew => scheduled
2015-03-18 08:53SandrahuguetRegression level => Pre packaging ( pi )
2015-03-18 08:53SandrahuguetRegression introduced in release => pi
2015-03-25 13:17vmromanosRelationship addedrelated to 0028051
2015-03-25 13:57umartirenaReview Assigned To => vmromanos
2015-03-25 16:20hgbotCheckin
2015-03-25 16:20hgbotNote Added: 0075971
2015-03-25 16:20hgbotStatusscheduled => resolved
2015-03-25 16:20hgbotResolutionopen => fixed
2015-03-25 16:20hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/81d75586c6c4ee2d4a50893d41acff985ae7acb6 [^]
2015-03-25 16:20hgbotCheckin
2015-03-25 16:20hgbotNote Added: 0075972
2015-03-25 16:22vmromanosNote Added: 0075973
2015-03-25 16:22vmromanosStatusresolved => closed
2015-03-25 22:20hudsonbotCheckin
2015-03-25 22:20hudsonbotNote Added: 0075985
2015-03-25 22:20hudsonbotCheckin
2015-03-25 22:20hudsonbotNote Added: 0075986

Notes
(0075971)
hgbot   
2015-03-25 16:20   
Repository: erp/devel/pi
Changeset: 81d75586c6c4ee2d4a50893d41acff985ae7acb6
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Mar 10 13:57:41 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/81d75586c6c4ee2d4a50893d41acff985ae7acb6 [^]

Fixes issue 29218
Cannot save a Stock Reservation in PostgreSQL 8.4. 'If' changed inside trigger

---
M src-db/database/model/triggers/M_RESERVATION_TRG.xml
---
(0075972)
hgbot   
2015-03-25 16:20   
Repository: erp/devel/pi
Changeset: b4859e1bdcf62a02524ec3f7c5363b6888aa6564
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Wed Mar 25 16:02:54 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b4859e1bdcf62a02524ec3f7c5363b6888aa6564 [^]

Related to issue 29218: fixed bug detected in code review:
pl/sql variable assignment is := instead of =

---
M src-db/database/model/triggers/M_RESERVATION_TRG.xml
---
(0075973)
vmromanos   
2015-03-25 16:22   
Code review + testing OK
(0075985)
hudsonbot   
2015-03-25 22:20   
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/9000460ae66d [^]
Maturity status: Test
(0075986)
hudsonbot   
2015-03-25 22:20   
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/9000460ae66d [^]
Maturity status: Test