Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029063Openbravo ERP04. Warehouse managementpublic2015-02-25 12:592015-02-26 22:39
Reporterumartirena 
Assigned Toumartirena 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR15Q2 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029063: M_Reservation_Post fails in Oracle
DescriptionM_Reservation_Post fails in Oracle after the refactor of M_GET_STOCK_PARAM.

The following error is obtained:
Error:
ORA-04091: table ERP_PI_ORACLE.M_RESERVATION is mutating, trigger/function may not see it\\nORA-06512: at "ERP_PI_ORACLE.M_RESERVATION_TRG", line 80\\nORA-04088: error during execution of trigger 'ERP_PI_ORACLE.M_RESERVATION_TRG'
Steps To ReproduceIn live.builds in oracle:
 * Enable Reservations preference.
 * Logout and Login.
 * Create a Sales Order with a line. Click on that line and press Manage Reservations.
 * Click on Cancel.
 * Go to Linked Items of that line and realize that a reservation has been created, navigate to it.
 * See that the reservation is on draft. Try to process the reservation.
 * The below error is obtained.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00288343.0PR15Q2 closed umartirena M_Reservation_Post errors in oracle 
causes defect 0030516 closed AtulOpenbravo Potential full c_orderline scan in M_Reservation_trg 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-02-25 12:59umartirenaNew Issue
2015-02-25 12:59umartirenaAssigned To => Sandrahuguet
2015-02-25 12:59umartirenaModules => Core
2015-02-25 12:59umartirenaTriggers an Emergency Pack => No
2015-02-25 13:01umartirenaAssigned ToSandrahuguet => umartirena
2015-02-26 08:35hgbotCheckin
2015-02-26 08:35hgbotNote Added: 0074949
2015-02-26 08:35hgbotStatusnew => resolved
2015-02-26 08:35hgbotResolutionopen => fixed
2015-02-26 08:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b4be2e4511445d578fc7f8a2175c3a6114e52583 [^]
2015-02-26 15:57hgbotCheckin
2015-02-26 15:57hgbotNote Added: 0074973
2015-02-26 15:57SandrahuguetReview Assigned To => Sandrahuguet
2015-02-26 15:57SandrahuguetNote Added: 0074974
2015-02-26 15:57SandrahuguetStatusresolved => closed
2015-02-26 15:57SandrahuguetFixed in Version => 3.0PR15Q2
2015-02-26 18:56umartirenaRelationship addedrelated to 0028834
2015-02-26 22:39hudsonbotCheckin
2015-02-26 22:39hudsonbotNote Added: 0075005
2015-02-26 22:39hudsonbotCheckin
2015-02-26 22:39hudsonbotNote Added: 0075006
2015-08-07 12:10alostaleRelationship addedcauses 0030516

Notes
(0074949)
hgbot   
2015-02-26 08:35   
Repository: erp/devel/pi
Changeset: b4be2e4511445d578fc7f8a2175c3a6114e52583
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Wed Feb 25 13:16:20 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b4be2e4511445d578fc7f8a2175c3a6114e52583 [^]

Fixes bug 29063: Fixed mutating trigger in Oracle.

M_RESERVATION_TRG was triggering a mutating trigger error because a select to the m_reservation table was being done on that trigger, that belongs to m_reservation table. That select has been modified to now to join m_reservation table, because it is not necessary.

---
M src-db/database/model/triggers/M_RESERVATION_TRG.xml
---
(0074973)
hgbot   
2015-02-26 15:57   
Repository: erp/devel/pi
Changeset: ca0b1242f774f37ed3b9132bdf2b011a9e656ec0
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Feb 26 15:56:04 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/ca0b1242f774f37ed3b9132bdf2b011a9e656ec0 [^]

related to issue 29063 update Copyright

---
M src-db/database/model/triggers/M_RESERVATION_TRG.xml
---
(0074974)
Sandrahuguet   
2015-02-26 15:57   
Code review + testing OK
(0075005)
hudsonbot   
2015-02-26 22:39   
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/bcc51efc87d5 [^]
Maturity status: Test
(0075006)
hudsonbot   
2015-02-26 22:39   
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/bcc51efc87d5 [^]
Maturity status: Test