Kbase 21857: Failed to extract field from _Sequence record... (3191)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/03/2002 |
|
SUMMARY:
This Solution applies to Progress Version 9.1A and higher.
After adding a new sequence to the database (previously converted via conv89 utility) from the Data Dictionary and executing this simple query:
FOR EACH _Sequence NO-LOCK:
DISP _Sequence.
END.
you might get following errors:
SYSTEM ERROR: Cannot read field 11 from record, not enough fields.
(450)
SYSTEM ERROR: Failed to extract field 11 from _Sequence record
(table -67) with recid 632387. (3191)
EXPLANATION:
This behavior is a Progress conv89 utility bug 20000324-006, which is patched in Version 9.1B and fixed in 9.1C.
You might also encounter this error with 9.1C, in cases where your database was converted by a version of the conv89 utility that wasn't fixed or patched at the time; for example: 9.1A, or 9.1B with no patch.
SOLUTION:
A) If you are on 9.1C:
Shutdown your database and run "proutil db-name -C seqtempfix".
B) If you are on 9.1B:
Upgrade to 9.1C and then follow step A) given above. Or, ask
Technical Support for the latest patch for (retired) 9.1B.
C) If you are on 9.1A:
Upgrade to 9.1C and then follow step A) above. Or, dump/load your
database to a brand new V9 database.