index_flush() error - index row missing (AREV Specific) [Revelation On-Line Wiki]

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

At 17 DEC 2001 10:53:11AM Wilhelm Schmitt wrote:

AREV Specific

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.

The Sprezzatura Group

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.

The Sprezzatura Group

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.

The Sprezzatura Group

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.

The Sprezzatura Group

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.

View this thread on the forum...