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

View Issue Details[ Jump 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 
Review Assigned Tovmromanos
Web browser
ModulesCore
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 (manager)
2015-03-25 16:22

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