Project: 	
  | View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0029218 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 04. Warehouse management | major | always | 2015-03-10 12:54 | 2015-03-25 22:20 | |||
| Reporter | ngarcia | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 81d75586c6c4 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | 8.4.22 | Ant version | |||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | vmromanos | |||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | Pre packaging ( pi ) | |||||||
| Regression date | 2014-01-21 | |||||||
| Regression introduced in release | pi | |||||||
| Regression introduced by commit | https://code.openbravo.com/erp/devel/pi/rev/7091c40b9be09114b26b6cefeb45bc30c2650bf3 [^] | |||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0029218: Cannot save a Stock Reservation in PostgreSQL 8.4 | |||||||
| Description | Cannot save a Stock Reservation in PostgreSQL 8.4 | |||||||
| Steps To Reproduce | As 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"  | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
		  Relationships		[ Relation Graph ] 
		[ Dependency Graph ] 
			 | 
|||||||||||||||
  | 
|||||||||||||||
  		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 |