Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0004936Openbravo ERP07. Sales managementpublic2008-09-09 17:262009-03-04 13:24
plujan 
gorkaion 
normalminorhave not tried
closedfixed 
5
2.40 
2.40MP3 
Core
No
0004936: Oracle error on trying to delete a created Good Shipment
When I try to delete a Good Shipment with lines, I get an Oracle Error ORA-04091: la tabla TAD_TRUNK.M_INOUT está mutando, puede que el disparador/la función no puedan verla ORA-06512: en "TAD_TRUNK.M_IOLINE_CHK_RESTRICTIONS_TRG", línea 31 ORA-04088: error durante la ejecución del disparador 'TAD_TRUNK.M_IOLINE_CHK_RESTRICTIONS_TRG'
1. Create an Order with lines
2. Process the order
3. Create a Good shipment
4. Import lines from the order
5. Delete the Shipment. An error appears (see attach)
commsup_sprint6
has duplicate backport 0004781 closed rafaroda When deleting a Good receipt document which has got lines you get an extrange error message 
blocks defect 00001682.40 closed gorkaion Oracle error on trying to delete a created Good Shipment 
Issue History
2008-09-09 17:26anonymousNew Issue
2008-09-09 17:26anonymousAssigned To => pheenan
2008-09-09 17:26anonymousStatusnew => scheduled
2008-09-09 17:26anonymousfix_in_branch => 2.40
2008-11-13 22:23rafarodaAssigned Topheenan => Dowid
2008-12-10 11:17rafarodaAssigned ToDowid => pheenan
2009-01-09 15:32rafarodaAssigned Topheenan => gorkaion
2009-01-09 19:47rafarodaRelationship addedhas duplicate 0004781
2009-01-19 10:10rafarodaversion => 2.40
2009-01-19 10:10rafarodaDescription Updated
2009-02-13 17:33svnbotCheckin
2009-02-13 17:33svnbotNote Added: 0013489
2009-02-13 17:33svnbotStatusscheduled => resolved
2009-02-13 17:33svnbotResolutionopen => fixed
2009-02-13 17:33svnbotsvn_revision => 13182
2009-02-19 12:52gorkaionTag Attached: commsup_sprint6
2009-03-03 17:31psarobeFixed in Version => 2.40MP3
2009-03-04 13:24sureshbabuRegression testing => No
2009-03-04 13:24sureshbabuStatusresolved => closed
2009-03-04 13:24sureshbabuNote Added: 0014383

Notes
(0013489)
svnbot   
2009-02-13 17:33   
Repository: openbravo
Revision: 13182
Author: gorkaion
Date: 2009-02-13 17:33:38 +0100 (Fri, 13 Feb 2009)

Fixed bug 4936. Removed delete on cascade constraint for M_InOut_ID foreign key in M_InOutLine table as proposed.

---
U branches/r2.40/src-db/database/model/tables/M_INOUTLINE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=13182&sc=1 [^]
(0014383)
sureshbabu   
2009-03-04 13:24   
Retested in context http://79.125.57.19/openbravo240mp3oracle [^]