Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010351Openbravo ERP00. Application dictionarypublic2009-08-20 09:092009-08-25 00:00
Reporternetworkb 
Assigned Torafaroda 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version2.35MP14 
Target Version2.35MP15Fixed in Version 
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
Summary0010351: 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
related to defect 0005031pi closed alostale It is not possible to delete text interfaces 
depends on backport 00103822.35MP15 closed balamurugan Error obtained when trying to delete an ad_textinterface record 
depends on backport 00103832.35MP15 closed balamurugan Error obtained when trying to delete an ad_textinterface record 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-08-20 09:09networkbNew Issue
2009-08-20 09:09networkbAssigned To => rafaroda
2009-08-20 09:09networkbOBNetwork customer => Yes
2009-08-24 09:35rafarodaRelationship addedrelated to 0005031
2009-08-24 09:35rafarodaStatusnew => scheduled
2009-08-24 09:35rafarodafix_in_branch => pi
2009-08-24 09:36rafarodaPriorityimmediate => urgent
2009-08-24 09:36rafarodafix_in_branchpi =>
2009-08-24 09:37rafarodaStatusscheduled => closed
2009-08-24 09:37rafarodaNote Added: 0019182
2009-08-24 09:37rafarodaResolutionopen => no change required
2009-08-25 00:00anonymoussf_bug_id0 => 2843871

Notes
(0019182)
rafaroda   
2009-08-24 09:37   
No change is required for pi source code since the issue is not reproducing there.

Backports to 2.40 [1] and 2.3x [2] versions remain open.

[1] https://issues.openbravo.com/view.php?id=10382 [^]
[2] https://issues.openbravo.com/view.php?id=10383 [^]