Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002738Openbravo ERP04. Warehouse managementpublic2008-03-25 11:492008-06-18 19:46
Reporterplujan 
Assigned Togorkaion 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40alpha-r3 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002738: Message when deleting an Inventory is not correct
DescriptionDescription:
When I delete an Inventory with lines, I have the following message:
ORA-04091: la tabla TAD_SVN.M_INVENTORY está mutando, puede que el disparador/la función no puedan verla ORA-06512: en "TAD_SVN.M_INVENTORYLINE_TRG", línea 31 ORA-04088: error durante la ejecución del disparador 'TAD_SVN.M_INVENTORYLINE_TRG'

Steps:
1. As a Client Admin, go to Warehouse management > Transactions > Physical Inventory
2. Create a new Header
3. Click on "Create Inventory Count" button. The process creates at least one line.
4. Delete the inventory and the message about the trigger appears.

Proposed solution:
The inventory deletion should cascade delete all the lines as well, so no error message should be shown.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003745 closed gorkaion Message when deleting an Inventory is not correct 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-18 19:46plujanStatusresolved => closed

Notes
(0006327)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1925038 [^]
(0003353)
gorkaion   
2008-06-04 12:35   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1500690
Originator: NO

Fixed on trunk revision 4791

Removed the delete on cascade from the foreign key. That window shouldn't delete the lines automatically when the header is deleted.