Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0029063 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 04. Warehouse management | major | always | 2015-02-25 12:59 | 2015-02-26 22:39 | |||
| Reporter | umartirena | View Status | public | |||||
| Assigned To | umartirena | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 3.0PR15Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | b4be2e451144 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | Sandrahuguet | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0029063: M_Reservation_Post fails in Oracle | |||||||
| Description | M_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 Reproduce | In 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0074949) hgbot (developer) 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 (developer) 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 (developer) 2015-02-26 15:57 |
Code review + testing OK |
|
(0075005) hudsonbot (developer) 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 (developer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-02-25 12:59 | umartirena | New Issue | |
| 2015-02-25 12:59 | umartirena | Assigned To | => Sandrahuguet |
| 2015-02-25 12:59 | umartirena | Modules | => Core |
| 2015-02-25 12:59 | umartirena | Triggers an Emergency Pack | => No |
| 2015-02-25 13:01 | umartirena | Assigned To | Sandrahuguet => umartirena |
| 2015-02-26 08:35 | hgbot | Checkin | |
| 2015-02-26 08:35 | hgbot | Note Added: 0074949 | |
| 2015-02-26 08:35 | hgbot | Status | new => resolved |
| 2015-02-26 08:35 | hgbot | Resolution | open => fixed |
| 2015-02-26 08:35 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/b4be2e4511445d578fc7f8a2175c3a6114e52583 [^] |
| 2015-02-26 15:57 | hgbot | Checkin | |
| 2015-02-26 15:57 | hgbot | Note Added: 0074973 | |
| 2015-02-26 15:57 | Sandrahuguet | Review Assigned To | => Sandrahuguet |
| 2015-02-26 15:57 | Sandrahuguet | Note Added: 0074974 | |
| 2015-02-26 15:57 | Sandrahuguet | Status | resolved => closed |
| 2015-02-26 15:57 | Sandrahuguet | Fixed in Version | => 3.0PR15Q2 |
| 2015-02-26 18:56 | umartirena | Relationship added | related to 0028834 |
| 2015-02-26 22:39 | hudsonbot | Checkin | |
| 2015-02-26 22:39 | hudsonbot | Note Added: 0075005 | |
| 2015-02-26 22:39 | hudsonbot | Checkin | |
| 2015-02-26 22:39 | hudsonbot | Note Added: 0075006 | |
| 2015-08-07 12:10 | alostale | Relationship added | causes 0030516 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |