Missing index records (Arev 2) (AREV Specific)
At 01 DEC 1998 11:38:13AM Pamela Faulkner wrote:
W602 The Index record "IT_Shelf**" is missing. The indexed field "IT_Shelf" in the file "ITEM.TABLE" should be rebuilt.
Press any key to continue.
We have rebuilt the indexes several times (the error message isn't always for the same index) and we are still getting error messages.
We even did a complete rebuild of the whole system. This problem has been occurring for some time but seems to be escalating.
At 02 DEC 1998 06:27AM Steve Smith wrote:
There may be a couple of causes. Check
(a) for the presence of null records in your files. At TCL, you can
COPY AREVFILE "" TO:(DOS JUNK (OD
where AREVFILE is the name of a file in your application. Shift-F4 at TCL lets you select each file of interest.
(b) check for delimiters (eg. @FM & @VM) in your record keys
To do this create a DICT.VOC symbolic KEYDELIMS with the following formula
ANS=0
FOR X=247 TO 255
IF INDEX(@ID,CHAR(X),1) THEN
ANS=1END
NEXT X
RETURN ANS
then from TCL, for each file of interest
SELECT AREVFILE WITH KEYDELIMS 0
© Faulty MFS code can upset SI.MFS - the indexing program.
From TCL (in AREV 2.x)
EDIT FILES *
and Alt-F through the list to check the MFS sequences on suspect files.
Good luck,
Steve
At 03 DEC 1998 10:11AM Peter Kassinski wrote:
Hi Pamela,
When I worked with Arev 2, I had many problems with indexes ( especially with networks ) .
But after upgrade Arev 2 to Arev 3.12 all indexes problems disapeared.
My advice to you - "Upgrade".
Best regards,
At 14 DEC 1998 09:05AM [email protected] - [url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url] wrote:
Don't know which version you are using, but you should go to either 2.03 if you are on the 2.0 series or 2.11 or 2.12 if you are on the 2.1 series.
