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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0019404
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 09. Financial managementmajoralways2012-01-03 18:192012-09-13 10:42
ReporterxabiermerinoView Statuspublic 
Assigned Todmiguelez 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision0a548ca8374d
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.50MP45SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket13698
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0019404: Error when you try to change a period's name in Oracle

DescriptionReproduce in http://live.builds.openbravo.com/int-full-oracle/ [^]

When you try to modify a period's name this error appears:


ORA-04091: table R250_FULL_ORACLE.C_PERIOD is mutating, trigger/function may not see it
ORA-06512: at "R250_FULL_ORACLE.C_PERIOD_TRG2", line 52
ORA-04088: error during execution of trigger 'R250_FULL_ORACLE.C_PERIOD_TRG2'
Steps To Reproduce-As admin go to Fiscal Calendar >> Period
-try to change a period's name
-realize that the error appears
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on design defect 00194052.50MP39 closeddmiguelez Error when you try to change a period's name in Oracle 
has duplicate defect 00195253.0MP8 closedjonalegriaesarte in oracle, a period can not be updated 

-  Notes
(0051791)
hgbot (developer)
2012-09-03 18:22

 Repository: erp/stable/2.50
Changeset: 0a548ca8374d3404b1416fa9dd7901f65350b0e4
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Mon Sep 03 18:21:23 2012 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/0a548ca8374d3404b1416fa9dd7901f65350b0e4 [^]

Fixes issue 19404: Error when you try to change a period's name in Oracle

---
M src-db/database/model/triggers/C_PERIOD_TRG2.xml
A src-db/database/model/triggers/C_PERIOD_TRG3.xml
---
(0051943)
xabiermerino (viewer)
2012-09-07 14:50

 verified

- Issue History
Date Modified Username Field Change
2012-01-03 18:19 xabiermerino New Issue
2012-01-03 18:19 xabiermerino Assigned To => jonalegriaesarte
2012-01-03 18:19 xabiermerino Modules => Core
2012-01-03 18:19 xabiermerino OBNetwork customer => Yes
2012-01-03 18:19 xabiermerino Support ticket => 13698
2012-01-03 18:19 xabiermerino Resolution time => 1328137200
2012-01-03 18:20 xabiermerino Status new => scheduled
2012-01-03 18:20 xabiermerino fix_in_branch => pi
2012-01-03 18:21 xabiermerino Issue Monitored: networkb
2012-01-13 17:42 jonalegriaesarte Type defect => design defect
2012-01-13 17:42 jonalegriaesarte fix_in_branch pi =>
2012-01-25 09:29 jonalegriaesarte Relationship added has duplicate 0019525
2012-01-30 17:17 jonalegriaesarte Target Version 3.0MP8 => 3.0MP9
2012-03-02 12:56 jonalegriaesarte Target Version 3.0MP9 => 3.0MP10
2012-03-29 16:11 jonalegriaesarte Target Version 3.0MP10 =>
2012-09-03 17:51 xabiermerino version 3.0MP6 => 2.50MP45
2012-09-03 18:22 hgbot Checkin
2012-09-03 18:22 hgbot Note Added: 0051791
2012-09-03 18:22 hgbot Status scheduled => resolved
2012-09-03 18:22 hgbot Resolution open => fixed
2012-09-03 18:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/0a548ca8374d3404b1416fa9dd7901f65350b0e4 [^]
2012-09-07 14:50 xabiermerino Note Added: 0051943
2012-09-07 14:50 xabiermerino Status resolved => closed
2012-09-13 10:42 jonalegriaesarte Assigned To jonalegriaesarte => dmiguelez

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker