Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0000168
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajorhave not tried2008-04-29 13:152009-09-16 15:29
ReporterplujanView Statuspublic 
Assigned Togorkaion 
PriorityhighResolutionfixedFixed in Version2.50MP6
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version2.40
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0000168: 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)
TagsNo tags attached.
Attached Filesjpg file icon R240_BUG_DeletingSalesInvoice.JPG [^] (111,598 bytes) 2008-04-29 13:15

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0004936 closedgorkaion Oracle error on trying to delete a created Good Shipment 
has duplicate defect 0004720 closedrafaroda When deleting a Good receipt document which has got lines you get an extrange error message 

-  Notes
(0012083)
rafaroda (developer)
2009-01-09 19:49

Solution proposed by Pablo Sarobe is to remove the "delete on cascade" condition.
(0013487)
svnbot (reporter)
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 (reporter)
2009-02-18 15:24

Retested in context 79.125.56.185/openbravotrunk
(0019661)
hudsonbot (developer)
2009-09-10 07:47

Fixed Issue 168

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

Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-oracle/743/ [^]
------
(0019667)
hudsonbot (developer)
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 (developer)
2009-09-10 08:25

Fixed Issue 168

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

Fixed Issue 168

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

Fixed Issue 168

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

Fixed Issue 168

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

Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/88/ [^]
------
(0019743)
hudsonbot (developer)
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 (developer)
2009-09-10 17:33

Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/89/ [^]
------
(0019766)
hudsonbot (developer)
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 (developer)
2009-09-10 23:15

Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/136/ [^]
------
(0019788)
hudsonbot (developer)
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 (developer)
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 (developer)
2009-09-11 23:15

Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/137/ [^]
------
(0019859)
hudsonbot (developer)
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 (developer)
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 (developer)
2009-09-14 11:51

Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/138/ [^]
------
(0019924)
hudsonbot (developer)
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 (developer)
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 (developer)
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 (developer)
2009-09-14 23:15

Fixed Issue 168

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/139/ [^]
------
(0020059)
hudsonbot (developer)
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 (reporter)
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.

- Issue History
Date Modified Username Field Change
2008-04-29 13:15 plujan New Issue
2008-04-29 13:15 plujan Assigned To => cromero
2008-04-29 13:15 plujan File Added: R240_BUG_DeletingSalesInvoice.JPG
2008-05-05 11:21 cromero Assigned To cromero => rafaroda
2008-05-05 11:21 cromero Status new => @40@
2008-05-05 11:21 cromero Status @40@ => scheduled
2008-05-23 15:55 pheenan Assigned To rafaroda => pheenan
2008-06-13 19:59 cromero Target Version => 2.40
2008-11-13 22:23 rafaroda Assigned To pheenan => Dowid
2008-12-09 14:30 PavelPonomarev Assigned To Dowid => pheenan
2009-01-09 15:32 rafaroda Assigned To pheenan => gorkaion
2009-01-09 19:46 rafaroda Relationship added has duplicate 0004720
2009-01-09 19:49 rafaroda Note Added: 0012083
2009-01-19 10:10 rafaroda version => 2.40
2009-02-07 12:06 pjuvara Priority normal => high
2009-02-07 12:06 pjuvara Severity minor => major
2009-02-13 17:30 svnbot Checkin
2009-02-13 17:30 svnbot Note Added: 0013487
2009-02-13 17:30 svnbot Status scheduled => resolved
2009-02-13 17:30 svnbot Resolution open => fixed
2009-02-13 17:30 svnbot svn_revision => 13181
2009-02-18 15:24 sureshbabu Regression testing => No
2009-02-18 15:24 sureshbabu Status resolved => closed
2009-02-18 15:24 sureshbabu Note Added: 0013669
2009-02-18 15:24 sureshbabu Fixed in Version => trunk
2009-03-18 11:01 anonymous sf_bug_id 0 => 2691219
2009-09-10 07:47 hudsonbot Checkin
2009-09-10 07:47 hudsonbot Note Added: 0019661
2009-09-10 07:47 hudsonbot Fixed in SCM revision 13181 =>
2009-09-10 07:53 hudsonbot Checkin
2009-09-10 07:53 hudsonbot Note Added: 0019662
2009-09-10 07:54 hudsonbot Checkin
2009-09-10 07:54 hudsonbot Note Added: 0019667
2009-09-10 08:25 hudsonbot Checkin
2009-09-10 08:25 hudsonbot Note Added: 0019670
2009-09-10 08:38 hudsonbot Checkin
2009-09-10 08:38 hudsonbot Note Added: 0019674
2009-09-10 09:04 hudsonbot Checkin
2009-09-10 09:04 hudsonbot Note Added: 0019683
2009-09-10 10:42 hudsonbot Checkin
2009-09-10 10:42 hudsonbot Note Added: 0019699
2009-09-10 10:42 hudsonbot Status closed => resolved
2009-09-10 14:38 hudsonbot Checkin
2009-09-10 14:38 hudsonbot Note Added: 0019731
2009-09-10 16:04 hudsonbot Checkin
2009-09-10 16:04 hudsonbot Note Added: 0019743
2009-09-10 17:33 hudsonbot Checkin
2009-09-10 17:33 hudsonbot Note Added: 0019756
2009-09-10 21:17 hudsonbot Checkin
2009-09-10 21:17 hudsonbot Note Added: 0019766
2009-09-10 23:15 hudsonbot Checkin
2009-09-10 23:15 hudsonbot Note Added: 0019780
2009-09-11 07:08 hudsonbot Checkin
2009-09-11 07:08 hudsonbot Note Added: 0019788
2009-09-11 21:17 hudsonbot Checkin
2009-09-11 21:17 hudsonbot Note Added: 0019828
2009-09-11 23:15 hudsonbot Checkin
2009-09-11 23:15 hudsonbot Note Added: 0019847
2009-09-12 21:17 hudsonbot Checkin
2009-09-12 21:17 hudsonbot Note Added: 0019859
2009-09-13 21:17 hudsonbot Checkin
2009-09-13 21:17 hudsonbot Note Added: 0019870
2009-09-14 11:51 hudsonbot Checkin
2009-09-14 11:51 hudsonbot Note Added: 0019896
2009-09-14 18:37 hudsonbot Checkin
2009-09-14 18:37 hudsonbot Note Added: 0019924
2009-09-14 19:57 hudsonbot Checkin
2009-09-14 19:57 hudsonbot Note Added: 0019946
2009-09-14 21:17 hudsonbot Checkin
2009-09-14 21:17 hudsonbot Note Added: 0019987
2009-09-14 23:15 hudsonbot Checkin
2009-09-14 23:15 hudsonbot Note Added: 0020000
2009-09-15 12:35 hudsonbot Checkin
2009-09-15 12:35 hudsonbot Note Added: 0020059
2009-09-16 15:29 sureshbabu Status resolved => closed
2009-09-16 15:29 sureshbabu Note Added: 0020116
2009-09-16 15:29 sureshbabu Fixed in Version 2.50beta => 2.50MP6


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker