Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010382Openbravo ERP00. Application dictionarypublic2009-08-20 09:092009-09-11 13:26
Reporternetworkb 
Assigned Tobalamurugan 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.35MP14 
Target Version2.35MP15Fixed in Version2.40MP9 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010382: Error obtained when trying to delete an ad_textinterface record
DescriptionWhen you try to delete an ad_textinterface record, after deleting its ad_textinterface_trl record associated, you get the following error:

ORA-04091: table TAD.AD_TEXTINTERFACES_TRL is mutating, trigger/function may not see it ORA-06512: at "TAD.AD_TEXTINTERFACES_TRG", line 54 ORA-04088: error during execution of trigger 'TAD.AD_TEXTINTERFACES_TRG'
Steps To Reproduce1. Go to Application Dictionary || Text Interfaces || Text Interface and select the record you want to delete.
2. Go to Application Dictionary || Text Interfaces || Text Interface >> Translation and delete its translation by clicking on "Delete Record" icon
3. Come back to Application Dictionary || Text Interfaces || Text Interface and try to delete the record by clicking on "Delete Record" icon
4. Relize that you obtained the "ORA-04091: table TAD.AD_TEXTINTERFACES_TRL is mutating, trigger/function may not see it ORA-06512: at "TAD.AD_TEXTINTERFACES_TRG", line 54 ORA-04088: error during execution of trigger 'TAD.AD_TEXTINTERFACES_TRG" error message.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00103512.35MP15 closed rafaroda Error obtained when trying to delete an ad_textinterface record 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-08-24 09:35rafarodaTypedefect => backport
2009-08-24 09:35rafarodafix_in_branch => 2.40
2009-08-24 09:38rafarodaAssigned Torafaroda => balamurugan
2009-08-24 09:38rafarodaPriorityimmediate => urgent
2009-08-26 11:45hgbotCheckin
2009-08-26 11:45hgbotNote Added: 0019232
2009-08-26 11:45hgbotStatusscheduled => resolved
2009-08-26 11:45hgbotResolutionopen => fixed
2009-08-26 11:45hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.3x/rev/24c58856fb3e0b529a63b3cee45e723d1c3afba7 [^]
2009-08-26 12:37balamuruganStatusresolved => new
2009-08-26 12:37balamuruganResolutionfixed => open
2009-08-26 12:38balamuruganNote Deleted: 0019232
2009-08-26 12:49hgbotCheckin
2009-08-26 12:49hgbotNote Added: 0019234
2009-08-26 12:49hgbotStatusnew => resolved
2009-08-26 12:49hgbotResolutionopen => fixed
2009-08-26 12:49hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.3x/rev/24c58856fb3e0b529a63b3cee45e723d1c3afba7 [^] => http://code.openbravo.com/erp/stable/2.40/rev/cd1f63639c9e77a6428c6adb51ba2acecd1e8a1f [^]
2009-08-28 11:04hgbotCheckin
2009-08-28 11:04hgbotNote Added: 0019248
2009-08-28 11:04hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/cd1f63639c9e77a6428c6adb51ba2acecd1e8a1f [^] => http://code.openbravo.com/erp/stable/2.40_cyclone/rev/cd1f63639c9e77a6428c6adb51ba2acecd1e8a1f [^]
2009-09-02 12:56sureshbabuStatusresolved => closed
2009-09-02 12:56sureshbabuNote Added: 0019413
2009-09-02 12:56sureshbabuFixed in Version => 2.40MP9
2009-09-09 15:25hgbotCheckin
2009-09-09 15:25hgbotNote Added: 0019609
2009-09-09 15:25hgbotStatusclosed => resolved
2009-09-09 15:25hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40_cyclone/rev/cd1f63639c9e77a6428c6adb51ba2acecd1e8a1f [^] => http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/cd1f63639c9e77a6428c6adb51ba2acecd1e8a1f [^]
2009-09-11 13:26psarobeStatusresolved => closed
2009-09-11 13:26psarobeNote Added: 0019804

Notes
(0019234)
hgbot   
2009-08-26 12:49   
Repository: erp/stable/2.40
Changeset: cd1f63639c9e77a6428c6adb51ba2acecd1e8a1f
Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
Date: Wed Aug 26 16:18:24 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/cd1f63639c9e77a6428c6adb51ba2acecd1e8a1f [^]

Fixes Issue 0010382: Error obtained when trying to delete an ad_textinterface record.

---
M src-db/database/model/triggers/AD_TEXTINTERFACES_TRG.xml
---
(0019248)
hgbot   
2009-08-28 11:04   
Repository: erp/stable/2.40_cyclone
Changeset: cd1f63639c9e77a6428c6adb51ba2acecd1e8a1f
Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
Date: Wed Aug 26 16:18:24 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40_cyclone/rev/cd1f63639c9e77a6428c6adb51ba2acecd1e8a1f [^]

Fixes Issue 0010382: Error obtained when trying to delete an ad_textinterface record.

---
M src-db/database/model/triggers/AD_TEXTINTERFACES_TRG.xml
---
(0019413)
sureshbabu   
2009-09-02 12:56   
Tested working fine.
Also verified with Rafa about the current behavior.
(0019609)
hgbot   
2009-09-09 15:25   
Repository: erp/stable/2.40_pageddatagrid
Changeset: cd1f63639c9e77a6428c6adb51ba2acecd1e8a1f
Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
Date: Wed Aug 26 16:18:24 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/cd1f63639c9e77a6428c6adb51ba2acecd1e8a1f [^]

Fixes Issue 0010382: Error obtained when trying to delete an ad_textinterface record.

---
M src-db/database/model/triggers/AD_TEXTINTERFACES_TRG.xml
---
(0019804)
psarobe   
2009-09-11 13:26   
Close again since for some reason it has been change the status to Resolved