Kbase P5807: Database minor version mismatch. Expected . Found . (8406)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/03/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.0X
FACT(s) (Environment):
Progress 9.1X
SYMPTOM(s):
Database minor version mismatch. Expected <version>. Found <version>. (8406)
Database minor version mismatch. Expected 0. Found 3. (8406)
WARNING: updates to this database are not recommended. (8404)
Get a warning when opening database using correct version of Data Administrator.
CHANGE:
Database had been accessed using new version in a single user mode.
CAUSE:
Newer database utilities did a minor version conversion during the access.
FIX:
The auto-convert utility was added to 91A (and later) in order to provide support for the latest SQL-92 enhancements. These enhancements caused physical changes to the version 9 database that were not part of any earlier v9 database release (e.g. 90a, 90b, or 91a1b). A minor version update was utilized to signify the corresponding database enhancements.
Impact to 90a/90b/91a1b 4gl clients: there is no impact to the utilization of an upgraded 91A database by an earlier version 9 client. Essentially, the data types utilized by the SQL engine were widened to accommodate a broader range of data for SQL-92 (see details below), which has not affect on the 4GL.
Impact to 90a SQL Clients: do not use the wider DECIMAL data in 90a. This includes use of the UPDATE STATISTICS command as well as accessing any wider DECIMAL data you may have inserted into your database with a later version (90b and up). Since the 90a code base has no facilities for handling the wider DECIMAL data, unpredictable actions can result.
Impact to 90b/91a1b SQL clients: there is no negative impact to using wider DECIMAL data with these versions.
Update Details:
- The _width value of the _format field within the _field table was changed from 75 to 150.
- All user defined _field entries of _Data-Type = "decimal" and _width value of 15 (original default width for decimal fields) were changed by adding the current value of the _decimals value (scale) to the existing _width value.
- Within the _sysdatatypes table, field entries with _dhtypename = "numeric", "decimal", or "money" were modified by changing the _TypePrecision value from 32 to 50.
- All _sysnumstat fields within the _field table with name = VAL# (e.g. VAL1 through VAL10) were changed by modifying the _width value from 32 to 50, and changing the _decimals (scale) field for the same entries to 10.
Upon successful completion of autoconvert, the minor version number will be set to 3.