| 3/6/2009 9:31:21 AM - BLOB version file is too old (Id: 578 ) PROBLEM: User receives message "BLOB version file is too old".
SOLUTION: Locate the HSFIS_DataDoctor_Utility.exe on the shared network drive S:\HSFIS\Utility. Run this on the user's database with all users logged out of HSFIS.
Launch the .exe file and click "Find Bad Tables".
Notify the user that they will lose all comments data that have entered with the associated tables. Click Fix.
After locating the damaged tables, it will make a copy of the corresponding .MDX and .DBT files from the Dbf_Stru folder so the table can be opened. Once the tables are opened, it will copy the records of the .DBF file to a temporary table. Then it will create a new table by copying the .DBF, .MDX and .DBT files from the Dbf_Stru folder. Finally it will copy the records from the temporary table to the newly created empty table.
“Fix Sesn’s Bad Tables” is to designed to fix tables in a single session OR C:\Hsfis6\Tables\Sesn000X
“Fix..\Tables bad tables” is to designed to fix tables in all sessions OR C:\Hsfis6\Tables
Fix ASDT Table will correct duplicate instances of CONTACT_ID in the ASDT.DBF TABLE by:
1. Sorting duplicates by Family_ID + MEMBER_ID +CONTACT_ID + ASDT_DATE.
2. Locate earliest ASDT_DATE record. Do not edit this record.
3. Move duplicate CONTACT_ID records to next available CONTACT_ID record. |