updating indexes (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 07 JAN 2003 11:09:41AM Patrick Caufield wrote:

AREV Specific

Thanks for all the help but I think we are going in the wrong direction. Let me reexplain the problem.

During the process of rebuilding all indexed fileds for a file the btrees rebuild ok but during the rebuild of a relational index the rebuild gets to 99% at which time the system crashes NOT MY APPLICATION BUT REVELATION the workstation returns to the desktop.

The only workstation that was loged-in was the workstation that was used to perform the index rebuild.

Queries performed on this file before the rebuild process work fine.

upon reentring revelations on the same workstation an attempting a query on the file I get the message "another user currently updating indexes.

I already know which workstation created the lock what I do not know is WHY the system crashes (abnormal termanation of the session) during the rebuild index process.

Sorry, but maybe I did not explain the proble correctly the first time

Thanks again for all the help.

At 07 JAN 2003 11:27AM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:

OK this is conceivably a problem with the rebuild crashing with a VEML error. Can you run it from a CMD box so you can see the error?

The Sprezzatura Group

World Leaders in all things RevSoft

At 07 JAN 2003 12:17PM Don Miller - C3 Inc. wrote:

Relational indexes can cause a Variable Exceeds Maximum Length error if the total key-list (including a @VM delimiter between each one) exceeds 64K OR if the data record containing the relational index (including the length of the imbedded R-I) exceeds 64K. I used to keep a Relational Index in a Customer master record that kept track of Orders, Invoices and Cash Receipts for each customer. The problem arose when my customer started to keep lengthy notes/comments text in the record too which caused the Relational Index rebuild to crash.

Just a thought ..

Don M.

At 07 JAN 2003 12:32PM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:

It can also happen due to an apparent problem with the index rebuild procedure. We wrote our own (good man Aaron ) to get around this.

The Sprezzatura Group

World Leaders in all things RevSoft

At 07 JAN 2003 01:17PM Dave Harmacek wrote:

This is an old problem. 1) Don't do the Rebuild ALL, select out the Btree and Cross References for that table. 2) IMHO the Relationals don't usually get out-of-wack unless indexing was turned off so you won't need to rebuild them.

In that case I wrote a small Rebuild Relational Index routine. Email me if you need one dave@harmacek.com.

At 07 JAN 2003 04:55PM Patrick Caufield wrote:

Thank you all very much for the help.

Don is probably correct about the size the file has about 120k records with about 45 fields. The btrees "get out-of-wack" pre Dave but I have never had any problems with the relation except this one.

Thanks again for the help

Pat

View this thread on the forum...