Hi All

I have a client who has pretty much left their arev system behind. Occasionally I think they use it for enquiries but nothing new has been added for over 12 months. We left the indexing machine going however. And even though the system is hardly used, every month or so, some of it GPFs and some of it does this:

Cannot find the index description row for "Blah"

where blah is a field name.

The way to fix it is to remove the Btree indexing and then put them back but this means a site visit for me and it is a bit of a pain.

The PC that the indexing machine sits on is Dos and Novell and Arev only.

Does anyone have a clue why the system crashes and what I can do about it? Could network problems be the cause?

If the system is only being used for enquiries, how bad would it be if we simply stopped the indexing machine? I am thinking I might try that for a while anyway.

Scott, LMS

Janet,

It sounds like they are not using the NLM to maintain integrity with this system. If the workstation has a faulty NIC, memory, or cabling (not to mention problems that might exist with the server) then this can be a repeating issue.

If inquiries are the only thing being done then there is no reason to maintain an indexer.

[email protected]

SRP Computer Solutions, Inc.

Hi Don

Whatcha doing up in our (Aussie) daylight hours?

Thanks for that. I might have a look at the systables for the NLM identifier. They should be using the NLM. The PC itself could be on its last legs though. And I will have a look at the network setting for it too. And I wouldn't trust that client's network either. They keep unplugging things without closing other things first.

Scott, LMS

I believe it was still daylight when I posted my response. Either way, I've been known to be up and around at nearly all hours. It's getting harder and harder to keep that up as I get older…

[email protected]

SRP Computer Solutions, Inc.

Hi Don

Hmm If I posted at around 11am my time, it would have been around 12:30am GMT, and about 16:30pm your time yesterday (yesterday relative to my time). So probably still daylight even for winter.

I guess it would have been somewhat later in New York. Maybe that's why I get confused about what time it is in the USA. I just figure if I'm at work, you all should be asleep. I often catch the USA eastern seaboard at hours that are past my bed time.

Scott

Would not be a good timelord.

Hi Don

Well I tried a whole bunch of verify's and nothing seemed to be wrong. I drew a really beautiful picture of the server room because I was stuck in there so long with nothing else to do but wait for the verifys to finish.

This morning, after another set of verify's were interrupted by an autore-boot overnight, I decided to take a punt on which table the messages were about. I guessed right, removed a lot of Btree indexes and one relational, rebuilt the indexes, then put a few of them back, and rebuilt again. Then the indexing machine was happy.

So now we can turn it off, but I have left the client to decide about that.

Is there any way from the original "cannot find …" of telling what the Table is that the complaint is about apart from guessing?

Can you list a table of index columns to find out or something?

Scott, LMS

View this thread on the forum...