Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023754Openbravo ERP03. Procurement managementpublic2013-05-07 10:272013-05-23 01:32
Reporterjonalegriaesarte 
Assigned Tojecharri 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP21 
Target VersionFixed in Version3.0MP24 
Merge Request Status
Review Assigned Tojonalegriaesarte
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - QA Approved
Regression date2013-03-01
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/387d054faef6 [^]
Triggers an Emergency PackYes
Summary0023754: Goods receipt lines can not be deleted in Oracle
DescriptionGoods 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-05-07 10:27jonalegriaesarteNew Issue
2013-05-07 10:27jonalegriaesarteAssigned To => jecharri
2013-05-07 10:27jonalegriaesarteModules => Core
2013-05-07 10:27jonalegriaesarteTriggers an Emergency Pack => No
2013-05-07 10:29jonalegriaesarteRegression level => Production - QA Approved
2013-05-07 10:29jonalegriaesarteRegression date => 2013-03-01
2013-05-07 10:29jonalegriaesarteRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/387d054faef6 [^]
2013-05-07 10:29jonalegriaesarteTriggers an Emergency PackNo => Yes
2013-05-09 12:11hgbotCheckin
2013-05-09 12:11hgbotNote Added: 0058515
2013-05-09 12:11hgbotStatusnew => resolved
2013-05-09 12:11hgbotResolutionopen => fixed
2013-05-09 12:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0f26e49c3593d35844b56093e25d15ccb9f02a79 [^]
2013-05-09 12:13hgbotCheckin
2013-05-09 12:13hgbotNote Added: 0058516
2013-05-15 09:54jonalegriaesarteReview Assigned To => jonalegriaesarte
2013-05-15 09:54jonalegriaesarteNote Added: 0058655
2013-05-15 09:54jonalegriaesarteStatusresolved => closed
2013-05-15 09:54jonalegriaesarteFixed in Version => 3.0MP24
2013-05-23 01:32hudsonbotCheckin
2013-05-23 01:32hudsonbotNote Added: 0058783
2013-05-23 01:32hudsonbotCheckin
2013-05-23 01:32hudsonbotNote Added: 0058784

Notes
(0058515)
hgbot   
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   
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   
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   
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   
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