How do I see which indexes the indexer is working on (AREV Specific)
At 11 JUN 2002 12:17:52PM Kevin C Vanmiddlesworth wrote:
We have AREV running on a NOVELL 5.1 Server. When the indexer is running after about 5 minutes it breaks with the error "F.indexer line 6 B703 Variable exceeds maximum length." I have researched this and according to a FEB '97 discussion, Index corruption is the most likely cause. My issue is how to discern which index is the corrupt one. I would rather not rebuild ALL indexes as it would take days. Any suggestions would be greatly appreciated as I am new to what is apparently a very old system.
At 11 JUN 2002 01:49PM Don Miller - C3 Inc. wrote:
The only way I know how to trace this down is to update 1 index at a time. You probably wouldn't want to rebuild one at a time, which should also spot the problem. This is inherent in large files. If you break to the debugger (the B option) and you type /@ID or /@DICT or /@RECORD you might be able to deduce what it was working on. The problem is that Indexer was compiled without linemarks so a trace is impossible, but sometimes system variables are available.
Don Miller
At 11 JUN 2002 04:52PM Kevin C Vanmiddlesworth wrote:
Thank you Don,
Not trying to beat a comatose horse but something you said that may be a clue. You said these index problems are inherent in large files, and we have some of the largest indexable files of any users out there. That is where we can start to search for the corrupt index. Do you have any more info on how to avoid problems of this nature in the future? Thanks in advance
At 11 JUN 2002 06:19PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Kevin,
There may be a way forward - by hooking some of the system index routines you can see what parameters are passed. To know for sure, we need to know your AREV version. When you Hit F5 and enter the command WHO it displays the version. What are you running?
World Leaders in all things RevSoft
At 11 JUN 2002 07:39PM Jonathan Bird wrote:
Are you using a dedicated indexer? I had a similar problem, so with the dedicated indexer, I re-wrote the programme used to update the indexes to update indexes one file at a time, displaying the file it was working on as it di it. works like a charm. Also I put the list of files to have indexes updated in a record in VOC and I can remove or add to the list at will so as to stp updating indexes on any single file while allowing other to be updates as normal.
J
At 12 JUN 2002 05:57AM Kevin C Vanmiddlesworth wrote:
We are using AREV v3.12 with an eye towards moving up to OI soon.
Thanks again for your help
At 12 JUN 2002 06:03AM Kevin C Vanmiddlesworth wrote:
Thanks for responding to my question. Yes we are using a dedicated indexer. I will speak to my senior programmer about the possibilty of doing something like that. I've been wanting to look at both the sweeper and indexer code to see what they actually do. Your solution sounds like the ticket. It would allow complete control of which indexes get rebuilt and when.