I am having a problem with "Link list error".
The error messages read
"Link list in "!table*location*date" is broken, the transaction can not properly flush. To correct this problem, Please rebuild all indexes for the table "tables*location*date".
The client do have NLM load.
Can this problem be prevent not to happen in the future.
They do not have a dedicated indexer.
Broken link-lists in index (!)files shouldn't happen with the NLM loaded unless something is really wrong. I have a utility to repair a broken link list but it is only really useful when you need to be able to completely rebuild the indexes. You can try the following:
Remove all indexes from the file. You may get locked up so use a TCL UNLOCK ALL. Make sure that the Bang (!) file is gone. Next, re-add the indexes and do a batch update from the Tools/Files/Indexes/Update menu choices. Since a broken link-list indicates that a forward pointer (starting from the 0 record in the ! file) is missing or has become corrupted, you might also try editing the 0 record and make it point to itself. This will usually let you remove the indexes if all else fails.
Don Miller
C3 Inc.
You might have a valuemark in the key field of one (or more) of the records. You might try the solution to my problem which was similar. ie. create a new blank table. Copy the dict table to that new dict table and overwrite. Then copy the records to the new table. Rename the table to …_old and the …_new to the tablename. Reindex. See if this works.
Dale Walker