Salesforce

Error 9818 when upgrading database with large files enabled with dlc\bin\*dbutils

« Go Back

Information

 
TitleError 9818 when upgrading database with large files enabled with dlc\bin\*dbutils
URL NameP82603
Article Number000150679
EnvironmentProduct: Progress
Version: 9.1D, 9.1E
Product: OpenEdge
Version: All supported versions
OS: All supported platforms
Question/Problem Description
Error 9818 when upgrading database with large files enabled with dbutils
Upgrading Database to the next major release with dlc\dbutils provided from prior version fails error 9818

Error 9818 running 83_dbutil  or 83_proutil executables
Error 9818 running 91_dbutil or 91_proutil executables
Error 9818 running 91conv89, 91truncatebi or conv911 scripts
Error 9818 running 101a_dbutil executables
Error 9818 running 102b05_dbutil or 102b08_dbutil executables
Steps to ReproducePrior Major version: proutil dbname -C enablelargefiles
Next Major version: DLC/bin/91dbutils/91_proutil dbname -C truncate bi
Clarifying Information
Database has largefiles enabled
Error MessageOnly Enterprise systems may access a database with large files enabled (9818)
Defect Number
Enhancement Number
Cause
The Enterprise Database License needs to be purchased in order to work with large databases.  The previous version sample progress.cfg file provided with the previous major versions executables, does not have sufficient rights to allow the manipulation of a large file enabled database.  This is by design and will not change.

The purpose of the *dbutils directory is to allow DBA's the capability to use the new installation to perform necessary steps to migrate older databases, when the prior version is not installed on the server where the migration is taking place, by being able to run basic _dbutil instruction from the command line. These do not provide rights to perform operations against a large file enabled database which requires an Enterprise Database License:
  • In Progress 9 and earlier, the progress.cfg included in the 91dbutils is a Query Results license
  • Since OpenEdge 10 the NameServer license is provided in the *dbutils progress.cfg
Resolution
Use the License Configuration file from the previous version which contains the Enterprise DB license, and use *it* instead of the progress.cfg that comes with the DLC/bin/*dbutil utilities. It is important to note similar failures will occur when the database to be converted is enabled for any features that require a specific OpenEdge license (TDE, OER, MT, TP).

1. Copy the progress.cfg from the production environment where the Enterprise Database License was installed, to the dlc/*dbutils directory of the next major version OpenEdge installation:
  • 83dbutils/progress.cfg
  • 91dbutils/progress.cfg
  • 101dbutils/progress.cfg
  • 102dbutils/progress.cfg
2. Use the PROCFG environment variable to use the earlier version's executables in DLC/bin/*dbuti

For example:
cd $DLC/bin/102dbutils
DLC=`pwd`;export DLC
PROCFG=$DLC/progress.cfg;export PROCFG
PATH=$DLC:$PATH;export PATH
cd /db
102b08_dbutil.exe <dbname> -C truncate bi

3. After the conversion an Enterprise database License for the current major version is required.

Since OpenEdge 12 a license file (progress.cfg) is not provided with in the DLC/bin/*dbutil directory.  The utilities will use the current OpenEdge 12 licenses where an Enterprise Database license is required. By default the from dlc/progress.cfg is used otherwise set the PROCFG environment variable as above.
117_dbutil.exe <dbname> -C truncate bi
117_dbutil.exe probkup <dbname> 1112.back
117_dbutil.exe prorest <dbname> 1112.back -verbose
echo y | proutil <dbname> -C conv112
Workaround
Notes
Keyword Phrase
Last Modified Date11/20/2020 6:52 AM

Powered by