Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004862Openbravo ERPZ. Otherspublic2008-09-08 21:202009-01-05 09:46
Reporterjpabloae 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilitysometimes
StatusclosedResolutionout of date 
PlatformOS30OS VersionGentoo - 2.6.24
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004862: dba_recompile should be run after creating/updatng the database in Oracle
DescriptionAfter creating the database some objects may be in invalid state.
Steps To Reproduce
Proposed SolutionIt would be good to run the DBA_RECOMPILE procedure after creating/updating the database.
Additional Information
TagsNo tags attached.
Relationships
related to defect 00048632.50 closed cromero SL_CashJournal_Amounts_data.xsql doesn't compile 
depends on backport 0005068 closed marvintm dba_recompile should be run after creating/updatng the database in Oracle 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-08 21:20jpabloaeNew Issue
2008-09-08 21:20jpabloaeAssigned To => cromero
2008-09-08 21:20jpabloaesf_bug_id0 => 2100782
2008-09-08 21:20jpabloaeOBNetwork customer => No
2008-09-08 21:20jpabloaeRegression testing => No
2008-09-08 21:32jpabloaeBuild => 7048
2008-09-08 21:35jpabloaeRelationship addedrelated to 0004863
2008-09-16 16:08cromeroStatusnew => scheduled
2008-09-16 16:08cromeroAssigned Tocromero => marvintm
2008-09-16 16:08cromerofix_in_branch => trunk
2009-01-02 21:58iciordiaAssigned Tomarvintm => iciordia
2009-01-04 12:44iciordiaAssigned Toiciordia => marvintm
2009-01-05 09:46marvintmStatusscheduled => closed
2009-01-05 09:46marvintmNote Added: 0011906
2009-01-05 09:46marvintmResolutionopen => out of date

Notes
(0011906)
marvintm   
2009-01-05 09:46   
create.database and update.database already run dba_recompile in Oracle. The call is located in the postscript, and is executed immediately after the creation or update of the database structure.