Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0023754 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 03. Procurement management | major | have not tried | 2013-05-07 10:27 | 2013-05-23 01:32 | |||
| Reporter | jonalegriaesarte | View Status | public | |||||
| Assigned To | jecharri | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 3.0MP24 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 0f26e49c3593 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 3.0MP21 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | jonalegriaesarte | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | Production - QA Approved | |||||||
| Regression date | 2013-03-01 | |||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | https://code.openbravo.com/erp/devel/pi/rev/387d054faef6 [^] | |||||||
| Triggers an Emergency Pack | Yes | |||||||
| Summary | 0023754: Goods receipt lines can not be deleted in Oracle | |||||||
| Description | Goods receipt lines can not be deleted in Oracle. Error: Error ORA-04091: table INT_FULL_ORACLE.M_INOUTLINE is mutating, trigger/function may not see it ORA-06512: at "INT_FULL_ORACLE.M_INOUT_TRG_PROV", line 63 ORA-04088: error during execution of trigger 'INT_FULL_ORACLE.M_INOUT_TRG_PROV' ORA-06512: at "INT_FULL_ORACLE.M_INOUTLINE_TRG", line 46 ORA-04088: error during execution of trigger 'INT_FULL_ORACLE.M_INOUTLINE_TRG' | |||||||
| Steps To Reproduce | - Create a purchase order with one line. Book it - Create the goods receipt header - Create lines from and select the purchase order line - Try to delete the line | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0058515) hgbot (developer) 2013-05-09 12:11 |
Repository: erp/devel/pi Changeset: 0f26e49c3593d35844b56093e25d15ccb9f02a79 Author: Javier Etxarri <javier.echarri <at> openbravo.com> Date: Thu May 09 12:11:33 2013 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/0f26e49c3593d35844b56093e25d15ccb9f02a79 [^] Fixes issue 23754: Goods receipt lines can not be deleted in Oracle --- M src-db/database/model/triggers/M_INOUTLINE_TRG.xml M src-db/database/model/triggers/M_INOUT_TRG_PROV.xml --- |
|
(0058516) hgbot (developer) 2013-05-09 12:13 |
Repository: erp/devel/pi Changeset: d685ef0795fa9d0a6efe9c8862c580af9ce59b9c Author: Javier Etxarri <javier.echarri <at> openbravo.com> Date: Thu May 09 12:13:33 2013 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/d685ef0795fa9d0a6efe9c8862c580af9ce59b9c [^] issue 23754: Goods receipt lines can not be deleted in Oracle --- A src/org/openbravo/event/MInOutLineEventHandler.java --- |
|
(0058655) jonalegriaesarte (viewer) 2013-05-15 09:54 |
Tested: - Create goods shipment and goods receipt with lines and deleting them - Create goods shipment and goods receipt using create lines from and deleting them Both in Oracle and Postgre |
|
(0058783) hudsonbot (viewer) 2013-05-23 01:32 |
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/97c7f6256af7 [^] Maturity status: Test |
|
(0058784) hudsonbot (viewer) 2013-05-23 01:32 |
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/97c7f6256af7 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2013-05-07 10:27 | jonalegriaesarte | New Issue | |
| 2013-05-07 10:27 | jonalegriaesarte | Assigned To | => jecharri |
| 2013-05-07 10:27 | jonalegriaesarte | Modules | => Core |
| 2013-05-07 10:27 | jonalegriaesarte | OBNetwork customer | => Yes |
| 2013-05-07 10:27 | jonalegriaesarte | Triggers an Emergency Pack | => No |
| 2013-05-07 10:29 | jonalegriaesarte | Regression level | => Production - QA Approved |
| 2013-05-07 10:29 | jonalegriaesarte | Regression date | => 2013-03-01 |
| 2013-05-07 10:29 | jonalegriaesarte | Regression introduced by commit | => https://code.openbravo.com/erp/devel/pi/rev/387d054faef6 [^] |
| 2013-05-07 10:29 | jonalegriaesarte | Triggers an Emergency Pack | No => Yes |
| 2013-05-09 12:11 | hgbot | Checkin | |
| 2013-05-09 12:11 | hgbot | Note Added: 0058515 | |
| 2013-05-09 12:11 | hgbot | Status | new => resolved |
| 2013-05-09 12:11 | hgbot | Resolution | open => fixed |
| 2013-05-09 12:11 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/0f26e49c3593d35844b56093e25d15ccb9f02a79 [^] |
| 2013-05-09 12:13 | hgbot | Checkin | |
| 2013-05-09 12:13 | hgbot | Note Added: 0058516 | |
| 2013-05-15 09:54 | jonalegriaesarte | Review Assigned To | => jonalegriaesarte |
| 2013-05-15 09:54 | jonalegriaesarte | Note Added: 0058655 | |
| 2013-05-15 09:54 | jonalegriaesarte | Status | resolved => closed |
| 2013-05-15 09:54 | jonalegriaesarte | Fixed in Version | => 3.0MP24 |
| 2013-05-23 01:32 | hudsonbot | Checkin | |
| 2013-05-23 01:32 | hudsonbot | Note Added: 0058783 | |
| 2013-05-23 01:32 | hudsonbot | Checkin | |
| 2013-05-23 01:32 | hudsonbot | Note Added: 0058784 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |