Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019404Openbravo ERP09. Financial managementpublic2012-01-03 18:192012-09-13 10:42
Reporterxabiermerino 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP45 
Target VersionFixed 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
Summary0019404: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on design defect 00194052.50MP39 closed dmiguelez Error when you try to change a period's name in Oracle 
has duplicate defect 00195253.0MP8 closed jonalegriaesarte in oracle, a period can not be updated 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-01-03 18:19xabiermerinoNew Issue
2012-01-03 18:19xabiermerinoAssigned To => jonalegriaesarte
2012-01-03 18:19xabiermerinoModules => Core
2012-01-03 18:19xabiermerinoResolution time => 1328137200
2012-01-03 18:20xabiermerinoStatusnew => scheduled
2012-01-03 18:20xabiermerinofix_in_branch => pi
2012-01-03 18:21xabiermerinoIssue Monitored: networkb
2012-01-13 17:42jonalegriaesarteTypedefect => design defect
2012-01-13 17:42jonalegriaesartefix_in_branchpi =>
2012-01-25 09:29jonalegriaesarteRelationship addedhas duplicate 0019525
2012-01-30 17:17jonalegriaesarteTarget Version3.0MP8 => 3.0MP9
2012-03-02 12:56jonalegriaesarteTarget Version3.0MP9 => 3.0MP10
2012-03-29 16:11jonalegriaesarteTarget Version3.0MP10 =>
2012-09-03 17:51xabiermerinoversion3.0MP6 => 2.50MP45
2012-09-03 18:22hgbotCheckin
2012-09-03 18:22hgbotNote Added: 0051791
2012-09-03 18:22hgbotStatusscheduled => resolved
2012-09-03 18:22hgbotResolutionopen => fixed
2012-09-03 18:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/0a548ca8374d3404b1416fa9dd7901f65350b0e4 [^]
2012-09-07 14:50xabiermerinoNote Added: 0051943
2012-09-07 14:50xabiermerinoStatusresolved => closed
2012-09-13 10:42jonalegriaesarteAssigned Tojonalegriaesarte => dmiguelez

Notes
(0051791)
hgbot   
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   
2012-09-07 14:50   
verified