Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008588Openbravo ERP07. Sales managementpublic2009-04-15 19:092009-05-14 16:42
Reportercheli 
Assigned Togmauleon 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionopen 
PlatformOS20OS VersionDebian Gnu Linux
Product Version2.40MP3 
Target VersionFixed in Version 
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
Summary0008588: 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
TagsNo tags attached.
Relationships
blocks defect 0008581 closed gmauleon can not delete a sales invoice line 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-04-16 11:26psarobeTypedefect => backport
2009-04-16 11:26psarobefix_in_branch => 2.40
2009-04-23 09:41rafarodaAssigned Torafaroda => gmauleon
2009-04-23 11:03gmauleonNote Added: 0015603
2009-04-23 11:03gmauleonStatusscheduled => resolved
2009-04-23 11:03gmauleonFixed in Version => 2.40
2009-04-23 11:03gmauleonFixed in SCM revision => 621
2009-04-23 11:03gmauleonResolutionopen => fixed
2009-04-23 11:03gmauleonNote Added: 0015604
2009-04-23 11:14jpabloaeFixed in SCM revision621 => https://code.openbravo.com/erp/stable/2.40/rev/7e1fc3ab7f48 [^]
2009-04-24 12:19psarobeStatusresolved => new
2009-04-24 12:19psarobeResolutionfixed => open
2009-04-24 12:19psarobeFixed in Version2.40 =>
2009-04-24 12:19psarobeStatusnew => scheduled
2009-04-24 12:21psarobeStatusscheduled => resolved
2009-05-10 19:37psarobeFixed in Version => 2.40MP4
2009-05-14 16:42psarobeRegression testing => No
2009-05-14 16:42psarobeStatusresolved => closed

Notes
(0015603)
gmauleon   
2009-04-23 11:03   
Bug Fixed in this revision
author Gorka Mauleon <gorka.mauleon@openbravo.com>
    Thu Apr 16 13:34:33 2009 +0200 (6 days ago)
changeset 621 7e1fc3ab7f48
https://code.openbravo.com/erp/stable/2.40/rev/7e1fc3ab7f48 [^]
(0015604)
gmauleon   
2009-04-23 11:03   
Bug Fixed in this revision
author Gorka Mauleon <gorka.mauleon@openbravo.com>
    Thu Apr 16 13:34:33 2009 +0200 (6 days ago)
changeset 621 7e1fc3ab7f48
https://code.openbravo.com/erp/stable/2.40/rev/7e1fc3ab7f48 [^]