Indexing Problem (AREV Specific)
At 26 JUL 1998 05:07:28PM [email protected] wrote:
Having a problem with initializing indexes. I created a
couple of btree indexes and one cross ref index. When I
go to perform a lookup, it says the indexes have not
been created. I have tried removing and re-creating, didnt work
I tried rebuilding, that doesnt work. Ran Lh-verify, no errors,
although I dont know if that has anything to do with
indexing. Any suggestions?????
At 26 JUL 1998 06:48PM Victor Engel wrote:
Pardon me if I'm stating the obvious, but are you reindexing and doing the lookups on the same Arev session? If not, you will have to reattach the file after indexing.
At 26 JUL 1998 07:29PM K Gilfilen wrote:
Also, trying not to state the obvious yet not take anything for granted, did you take the step of building after you defined them? Since some environments build indexes automatically (often very quickly) after they are defined, I don't assume that people know to explicitly build the indexes after defining them.
Is it possible that the index build quit without displaying an error message? Some of the pre-3.12 versions lacked error messages.
At 27 JUL 1998 10:57AM Dan Shane wrote:
I am using AREV 3.12. I defined the indexes, initialized them
and then tried to do lookups in that session and in
subsequent sessions. Same problem. Tried rebuilding the
indexes previously created, same problem.
At 27 JUL 1998 06:48PM Mike Ruane, WinWin Solutions Inc. wrote:
Dan-
I'm not sure about the initial build problem, but when you remove the indexes, are they really removed?
Make sure the !file is deleted, _xref dictionary items have been deleted, the flag fields in the dictionaries have been removed, and especially that SI.MFS has been removed from the file. Sometimes you had to do this manually.
After it is all removed, add just a single btree. When the system prompts you to build the index, respond yes.
When it is done, list the !file. You should hve a lot moe than 5 records in there. If you do, try a select statement against the file. The indexes should be working.
Hope it helps-
Mike
At 29 JUL 1998 06:30PM Aaron Kaplan wrote:
Exactly how are you creating the indexes?
Are there any messages on the screen or status line?
Are you checking on the same workstation you built the index on?
Is this a network?
If so, do you have the same errors when you run local?
