Kbase P3507: Internal error 6710304 (unknown sql92 error) in SQL from subsystem SQL92 function tpl_fetch called f
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/4/2009 |
|
Status: Verified
SYMPTOM(s):
Error executing SELECT statement using SQL-92
Internal error 6710304 (unknown SQL92 error) in SQL from subsystem SQL92 function tpl_fetch called from stub_tpl_scan_t::tpl_scan_fetch on PUB.<table> for <n>.
idxbuild fails with (1645) error
SYSTEM ERROR: RECID <recid> in <file-name> could not be found. (1645)
FACT(s) (Environment):
Progress 9.1x
All Supported Operating Systems
OpenEdge Category: Database
CAUSE:
The record read failed due to fragmented data.
This failure happens when SQL reads an index for a record (PUB.<Table>), gets a dbkey for the data record from the index, and then tries to read the record using the dbkey from the db.
FIX:
Restore a previous backup from a valid tape and apply the after image files to the database.