Salesforce

Data Administration tool Database Options are not enabled

Printable View
« Go Back

Information

 
TitleData Administration tool Database Options are not enabled
URL NameP117034
Article Number000167598
EnvironmentProduct: OpenEdge
Version: 10.1x , 10.2x
OS: All supported platforms
Question/Problem Description
Database Options of the Data Administration tool are not enabled.
Admin > Database Options are all disabled / grayed out
There are no records at all in the _db-option table
Running updateschema from the current Openedge version does not enable Database Options
Steps to Reproduce
Clarifying Information
Auditing has recently been enabled without error

Database was initially created in any version prior to OpenEdge 10.1A
Database was migrated from to OpenEdge 10 using the conv910 migration routine.
Database has not been dumped and loaded since migrating to 10.1X
Database has had it's schema updated with PROUTIL -C updateschema when it was initially upgraded to OpenEdge 10.1A.
Error Message
Defect NumberDefect OE00129337 / PSC00175101
Enhancement Number
Cause
The _Db-option table was added to OpenEdge in version 10.1A. It is necessary to support authentication as well as other security and auditing features of OpenEdge.

The database was converted to OpenEdge 10 with a version of the conv910 utility prior to 10.2A02 where the _Db-option table is added but the initial records​ are not populated.
The reason updateschema does not correct this is that the conv910 routine has already updated the database meta-schema as part of it's conversion tasks. 
 
Resolution
The CONV910 utility in OpenEdge 10.2A02, 10.1B or later has been reworked to include the initial _Db-Option records necessary.

Since the database has already been converted populate the _Db-Option table with initial record data:

1.  Create a simple dummy database of the same version as the current database, then enable auditing.
As long as the areas listed are Type II Storage Areas, it doesn't matter which areas are used for this dummy database
           
$   proutil dummy -C enableauditing area Audit_Data indexarea Audit_Index
 
2.  Dump the Database Options data from the dummy audit enabled database (_db-option.d)
    
Admin > Dump Data and definitions > Database Options

3.  Delete the dummy database

4.  Load the _db-option table data into the current database

5.  After the data are loaded, all the initial _db-option records are pre-defined except field _db-option._db-recid must match the record id of the _db record of the current database. This will need to be created with the following ABL:
  
​FIND FIRST _db.
FOR EACH _db-option.
    ASSIGN _db-option._db-recid = RECID(_db).
END.

 
Workaround
Notes
Keyword Phrase
Last Modified Date6/1/2018 12:03 PM
Powered by