Consultor Eletrônico



Kbase P174613: Getting error 8797 and 8784 when using a dbname.xb file to rebuild indexes after a failed idxbuild f
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   28/10/2010
Status: Verified

SYMPTOM(s):

Getting error 8797 and 8784 when using a dbname.xb file to rebuild indexes after a failed idxbuild failure.

ERROR - No table with given table name found in the database. (8797)

ERROR - Unable to extract table number for _file record (8784)

Manually created a new dbname.xb file containing the list of tables and indexes that were being built at the time of the original idxbuild failure.

FACT(s) (Environment):

dbname.xb file does not exist for the failed idxbuild process.
The newly created dbname.xb file contains a valid list of table and index names.
All Supported Operating Systems
Progress/OpenEdge Product Family
OpenEdge Category: Database

CAUSE:

The .xb file had extra spaces after the table and index names. The idxbuild utility is not expecting these extra spaces and therefore errors indicating that the table name does not exist in the _file record for the database.

FIX:

Remove all spaces from the dbname.xb file being used for the restart of a failed idxbuild process.