Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0009540Openbravo ERPA. Platformpublic2009-06-18 13:162010-01-23 00:00
shuehner 
alostale 
urgentminorhave not tried
closedfixed 
5
pi 
 
Core
No
0009540: Mutating trigger error when trying to delete a module which has a module dependency
When 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'

Goto 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.
Modularity
related to defect 0013551pi closed guilleaer When deleting a inclussion/dependency in a module, "is in development" flag is not checked 
blocks defect 00119942.50MP11 closed marvintm Uninstall a module does not work properly under some circumstances 
txt Uninstallerror.txt (11,428) 2009-07-16 07:51
https://issues.openbravo.com/file_download.php?file_id=1542&type=bug
Issue History
2009-06-18 13:16shuehnerNew Issue
2009-06-18 13:16shuehnerAssigned To => rafaroda
2009-06-22 09:13rafarodaAssigned Torafaroda => alostale
2009-06-22 09:13rafarodaStatusnew => scheduled
2009-06-22 09:13rafarodaTag Attached: Modularity
2009-07-16 07:51thirumalaikFile Added: Uninstallerror.txt
2009-07-16 07:52thirumalaikNote Added: 0018280
2009-07-16 07:53thirumalaikIssue Monitored: thirumalaik
2010-01-19 13:23alostaleRelationship addedblocks 0011994
2010-01-19 13:38alostalePrioritynormal => urgent
2010-01-19 13:46hgbotCheckin
2010-01-19 13:46hgbotNote Added: 0023565
2010-01-19 13:46hgbotStatusscheduled => resolved
2010-01-19 13:46hgbotResolutionopen => fixed
2010-01-19 13:46hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5c2375daa8b4b7730b51f2f8e6bc748253d56ad4 [^]
2010-01-20 23:26hudsonbotCheckin
2010-01-20 23:26hudsonbotNote Added: 0023673
2010-01-22 11:19marvintmNote Added: 0023736
2010-01-22 11:19marvintmStatusresolved => closed
2010-01-23 00:00anonymoussf_bug_id0 => 2937515
2011-11-25 10:33alostaleRelationship addedrelated to 0013551

Notes
(0018280)
thirumalaik   
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   
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   
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   
2010-01-22 11:19   
The fix is correct. Modules with dependencies can now be deleted.