Kbase P155060: Getting error 450 and 3191 when attempting to read records from a table after a binary dump and load
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/08/2010 |
|
Status: Verified
SYMPTOM(s):
Getting error 450 and 3191 when attempting to read records from a table.
SYSTEM ERROR: Cannot read field from record, not enough fields. (450)
Previous message sent on behalf of user <user number>. (5512)
SYSTEM ERROR: Failed to extract field <field-num> from <file-name> record (table <table-num>) with recid <RECID>. (3191)
The 3191 errors are occurring for several records.
The records with the 3191 error are not consecutive based on recid.
FACT(s) (Environment):
Database was dumped and loaded using binary dump routine.
proutil dbname -C idxbuild completes successfully without errors
proutil dbname -C dbanalys completes successfully without errors
proutil dbname -C tabanalys completes successfully without errors
Scan of the database using proutil dbname -C dbrpr shows no corruption.
All Supported Operating Systems
OpenEdge 10.1C
CHANGE:
Database was binary dumped from 8.2C on AIX 4.3.3 and loaded into 10.1C04 on AIX 5.3
CAUSE:
The records that are experiencing the 450 error have a field contained within the record that has an invalid format. These records existed in the 8.2C database prior to the dump and load. Binary dump and the tools mentioned earlier in this solution do not look for field formatting issues associated with a record.
FIX:
Fix the corrupted records by exporting them. Then delete the records from the database using idxfix. Then import the records back into the database. For detailed steps to accomplish these tasks, see solution: P150410, "How to trouble shoot error (450) and (3191) that occur when dumping or displaying records"