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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0008588
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 07. Sales managementmajoralways2009-04-15 19:092009-05-14 16:42
ReportercheliView Statuspublic 
Assigned Togmauleon 
PriorityimmediateResolutionopenFixed in Version
StatusclosedFix in branch2.40Fixed in SCM revision7e1fc3ab7f48
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionDebian Gnu LinuxDatabase version11gAnt version1.7
Product Version2.40MP3SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008588: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0008581 closedgmauleon can not delete a sales invoice line 

-  Notes
(0015603)
gmauleon (reporter)
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 (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2009-04-16 11:26 psarobe Type defect => backport
2009-04-16 11:26 psarobe fix_in_branch => 2.40
2009-04-23 09:41 rafaroda Assigned To rafaroda => gmauleon
2009-04-23 11:03 gmauleon Note Added: 0015603
2009-04-23 11:03 gmauleon Status scheduled => resolved
2009-04-23 11:03 gmauleon Fixed in Version => 2.40
2009-04-23 11:03 gmauleon Fixed in SCM revision => 621
2009-04-23 11:03 gmauleon Resolution open => fixed
2009-04-23 11:03 gmauleon Note Added: 0015604
2009-04-23 11:14 jpabloae Fixed in SCM revision 621 => https://code.openbravo.com/erp/stable/2.40/rev/7e1fc3ab7f48 [^]
2009-04-24 12:19 psarobe Status resolved => new
2009-04-24 12:19 psarobe Resolution fixed => open
2009-04-24 12:19 psarobe Fixed in Version 2.40 =>
2009-04-24 12:19 psarobe Status new => scheduled
2009-04-24 12:21 psarobe Status scheduled => resolved
2009-05-10 19:37 psarobe Fixed in Version => 2.40MP4
2009-05-14 16:42 psarobe Regression testing => No
2009-05-14 16:42 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker