[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Link List broken (AREV Specific) ====
=== At 16 AUG 1999 02:00:19PM Thuan Pham  wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
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.
</QUOTE>
----

=== At 17 AUG 1999 01:57PM Don Miller - C3 Inc. wrote:  ===

<QUOTE>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.

</QUOTE>

----

=== At 18 AUG 1999 02:10PM Dale Walker wrote:  ===

<QUOTE>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

Dale_walker@Integrityonline3.com

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=59DCB63CE29571DD852567CF0062E840|View this thread on the  forum...]]