Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019405Openbravo ERP09. Financial managementpublic2012-01-03 18:192012-09-13 10:42
Reporterxabiermerino 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP37 
Target Version2.50MP39Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019405: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks design defect 0019404 closed dmiguelez Error when you try to change a period's name in Oracle 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-01-03 18:20xabiermerinoTypedefect => backport
2012-01-03 18:20xabiermerinofix_in_branch => 2.50
2012-01-03 18:21xabiermerinoversion3.0MP6 => 2.50MP37
2012-01-03 18:21xabiermerinoTarget Version3.0MP8 => 2.50MP38
2012-01-03 18:21xabiermerinoDescription Updatedbug_revision_view_page.php?rev_id=3015#r3015
2012-01-03 18:21xabiermerinoIssue Monitored: networkb
2012-01-13 17:42jonalegriaesarteTypebackport => design defect
2012-01-17 09:30jonalegriaesarteTarget Version2.50MP38 => 2.50MP39
2012-08-22 13:50jecharriAssigned Tojonalegriaesarte => jecharri
2012-08-24 14:38hgbotCheckin
2012-08-24 14:38hgbotNote Added: 0051537
2012-08-24 14:38hgbotStatusscheduled => resolved
2012-08-24 14:38hgbotResolutionopen => fixed
2012-08-24 14:38hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fe92a8c562117402771b62a2d107958420d9a542 [^]
2012-08-27 09:06hgbotCheckin
2012-08-27 09:06hgbotNote Added: 0051554
2012-08-27 09:06hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/fe92a8c562117402771b62a2d107958420d9a542 [^] => http://code.openbravo.com/erp/devel/pi/rev/391faee2dfa8002d3fe885d9db97c01b3af1910b [^]
2012-08-27 11:41hgbotCheckin
2012-08-27 11:41hgbotNote Added: 0051561
2012-08-27 12:22hgbotCheckin
2012-08-27 12:22hgbotNote Added: 0051564
2012-08-28 10:52hgbotCheckin
2012-08-28 10:52hgbotNote Added: 0051585
2012-09-03 17:51xabiermerinoNote Added: 0051790
2012-09-03 17:51xabiermerinoStatusresolved => closed
2012-09-13 10:42jonalegriaesarteAssigned Tojecharri => dmiguelez

Notes
(0051537)
hgbot   
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   
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   
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   
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   
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   
2012-09-03 17:51   
Verified in PI