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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009540
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2009-06-18 13:162010-01-23 00:00
ReportershuehnerView Statuspublic 
Assigned Toalostale 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision5c2375daa8b4
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase version10gAnt version
Product VersionpiSCM 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

0009540: Mutating trigger error when trying to delete a module which has a module dependency

DescriptionWhen you try to delete a module which a at least one dependency than the following error is raised on oracle:

      
ORA-04091: table TADPI.AD_MODULE is mutating, trigger/function may not see it ORA-06512: at "TADPI.AD_MODULE_DEPENDENCY_MOD_TRG", line 30 ORA-04088: error during execution of trigger 'TADPI.AD_MODULE_DEPENDENCY_MOD_TRG'

Steps To ReproduceGoto Application Dictionary -> Module
Create a new module (just filling mandatory fields an save)
Set the new module into development
Goto the the Module Dependency tab
Add a module dependency entry and save it
Goto the module tag again
Try to delete the module
The error shown above is raised on oracle.
TagsModularity
Attached Filestxt file icon Uninstallerror.txt [^] (11,428 bytes) 2009-07-16 07:51 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0013551pi closedguilleaer When deleting a inclussion/dependency in a module, "is in development" flag is not checked 
blocks defect 00119942.50MP11 closedmarvintm Uninstall a module does not work properly under some circumstances 

-  Notes
(0018280)
thirumalaik (viewer)
2009-07-16 07:52

 I got this error when un installing a module(type-template).Please refer attachment Uninstallerror.txt(https://issues.openbravo.com/file_download.php?file_id=1542&type=bug [^])
(0023565)
hgbot (developer)
2010-01-19 13:46

 Repository: erp/devel/pi
Changeset: 5c2375daa8b4b7730b51f2f8e6bc748253d56ad4
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Jan 19 13:46:33 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/5c2375daa8b4b7730b51f2f8e6bc748253d56ad4 [^]

fixed bug 09540: Mutating trigger error when trying to delete a module which has a module dependency

---
M src-db/database/model/triggers/AD_MODULE_DEPENDENCY_MOD_TRG.xml
---
(0023673)
hudsonbot (viewer)
2010-01-20 23:26

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/5c2375daa8b4 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/fa6621f85351 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15942.obx [^]
(0023736)
marvintm (viewer)
2010-01-22 11:19

 The fix is correct. Modules with dependencies can now be deleted.

- Issue History
Date Modified Username Field Change
2009-06-18 13:16 shuehner New Issue
2009-06-18 13:16 shuehner Assigned To => rafaroda
2009-06-18 13:16 shuehner OBNetwork customer => No
2009-06-22 09:13 rafaroda Assigned To rafaroda => alostale
2009-06-22 09:13 rafaroda Status new => scheduled
2009-06-22 09:13 rafaroda Tag Attached: Modularity
2009-07-16 07:51 thirumalaik File Added: Uninstallerror.txt
2009-07-16 07:52 thirumalaik Note Added: 0018280
2009-07-16 07:53 thirumalaik Issue Monitored: thirumalaik
2010-01-19 13:23 alostale Relationship added blocks 0011994
2010-01-19 13:38 alostale Priority normal => urgent
2010-01-19 13:46 hgbot Checkin
2010-01-19 13:46 hgbot Note Added: 0023565
2010-01-19 13:46 hgbot Status scheduled => resolved
2010-01-19 13:46 hgbot Resolution open => fixed
2010-01-19 13:46 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5c2375daa8b4b7730b51f2f8e6bc748253d56ad4 [^]
2010-01-20 23:26 hudsonbot Checkin
2010-01-20 23:26 hudsonbot Note Added: 0023673
2010-01-22 11:19 marvintm Note Added: 0023736
2010-01-22 11:19 marvintm Status resolved => closed
2010-01-23 00:00 anonymous sf_bug_id 0 => 2937515
2011-11-25 10:33 alostale Relationship added related to 0013551

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker