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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0010382
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 00. Application dictionaryminoralways2009-08-20 09:092009-09-11 13:26
ReporternetworkbView Statuspublic 
Assigned Tobalamurugan 
PriorityurgentResolutionfixedFixed in Version2.40MP9
StatusclosedFix in branch2.40Fixed in SCM revisioncd1f63639c9e
ProjectionnoneETAnoneTarget Version2.35MP15
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.35MP14SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 00103512.35MP15 closedrafaroda Error obtained when trying to delete an ad_textinterface record 

-  Notes
(0019234)
hgbot (developer)
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 (developer)
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 (reporter)
2009-09-02 12:56

 Tested working fine.
Also verified with Rafa about the current behavior.
(0019609)
hgbot (developer)
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 (manager)
2009-09-11 13:26

 Close again since for some reason it has been change the status to Resolved

- Issue History
Date Modified Username Field Change
2009-08-24 09:35 rafaroda Type defect => backport
2009-08-24 09:35 rafaroda fix_in_branch => 2.40
2009-08-24 09:38 rafaroda Assigned To rafaroda => balamurugan
2009-08-24 09:38 rafaroda Priority immediate => urgent
2009-08-26 11:45 hgbot Checkin
2009-08-26 11:45 hgbot Note Added: 0019232
2009-08-26 11:45 hgbot Status scheduled => resolved
2009-08-26 11:45 hgbot Resolution open => fixed
2009-08-26 11:45 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.3x/rev/24c58856fb3e0b529a63b3cee45e723d1c3afba7 [^]
2009-08-26 12:37 balamurugan Status resolved => new
2009-08-26 12:37 balamurugan Resolution fixed => open
2009-08-26 12:38 balamurugan Note Deleted: 0019232
2009-08-26 12:49 hgbot Checkin
2009-08-26 12:49 hgbot Note Added: 0019234
2009-08-26 12:49 hgbot Status new => resolved
2009-08-26 12:49 hgbot Resolution open => fixed
2009-08-26 12:49 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.3x/rev/24c58856fb3e0b529a63b3cee45e723d1c3afba7 [^] => http://code.openbravo.com/erp/stable/2.40/rev/cd1f63639c9e77a6428c6adb51ba2acecd1e8a1f [^]
2009-08-28 11:04 hgbot Checkin
2009-08-28 11:04 hgbot Note Added: 0019248
2009-08-28 11:04 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/cd1f63639c9e77a6428c6adb51ba2acecd1e8a1f [^] => http://code.openbravo.com/erp/stable/2.40_cyclone/rev/cd1f63639c9e77a6428c6adb51ba2acecd1e8a1f [^]
2009-09-02 12:56 sureshbabu Status resolved => closed
2009-09-02 12:56 sureshbabu Note Added: 0019413
2009-09-02 12:56 sureshbabu Fixed in Version => 2.40MP9
2009-09-09 15:25 hgbot Checkin
2009-09-09 15:25 hgbot Note Added: 0019609
2009-09-09 15:25 hgbot Status closed => resolved
2009-09-09 15:25 hgbot Fixed in SCM revision http://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:26 psarobe Status resolved => closed
2009-09-11 13:26 psarobe Note Added: 0019804

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker