Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008581Openbravo ERP07. Sales managementpublic2009-04-15 19:092009-04-25 00:00
Reportercheli 
Assigned Togmauleon 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionopen 
PlatformOS20OS VersionDebian Gnu Linux
Product Version2.40MP3 
Target VersionFixed in Version2.40MP4 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0008581: can not delete a sales invoice line
DescriptionIn MP3 patch there is a change in c_invoiceline_offer that forces deleting offers when you delete a invoice line. Alse there was a trigger c_invoiceline_trg2 that tries to delete offers too when you delete a invoice line.

Oracle gets this error:

ORA-04091: la tabla TAD.C_INVOICELINE_OFFER está mutando, puede que el disparador/la función no puedan verla ORA-06512: en "TAD.C_INVOICELINE_TRG2", línea 43 ORA-04088: error durante la ejecución del disparador 'TAD.C_INVOICELINE_TRG2'


MP3:

Index: C_INVOICELINE_OFFER.xml
===================================================================
--- C_INVOICELINE_OFFER.xml (revisión: 152)
+++ C_INVOICELINE_OFFER.xml (revisión: 153)
@@ -59,7 +59,7 @@
       <foreign-key foreignTable="AD_ORG" name="ADORG_CINVOICELINEOFFER">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
- <foreign-key foreignTable="C_INVOICELINE" name="CINVOICELINE_CINVOICELINEOFFER">
+ <foreign-key foreignTable="C_INVOICELINE" name="CINVOICELINE_CINVOICELINEOFFER" onDelete="cascade">
         <reference local="C_INVOICELINE_ID" foreign="C_INVOICELINE_ID"/>
       </foreign-key>
       <foreign-key foreignTable="M_OFFER" name="MOFFER_CINVOICELINEOFFER">


c_invoiceline_trg2:

 IF DELETING THEN
   DELETE FROM C_INVOICELINE_OFFER
   WHERE C_InvoiceLine_ID = :OLD.C_InvoiceLine_ID;
 END IF;
Steps To Reproduce1:- Create a new sales invoice
2:- Create a Sales invoice line
3:- Try to delete that sales invoice line
Proposed SolutionDelete one of the two restriction that make the same thing.
Additional Information
Tagsmain, tictech
Relationships
depends on backport 0008588 closed gmauleon can not delete a sales invoice line 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-04-15 19:09cheliNew Issue
2009-04-15 19:09cheliAssigned To => rafaroda
2009-04-15 19:09cheliTag Attached: tictech
2009-04-15 22:06psarobeOBNetwork customer => No
2009-04-15 22:06psarobeSeveritycritical => major
2009-04-16 08:48networkbOBNetwork customerNo => Yes
2009-04-16 08:48networkbPrioritynormal => immediate
2009-04-16 11:26psarobeStatusnew => scheduled
2009-04-16 11:26psarobeNote Added: 0015380
2009-04-16 11:26psarobeAssigned Torafaroda => gmauleon
2009-04-16 11:26psarobefix_in_branch => pi
2009-04-16 13:36hgbotCheckin
2009-04-16 13:36hgbotNote Added: 0015386
2009-04-16 13:36hgbotStatusscheduled => resolved
2009-04-16 13:36hgbotResolutionopen => fixed
2009-04-16 13:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/7e1fc3ab7f48ffb212dfcdc08430100b4b33bf4c [^]
2009-04-22 11:23psarobeTag Attached: main
2009-04-24 12:18psarobeStatusresolved => new
2009-04-24 12:18psarobeResolutionfixed => open
2009-04-24 12:20psarobeStatusnew => scheduled
2009-04-24 12:20psarobefix_in_branchpi =>
2009-04-24 12:21psarobeStatusscheduled => resolved
2009-04-24 12:23psarobeRegression testing => No
2009-04-24 12:23psarobeStatusresolved => closed
2009-04-25 00:00anonymoussf_bug_id0 => 2780827

Notes
(0015380)
psarobe   
2009-04-16 11:26   
Thanks for your feedback
(0015386)
hgbot   
2009-04-16 13:36   
Repository: erp/stable/2.40
Changeset: 7e1fc3ab7f48ffb212dfcdc08430100b4b33bf4c
Author: Gorka Mauleon <gorka.mauleon <at> openbravo.com>
Date: Thu Apr 16 13:34:33 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/7e1fc3ab7f48ffb212dfcdc08430100b4b33bf4c [^]

fixes 0008581: can not delete a sales invoice line

---
M src-db/database/model/tables/C_INVOICELINE_OFFER.xml
---