Icon View Incident Report

Serious Serious
Reported By: Petter Topp
Reported On: 2/3/2006
For: Version 4.22 Build 4
# 2160 Repairing a Table with a Corrupted Index Results in a #9217 Error Reading File Error on the Index

have read in another thread how to handle a situation when the repair function will not solve a corrupt IDX file.

Today we have had such a case, and running Dbsys repair fails with the message: DBISAM Engine Error # 9217 Error reading from the table or backup file 'xxxxx'.

As far as I know the only solution now would be to delete the IDX file and recreate it with the proper indexes. Apparently this works in our case.

Comments Comments and Workarounds
The .IDX file was 0 bytes and was completely truncated. This is extremely rare, and was most likely caused by manual means. The workaround was to delete the .IDX file before repairing.

Resolution Resolution
Fixed Problem on 2/5/2006 in version 4.22 build 5

Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard with Source