Hi Guys!

I have a problem with my indexes and I hope someone has had this problem before. I have a intranetware 4.11 server running Arev 3.12. When I rebuild the indexes for my database, the rebuild process stops at about 60 to 70 % finished and refuses to index the remanider for the database. I have found that if I transfer Arev and the data on to my local HD, everything works flawlessly but as soon as I have the system on the server the problem reapeares.

I thought I would be my record locks and set my semaphores to 10000 temporarily to see if this would improve the problem by Arev thum's its noze at me!

Does anybody have suggestions? I am not presently running NLM's (I have them on order and expected to arrive in about a week)

Thanks!

Serge

I have had my share with index problems and here are a few things I would check:

Yes I'm sure the NLM will help. Be sure to set up your computers correctly. Look in the FAQ on this site for good guidelines.

When you rebuild the indexes is everyone out of arev? It could cause problems if they are on. I like to do it at night before I leave and delay the backup unitl it is finished.

Did you verify the file that it hangs on? There could be a bad sector or batch.

Down your server and run vrepair. You never know what may be corrupted on the server.

I hope this helps you a bit.

Robert Myslik

I seem to remeber having this problem a couple of years ago with a client. It seemed to happen more when we selected "rebuild all indexes in a file" option.

In the end we removed all indexes on the file. Verified that the !index file had been deleted and that all of the index records inthe Dictionary had been deleted.

Then, I rebuilt each index ONE at a time and each one built ok then.

hope this helps

ed

This may sound rudementary, but I had that problem when I ran out of server disk space.

View this thread on the forum...