Kbase 20413: Missing MKSCHEMA error when running PROUTIL -C conv89
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.X
SYMPTOM(s):
Using conv89 to convert a Progress database.
The proutil dbname -C conv89 completes, but with error.
MKSCHEMA utility cannot be found when issuing a Proutil -C conv89.
Error: mkschema was not found.\n (7171)
CHANGE:
Converting Database from Version 8.x to 9.x using the conv89 utility.
CAUSE:
The MKSCHEMA utility is only installed via a "complete" installation of a 4GL Development License or ProVision license, therefore the conv89 utility could not find the MKSCHEMA executable .
FIX:
Depending on the use of the database, this error may be of no consequence. If the database is to allow SQL-92 access, the MKSCHEMA utility must be run. If no SQL-92 access is planned for the database, the MKSCHEMA is of little importance. The database runs fine until SQL-92 access is desired. At that time, MKSCHEMA must be run.
In Progress Version 9.x, the MKSCHEMA utility creates the SQL-92 index holders.
This utility can be run manually or in conjunction with other utilities. In conjunction with the conv89 utility, the MKSCHEMA utility is called upon to create the SQL-92 index holders on a newly created database after conversion.
To verify the MKSCHEMA has been installed, examine the DLC/bin subdirectory to determine if the file is present. This can be done on UNIX machines by changing directories into the DLC/bin subdirectory and performing a directory listing:
cd $DLC/bin<return>
ls mk*<enter>
or on Windows NT systems by using the file find utility and searching for mkschema.
If the MKSCHEMA file is not present on the system and you have the correct license, contact Progress Technical Support to receive the file, or reinstall Progress choosing the "Complete" Installation type.