Kbase 21036: V9 DB Corruption Caused By Schema Change With Specific Patch
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1B
SYMPTOM(s):
SYSTEM ERROR: bffld: nxtfld: scan past last field. (16)
SYSTEM ERROR: Failed to extract field <field-num> from <file-name> record (table <table-num>) with recid <RECID>. (3191)
SYSTEM ERROR: Cannot read field from record, not enough fields. (450)
Database was converted with proutil <dbname> -C conv89.
A field was removed from table <file-name> mentioned in error 3191.
CAUSE:
Bug# 20010601-004
CAUSE:
This is a known issue.
With any of the listed patches installed, Database corruption will occur on a database converted from Version 8 to Version 9 as a result of the first schema change made.
The table affected by the schema change will be corrupted.
These are the patches affected:
HP-UX 64-bit 9.1B10
LINUX Intel 9.1B07
SUN SOLARIS 9.1B12
SUN SOLARIS INTEL 9.1B11
WebSpeed LINUX Intel 3.1B07
WebSpeed SUN SOLARIS 3.1B12
WebSpeed SUN SOLARIS 3.1B11
WebSpeed WIN NT 32 I 3.1B19
WIN NT 32 Intel 9.1B19
WIN NT Developer's W 9.1B19
NOTE: Not all platforms are affected; only platforms and versions listed above.
FIX:
Restore the database from backup.
If you need to migrate your database, please either:
- revert back the base version of 9.1B, or
- revert back to 9.1B and a patch version prior to the offending one, or
- upgrade to 9.1C or later.
PROGRESS apologizes for any inconvenience this bug may have caused your company.