Icon View Incident Report

Minor Minor
Reported By: Suat Demirkiran
Reported On: 5/19/2010
For: Version 4.29 Build 4
# 3394 Invalid Field Types in Text Index Not Repaired Correctly by Table Repair

In attached file there is a corrupted table (dat and idx)

when I try to repair it, DBISAM System Utility says "It is repaired successfuly."

But the table produces error # 8961 Header corrupted.

Solution:
I found that the problem is in IDX file.
After deleting IDX file and re-creating the indexes (from my SQL script) solved the problem.


Comments Comments and Workarounds
The problem was caused by a rare condition where the field type for the text index in the table was invalid for text indexes (it was a TimeStamp field instead of a String or Memo field). The workaround is as-described.


Resolution Resolution
Fixed Problem on 3/10/2011 in version 4.30 build 3


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

Image