I am rebuilding indexes for a heavily relationally indexed table. When I select the 'rebuild all indexes for file' option, after a bit of a delay, the program falls over with the following message:

BUILDINDEX_SUB Line 1 Variable exceeds maximum length.

This appears to occur while building the temporary sort files.

HOWEVER, if I delete the indexes and add them one by one (updating as I go) the indexing will work but this requires me to be on the spot for many hours to kick off each index when the previous one has completed.

I have been testing this on a development system that has 20,000 records. I need to re-index the live system (I have changed index values from YYMM to YYYYMM) and this has 200,000 records and I need to know that it is going to run sucessfully overnight otherwise I will have a bunch of very irate users to answer to.

Thanks in advance (and free Y2K software if you need it!) to anyone who can help.

Jocelyn

[email protected]

I think I've heard of this bug before. If it were me, I'd bypass the MFS and do the reindexing myself, easy enough for relational indexes. All you really need to do in order to accomplish this is to acquire handles for the relevant files sans si.mfs. Ways to do this are described in one of the technical bulletins as well as Revmedia and in the archives to this board I believe.

I can send you a copy of my INDEX_REBUILDER utility. I updated it to run with ARev 3.1x and fixed some problems earlier versions had with related indexes.

Just give the okay to e-mail it to you (I hesitate to send binary attachments without prior approval).

Aaron should have the latest version in his archive of the CompuServe Rev libraries also.

View this thread on the forum...