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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0019405
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 branch2.50Fixed in SCM revision391faee2dfa8
ProjectionnoneETAnoneTarget Version2.50MP39
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.50MP37SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

DescriptionReproduce in http://live.builds.openbravo.com/2.50-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 ]
blocks design defect 0019404 closeddmiguelez Error when you try to change a period's name in Oracle 

-  Notes
(0051537)
hgbot (developer)
2012-08-24 14:38

 Repository: erp/devel/pi
Changeset: fe92a8c562117402771b62a2d107958420d9a542
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Fri Aug 24 14:37:39 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/fe92a8c562117402771b62a2d107958420d9a542 [^]

Fixes issue 19405: 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
---
(0051554)
hgbot (developer)
2012-08-27 09:06

 Repository: erp/devel/pi
Changeset: 391faee2dfa8002d3fe885d9db97c01b3af1910b
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Mon Aug 27 09:06:11 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/391faee2dfa8002d3fe885d9db97c01b3af1910b [^]

Fixes issue 19405: 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
---
(0051561)
hgbot (developer)
2012-08-27 11:41

 Repository: erp/devel/pi
Changeset: 98eff0cfcf9aba761e744a279d4ac5b8c7f48704
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Mon Aug 27 11:40:36 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/98eff0cfcf9aba761e744a279d4ac5b8c7f48704 [^]

issue 19405: Error when you try to change a period's name in Oracle.
Added return clause

---
M src-db/database/model/triggers/C_PERIOD_TRG3.xml
---
(0051564)
hgbot (developer)
2012-08-27 12:22

 Repository: erp/devel/pi
Changeset: 8a76c7f83af7b3a79e86086f9def9bd6209df9d1
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Mon Aug 27 12:22:17 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8a76c7f83af7b3a79e86086f9def9bd6209df9d1 [^]

issue 19405: Error when you try to change a period's name in Oracle
Now the trigger filter by client and the error with org '0' is avoided

---
M src-db/database/model/triggers/C_PERIOD_TRG3.xml
---
(0051585)
hgbot (developer)
2012-08-28 10:52

 Repository: erp/devel/pi
Changeset: 2971a8c0024c766a1d907798a00145e72c14d4e9
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Aug 28 10:50:23 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/2971a8c0024c766a1d907798a00145e72c14d4e9 [^]

issue 19405: Error when you try to change a period's name in Oracle.
Now all periods are checked except Permanently closed

---
M src-db/database/model/triggers/C_PERIOD_TRG3.xml
---
(0051790)
xabiermerino (reporter)
2012-09-03 17:51

 Verified in PI

- Issue History
Date Modified Username Field Change
2012-01-03 18:20 xabiermerino Type defect => backport
2012-01-03 18:20 xabiermerino fix_in_branch => 2.50
2012-01-03 18:21 xabiermerino version 3.0MP6 => 2.50MP37
2012-01-03 18:21 xabiermerino Target Version 3.0MP8 => 2.50MP38
2012-01-03 18:21 xabiermerino Description Updated View Revisions
2012-01-03 18:21 xabiermerino Issue Monitored: networkb
2012-01-13 17:42 jonalegriaesarte Type backport => design defect
2012-01-17 09:30 jonalegriaesarte Target Version 2.50MP38 => 2.50MP39
2012-08-22 13:50 jecharri Assigned To jonalegriaesarte => jecharri
2012-08-24 14:38 hgbot Checkin
2012-08-24 14:38 hgbot Note Added: 0051537
2012-08-24 14:38 hgbot Status scheduled => resolved
2012-08-24 14:38 hgbot Resolution open => fixed
2012-08-24 14:38 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fe92a8c562117402771b62a2d107958420d9a542 [^]
2012-08-27 09:06 hgbot Checkin
2012-08-27 09:06 hgbot Note Added: 0051554
2012-08-27 09:06 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/fe92a8c562117402771b62a2d107958420d9a542 [^] => http://code.openbravo.com/erp/devel/pi/rev/391faee2dfa8002d3fe885d9db97c01b3af1910b [^]
2012-08-27 11:41 hgbot Checkin
2012-08-27 11:41 hgbot Note Added: 0051561
2012-08-27 12:22 hgbot Checkin
2012-08-27 12:22 hgbot Note Added: 0051564
2012-08-28 10:52 hgbot Checkin
2012-08-28 10:52 hgbot Note Added: 0051585
2012-09-03 17:51 xabiermerino Note Added: 0051790
2012-09-03 17:51 xabiermerino Status resolved => closed
2012-09-13 10:42 jonalegriaesarte Assigned To jecharri => dmiguelez

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker