Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000168Openbravo ERP07. Sales managementpublic2008-04-29 13:152009-09-16 15:29
Reporterplujan 
Assigned Togorkaion 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target Version2.40Fixed in Version2.50MP6 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0000168: Oracle error on trying to delete a created Good Shipment
DescriptionWhen 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'
Steps To Reproduce1. 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)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0004936 closed gorkaion Oracle error on trying to delete a created Good Shipment 
has duplicate defect 0004720 closed rafaroda When deleting a Good receipt document which has got lines you get an extrange error message 
Attached Filesjpg R240_BUG_DeletingSalesInvoice.JPG (111,598) 2008-04-29 13:15
https://issues.openbravo.com/file_download.php?file_id=13&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2008-04-29 13:15plujanNew Issue
2008-04-29 13:15plujanAssigned To => cromero
2008-04-29 13:15plujanFile Added: R240_BUG_DeletingSalesInvoice.JPG
2008-05-05 11:21cromeroAssigned Tocromero => rafaroda
2008-05-05 11:21cromeroStatusnew => @40@
2008-05-05 11:21cromeroStatus@40@ => scheduled
2008-05-23 15:55pheenanAssigned Torafaroda => pheenan
2008-06-13 19:59cromeroTarget Version => 2.40
2008-11-13 22:23rafarodaAssigned Topheenan => Dowid
2008-12-09 14:30PavelPonomarevAssigned ToDowid => pheenan
2009-01-09 15:32rafarodaAssigned Topheenan => gorkaion
2009-01-09 19:46rafarodaRelationship addedhas duplicate 0004720
2009-01-09 19:49rafarodaNote Added: 0012083
2009-01-19 10:10rafarodaversion => 2.40
2009-02-07 12:06pjuvaraPrioritynormal => high
2009-02-07 12:06pjuvaraSeverityminor => major
2009-02-13 17:30svnbotCheckin
2009-02-13 17:30svnbotNote Added: 0013487
2009-02-13 17:30svnbotStatusscheduled => resolved
2009-02-13 17:30svnbotResolutionopen => fixed
2009-02-13 17:30svnbotsvn_revision => 13181
2009-02-18 15:24sureshbabuRegression testing => No
2009-02-18 15:24sureshbabuStatusresolved => closed
2009-02-18 15:24sureshbabuNote Added: 0013669
2009-02-18 15:24sureshbabuFixed in Version => trunk
2009-03-18 11:01anonymoussf_bug_id0 => 2691219
2009-09-10 07:47hudsonbotCheckin
2009-09-10 07:47hudsonbotNote Added: 0019661
2009-09-10 07:47hudsonbotFixed in SCM revision13181 =>
2009-09-10 07:53hudsonbotCheckin
2009-09-10 07:53hudsonbotNote Added: 0019662
2009-09-10 07:54hudsonbotCheckin
2009-09-10 07:54hudsonbotNote Added: 0019667
2009-09-10 08:25hudsonbotCheckin
2009-09-10 08:25hudsonbotNote Added: 0019670
2009-09-10 08:38hudsonbotCheckin
2009-09-10 08:38hudsonbotNote Added: 0019674
2009-09-10 09:04hudsonbotCheckin
2009-09-10 09:04hudsonbotNote Added: 0019683
2009-09-10 10:42hudsonbotCheckin
2009-09-10 10:42hudsonbotNote Added: 0019699
2009-09-10 10:42hudsonbotStatusclosed => resolved
2009-09-10 14:38hudsonbotCheckin
2009-09-10 14:38hudsonbotNote Added: 0019731
2009-09-10 16:04hudsonbotCheckin
2009-09-10 16:04hudsonbotNote Added: 0019743
2009-09-10 17:33hudsonbotCheckin
2009-09-10 17:33hudsonbotNote Added: 0019756
2009-09-10 21:17hudsonbotCheckin
2009-09-10 21:17hudsonbotNote Added: 0019766
2009-09-10 23:15hudsonbotCheckin
2009-09-10 23:15hudsonbotNote Added: 0019780
2009-09-11 07:08hudsonbotCheckin
2009-09-11 07:08hudsonbotNote Added: 0019788
2009-09-11 21:17hudsonbotCheckin
2009-09-11 21:17hudsonbotNote Added: 0019828
2009-09-11 23:15hudsonbotCheckin
2009-09-11 23:15hudsonbotNote Added: 0019847
2009-09-12 21:17hudsonbotCheckin
2009-09-12 21:17hudsonbotNote Added: 0019859
2009-09-13 21:17hudsonbotCheckin
2009-09-13 21:17hudsonbotNote Added: 0019870
2009-09-14 11:51hudsonbotCheckin
2009-09-14 11:51hudsonbotNote Added: 0019896
2009-09-14 18:37hudsonbotCheckin
2009-09-14 18:37hudsonbotNote Added: 0019924
2009-09-14 19:57hudsonbotCheckin
2009-09-14 19:57hudsonbotNote Added: 0019946
2009-09-14 21:17hudsonbotCheckin
2009-09-14 21:17hudsonbotNote Added: 0019987
2009-09-14 23:15hudsonbotCheckin
2009-09-14 23:15hudsonbotNote Added: 0020000
2009-09-15 12:35hudsonbotCheckin
2009-09-15 12:35hudsonbotNote Added: 0020059
2009-09-16 15:29sureshbabuStatusresolved => closed
2009-09-16 15:29sureshbabuNote Added: 0020116
2009-09-16 15:29sureshbabuFixed in Version2.50beta => 2.50MP6

Notes
(0012083)
rafaroda   
2009-01-09 19:49   
Solution proposed by Pablo Sarobe is to remove the "delete on cascade" condition.
(0013487)
svnbot   
2009-02-13 17:30   
Repository: openbravo
Revision: 13181
Author: gorkaion
Date: 2009-02-13 17:29:57 +0100 (Fri, 13 Feb 2009)

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

---
U trunk/src-db/database/model/tables/M_INOUTLINE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=13181&sc=1 [^]
(0013669)
sureshbabu   
2009-02-18 15:24   
Retested in context 79.125.56.185/openbravotrunk
(0019661)
hudsonbot   
2009-09-10 07:47   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/850/ [^]
------
(0019662)
hudsonbot   
2009-09-10 07:53   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-oracle/743/ [^]
------
(0019667)
hudsonbot   
2009-09-10 07:54   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/169/ [^]
------
(0019670)
hudsonbot   
2009-09-10 08:25   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-oracle/339/ [^]
------
(0019674)
hudsonbot   
2009-09-10 08:38   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-pgsql/345/ [^]
------
(0019683)
hudsonbot   
2009-09-10 09:04   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/87/ [^]
------
(0019699)
hudsonbot   
2009-09-10 10:42   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-smoke-test/59/ [^]
------
(0019731)
hudsonbot   
2009-09-10 14:38   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/88/ [^]
------
(0019743)
hudsonbot   
2009-09-10 16:04   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/170/ [^]
------
(0019756)
hudsonbot   
2009-09-10 17:33   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/89/ [^]
------
(0019766)
hudsonbot   
2009-09-10 21:17   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/171/ [^]
------
(0019780)
hudsonbot   
2009-09-10 23:15   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/136/ [^]
------
(0019788)
hudsonbot   
2009-09-11 07:08   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/172/ [^]
------
(0019828)
hudsonbot   
2009-09-11 21:17   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/173/ [^]
------
(0019847)
hudsonbot   
2009-09-11 23:15   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/137/ [^]
------
(0019859)
hudsonbot   
2009-09-12 21:17   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/174/ [^]
------
(0019870)
hudsonbot   
2009-09-13 21:17   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/175/ [^]
------
(0019896)
hudsonbot   
2009-09-14 11:51   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/138/ [^]
------
(0019924)
hudsonbot   
2009-09-14 18:37   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/176/ [^]
------
(0019946)
hudsonbot   
2009-09-14 19:57   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/177/ [^]
------
(0019987)
hudsonbot   
2009-09-14 21:17   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/178/ [^]
------
(0020000)
hudsonbot   
2009-09-14 23:15   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/139/ [^]
------
(0020059)
hudsonbot   
2009-09-15 12:35   
Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/179/ [^]
------
(0020116)
sureshbabu   
2009-09-16 15:29   
Now the system throwing a different error since it has child line items. But the error reported by the user not appear.