Help! What to do with BAD table (AREV Specific)
At 13 MAY 1999 10:36:47AM Mark Zalter wrote:
I've got this message when I verify my CPP table:
_————————-Linear Hash Table Report—————————
¦
¦ Table name DATAVOL Date 13 MAY 1999 10:28
¦ Testing status BAD
¦
¦ Size of .LK file 10,240 Average # of rows/group 10.5
¦ Size of .OV file 4,096 Average row length 73.05
¦ Total # of rows in table 84
¦ Framesize 1024
¦ Modulo 10 Load factor:
¦ Sizelock 0 .LK file .7789
¦ # of free frames 0 .LK & .OV file .5818
¦
¦ Recommendations:
¦ * Group Format Errors found. Use the DUMP utility to fix this table.
¦ * The row count in the table header is not up to date.
¦ Run a SELECT from the command window on this table to update the table hea
¦
¦
¦
¦
At 13 MAY 1999 12:18PM Warren wrote:
You have Group Format Errors (GFEs) in the file.
Run the verify again with the (X) option and page down. This should display a list of the bad groups. Print or write these down.
Make sure no one else is in AREV, and it would hurt to back up the file (you can copy the REVxxxxx.* to some temp directory).
At TCL type
DUMP (or DUMPLH depending on the version) filename
the press ctl-f to enter the fix mode. Enter in the group numbers from your listing above or a range or ALL.
Note: recovered data will be placed in DUMP.FIX.TEMP and/or DUMP.FIX.GARBAGE or SYSTEMP depending on which version of ARev you're using. These get cleared with each iteration of ctl-f so inspect them or copy the items in them to some other file on each iteration. In versions <2.03 the ALL fix option may not rename the DOS temp files it creates back to the appropriate REVxxxxx.* files. If this is the case, rename it manually.
See the documentation on DUMP etc.
At 13 MAY 1999 11:24PM Mark Zalter wrote:
At 13 MAY 1999 11:33PM Mark Zalter wrote:
It seem's that when I use verifylh from the menu (DBadnim\utilities\advanced\verify) it enters the default volume(location) name, in this case datavol. Then, no matter what table name I enter at the table prompt, when I run the verifylh process, I get the same error report, as posted above. Note that it states that the table name is datavol. When I generate a default report it reports the file name as datavol*revmedia. Is my revmedia table corrupted? If so, how do I fix it? Thanks in advance.
At 14 MAY 1999 07:12AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Group[/url] wrote:
Try entering the specific file name and volume at TCL, for example
VERIFYLH I:\REVSOFT\OINSIGHT\DATAVOL FAQS (D F)
amcauley@sprezzatura.com
World Leaders in all things RevSoft
