Kbase P98514: Running select * from a table results in fmget error (13)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/2/2009 |
|
Status: Verified
SYMPTOM(s):
9.1C09
Running select * from a table results in error (13)
SYSTEM ERROR: fmget: bad record or unknown value. (13)
Error isolated to one field in a single table
Database created using data definition (df) files from a production database
Database meant to be a replica of the production database
A schema record in the database (a record in the _Field file) is corrupted.
FACT(s) (Environment):
Progress 9.1C
UNIX
OpenEdge Category: Database
CHANGE:
The values for Help: and for Desc: under Valmsg: within the field schema did not match original database
CAUSE:
The exact cause is unknown at the time of this writing.
FIX:
Make a backup and then change the schema values for the problem field to match the values on the production database.
Access the field values on both databases:
1. Access the database with a single user client
2. Select Data Dictionary under Tools menu item
3. Select Schema
4. Select modify table
5. Select tablename
6. Tab to select Field Editor
7. Tab to select modify
8. Use arrow keys to select the appropriate field
Modify copy to reflect what is in the original field.