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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0029218
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2015-03-10 12:542015-03-25 22:20
ReporterngarciaView Statuspublic 
Assigned Toeduardo_Argal 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision81d75586c6c4
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase version8.4.22Ant version
Product VersionSCM revision 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customerNo
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
Summary

0029218: 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"
   
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
caused by defect 0027160 closededuardo_Argal C_Order_Post poor performance 
related to design defect 00280513.0PR15Q2 closedumartirena Reserved quantity is not correct under certain circumstancies 

-  Notes
(0075971)
hgbot (developer)
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 (developer)
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 (viewer)
2015-03-25 16:22

Code review + testing OK
(0075985)
hudsonbot (viewer)
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 (viewer)
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

- Issue History
Date Modified Username Field Change
2015-03-10 12:54 ngarcia New Issue
2015-03-10 12:54 ngarcia Assigned To => eduardo_Argal
2015-03-10 12:54 ngarcia OBNetwork customer => No
2015-03-10 12:54 ngarcia Modules => Core
2015-03-10 12:54 ngarcia Regression date => 2014-01-21
2015-03-10 12:54 ngarcia Regression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/7091c40b9be09114b26b6cefeb45bc30c2650bf3 [^]
2015-03-10 12:54 ngarcia Triggers an Emergency Pack => No
2015-03-10 12:55 ngarcia Issue Monitored: networkb
2015-03-10 12:57 ngarcia Relationship added caused by 0027160
2015-03-10 13:56 eduardo_Argal Status new => scheduled
2015-03-18 08:53 Sandrahuguet Regression level => Pre packaging ( pi )
2015-03-18 08:53 Sandrahuguet Regression introduced in release => pi
2015-03-25 13:17 vmromanos Relationship added related to 0028051
2015-03-25 13:57 umartirena Review Assigned To => vmromanos
2015-03-25 16:20 hgbot Checkin
2015-03-25 16:20 hgbot Note Added: 0075971
2015-03-25 16:20 hgbot Status scheduled => resolved
2015-03-25 16:20 hgbot Resolution open => fixed
2015-03-25 16:20 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/81d75586c6c4ee2d4a50893d41acff985ae7acb6 [^]
2015-03-25 16:20 hgbot Checkin
2015-03-25 16:20 hgbot Note Added: 0075972
2015-03-25 16:22 vmromanos Note Added: 0075973
2015-03-25 16:22 vmromanos Status resolved => closed
2015-03-25 22:20 hudsonbot Checkin
2015-03-25 22:20 hudsonbot Note Added: 0075985
2015-03-25 22:20 hudsonbot Checkin
2015-03-25 22:20 hudsonbot Note Added: 0075986


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker