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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0002738
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminoralways2008-03-25 11:492008-06-18 19:46
ReporterplujanView Statuspublic 
Assigned Togorkaion 
PrioritynormalResolutionfixedFixed in Version2.40alpha-r3
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

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

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0003745 closedgorkaion Message when deleting an Inventory is not correct 

-  Notes
(0003353)
gorkaion (viewer)
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.
(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 [^]

- Issue History
Date Modified Username Field Change
2008-06-18 19:46 plujan Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker