index_flush() error - index row missing (AREV Specific)
At 17 DEC 2001 10:53:11AM Wilhelm Schmitt wrote:
During an index update with INDEX_FLUSH the system stopped processing and displayed the following message:
The index row "NUM_ESCRIT**11,617" is missing. Then indexed column in the table SOLICITUDES should be rebuilt."
"The index row is missing…" does this refer to an error in the main file or in the index file?
Where/what should I look for, to trace the error?
Thanks in advance for any help.
Wilhelm
At 17 DEC 2001 12:50PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
This refers to an error in the ! file itself - one of the btree nodes is missing. We normally find that this error occurs if one of the AREV workstations is not configured correctly, again, normally the write behind cacheing.
World Leaders in all things RevSoft
At 17 DEC 2001 06:34PM Wilhelm Schmitt wrote:
Thanks Sprezz,
If a node is missing, this means, that only that particular index field is affected, not necessarily all indexed fields of the file.
Is that correct?
Wilhelm
At 17 DEC 2001 06:51PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Correct. That one index can be considered corrupt. There may, of course, be other missing nodes.
World Leaders in all things RevSoft
At 17 DEC 2001 09:11PM Wilhelm Schmitt wrote:
Sprezz,
Is there any utility available to check missing nodes in indexes?
Wilhelm
At 18 DEC 2001 02:47AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
We are not aware of any such commercially available utility.
World Leaders in all things RevSoft
At 18 DEC 2001 09:38AM Victor Engel wrote:
Try doing a select by the field:
SELECT table_name BY indexed_field
This will force a read of the entire index for that field, which should traverse all the nodes.
At 18 DEC 2001 10:21AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
We tried this along with an (SE) but we still got an error at the first occurence and then the select stopped. As a side point this error fails to unlock the indexing row thus blocking future updates.
World Leaders in all things RevSoft
At 19 DEC 2001 01:34PM Wilhelm Schmitt wrote:
Sprezz,
…workstations is not configured correctly, again, normally the write behind cacheing..
How should I configure that?
Wilhelm
BTW: the update was run on directly on the file server.