Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008581 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | major | always | 2009-04-15 19:09 | 2009-04-25 00:00 | |||
| Reporter | cheli | View Status | public | |||||
| Assigned To | gmauleon | |||||||
| Priority | immediate | Resolution | open | Fixed in Version | 2.40MP4 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 7e1fc3ab7f48 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.6 | |||
| OS Version | Debian Gnu Linux | Database version | 11g | Ant version | 1.7 | |||
| Product Version | 2.40MP3 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0008581: can not delete a sales invoice line | |||||||
| Description | In 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 Reproduce | 1:- Create a new sales invoice 2:- Create a Sales invoice line 3:- Try to delete that sales invoice line | |||||||
| Proposed Solution | Delete one of the two restriction that make the same thing. | |||||||
| Tags | main, tictech | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0015380) psarobe (manager) 2009-04-16 11:26 |
Thanks for your feedback |
|
(0015386) hgbot (developer) 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 --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-04-15 19:09 | cheli | New Issue | |
| 2009-04-15 19:09 | cheli | Assigned To | => rafaroda |
| 2009-04-15 19:09 | cheli | Tag Attached: tictech | |
| 2009-04-15 22:06 | psarobe | Severity | critical => major |
| 2009-04-16 08:48 | networkb | Priority | normal => immediate |
| 2009-04-16 11:26 | psarobe | Status | new => scheduled |
| 2009-04-16 11:26 | psarobe | Note Added: 0015380 | |
| 2009-04-16 11:26 | psarobe | Assigned To | rafaroda => gmauleon |
| 2009-04-16 11:26 | psarobe | fix_in_branch | => pi |
| 2009-04-16 13:36 | hgbot | Checkin | |
| 2009-04-16 13:36 | hgbot | Note Added: 0015386 | |
| 2009-04-16 13:36 | hgbot | Status | scheduled => resolved |
| 2009-04-16 13:36 | hgbot | Resolution | open => fixed |
| 2009-04-16 13:36 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/7e1fc3ab7f48ffb212dfcdc08430100b4b33bf4c [^] |
| 2009-04-22 11:23 | psarobe | Tag Attached: main | |
| 2009-04-24 12:18 | psarobe | Status | resolved => new |
| 2009-04-24 12:18 | psarobe | Resolution | fixed => open |
| 2009-04-24 12:20 | psarobe | Status | new => scheduled |
| 2009-04-24 12:20 | psarobe | fix_in_branch | pi => |
| 2009-04-24 12:21 | psarobe | Status | scheduled => resolved |
| 2009-04-24 12:23 | psarobe | Regression testing | => No |
| 2009-04-24 12:23 | psarobe | Status | resolved => closed |
| 2009-04-25 00:00 | anonymous | sf_bug_id | 0 => 2780827 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |