group format error MAP\REV35054.OV (AREV Specific)
At 28 JUN 2003 12:29:25PM Deborah Corrente wrote:
I had this problem the same time last year. I am not able to print out reporting and cannot do verification for some records. The error we consistely get is OS FILE: MAP\REV35054.OV.
I tried to fix the problem by going to the indexing section of LTC and trying to rebuild it. At 73% of the way I get the same fatal error.
This is the begining of the system shutting down again, as it did last year. Any advice on how to correct this problem?
Please help!
At 28 JUN 2003 01:58PM Donald Bakke wrote:
Deborah,
A group format error (aka GFE) is a corruption in a database file. If this file happens to be an index table then you can resolve this by completely rebuilding your indexes. However, if the GFE is in a data table then you must fix the GFE directly. GFEs in dictionary tables should be restored from a backup.
While the process is not difficult, it needs to be approached with caution. Normally we request that our clients allow us to do this in order to avoid possible complications. But if you have made yourself a backup then you can attempt this yourself.
First you need to identify the name of the table associated to REV35054. Press F5 to get to the Command/TCL prompt. Type LISTVOLUME MAP. A popup display will appear that will list your AREV table names to the OS file names (i.e. Foreign Name) in the MAP location.
Once you have identified the table name you need to identify all GFEs in this table. At the Command prompt type VERIFYLH TableName. This will do an analysis of your table and display a report of all GFEs. Note what these group numbers are.
From TCL type DUMPLH TableName. This will put you into a screen with a black background and white text. Be careful what you do here, as changes will be irrevocable. To repair each GFE follow these steps:
1. Enter the group number and then press Ctrl-G. This will take you to the group you specified. At the bottom you should see Group Format Error in reverse type.
2. Press Ctrl-F. In the prompt that displays enter the group number you are trying to repair.
3. The Group Format Error message should disappear from the bottom.
4. Repeat steps 1 through 3 for each group you need to repair.
5. Press ESC when done to return to the TCL prompt.
After all of this is done your table should be free of GFEs. However, you might also have lost data in the process. You can check the DUMP_FIX_TEMP and DUMP_FIX_GARBAGE tables to see what has been recovered. From there you can decide to copy those back into the source table or restore manually.
dbakke@srpcs.com
