Fatal Error in Table (FS126) Group Format Error Group 151 Dump froze after it said fixing. Need help (AREV Specific)
At 11 SEP 2002 02:34:45PM bill stein wrote:
At 11 SEP 2002 04:35PM Richard Hunt wrote:
Bill,
It has been so long since I had a GFE problem… If I remember correctly, if if if, I believe the "fix" is confused and can not fix the group. Also if I remember correctly, once a fix has started and has not completed the table is probably wasted.
Check out table "SYSKNOWLEDGE" row "R28" and "R29", some good info on linear hashed files and GFE's.
What I would do if the table is wasted is to restore the backup of that table before the "fix" was done (hopefully a copy was made right before the fix). Next, using the dump program, go to group 151 and edit to see if you can repair the GFE (very very tricky work and almost impossible to explain).
The least I would do is to try this…
1) go to the group 151 verify that it is the one with errors.
2) using (ctrl-h) edit the first 16 bytes of the group.
a) bytes 1-1, type, should be "0D".b) bytes 2-5, forward, change to "00 00 00 00".c) bytes 6-9, skip, change to "00 00 00 00".d) bytes 10-13 group modulo, leave as is.e) bytes 14-14 reset to "80".f) byest 15- ... reset all to "00".This will empty that group and hopefully erase the GFE. Unfortunately, you will loose all the data from that one group. You could write down the information before the above steps. The least you can do is to copy down the hilighted items. The are the row IDs. Remember to scroll thru the overflow frames for more row IDs and information.
If you are extremely desperate, you could email me the DOS file (REV00000.LK and REV00000.OV) and I could look at it. Im not guaranteeing anything and I have had experience is salvaging quite a bit of data from tables in the past.
My experience with GFE's when one group is effected is most likely from the "record length" not pointing to the end of the record. A simple edit fixes that. Although sometimes the overflow data gets lost. A definate lesser of two evils (loose a couple rows rather than the whole table).
At 20 NOV 2007 05:50AM Kevin Rudahinduka wrote:
Please can you help me on how I can fix the following error;
Fatal Error Readnexting in table LOAN_TEMP
Group Format Error:
OS File : LOAN\DATA\REV66215.OV
Group # : 00000039
Wrong Overflow frame linked to group
ESC to terminate, Break to debugger? (ESC/B)