Here is the error:

Fatal error readnexting in table Invoice

FS126

Group Format Error

Os File Rev35074.ov

Group 3924 (always different)

Wrong overflow link

I have tried uninstalling indexes. Rebuilding indexes. Dumping the group. All with no results. My only other option is a backup from last week (do not want to do this). Can anyone help out?

This group format error has probably been there for a long time, because Readnext GFE will only error while looking at multiple records. Do you table test, therefore know that last weeks file is ok. I would make a copy of the file then perform FIXLH INVOICES, and see what the record lost outcome would be. Then using your restore from last week to replace the missing records from the fix.

We have spoken before, if you need more assists please email

[email protected]

Robert,

Further to the other gentleman's post. After you do the fix, take a look for the dump.fix.garbage (I think that is the name — might be from a prior release) file (and possibly another related one as well), as these may provide a clue as to records potentially lost. It can be a bit tedious going thru the information and parsing out records and keys, but if it is a choice of that or a restore, parsing the 'garbage' data might be a better option. Either way, it is probably worthwhile hanging on to those files from each fix.

I hope your stretch of 'rough road' smooths out for you soon.

Regards,

Eric Drews

Drews Enterprises

http://www.drews-ent.com

Don't blame you for not wanting to do a restore from last week data if that your most recent data. Sounds like your file is "trashed" with bunches of GFEs. A couple of other options come to mind:

1) Do a select on the file and in most case it will give you the GFE message. Each time you get one it will display the the bad "group". Go to the frame and fix the GFE then start the select over again. As pointed out earlier by Eric, look at the Dump.Fix.Garbage (or whatever that file is called) file for loss records that you may want to repair. Do this before starting your next select because it will overwrite this file. Do the next Select until all GFE are fixed. This is time-consuming, but it may help you.

2) You may still have to do number #1, but you may also try this. Remove all indexes on the file. Then do a RecordCopy of the file to a new file. For example,

Remove Indexes

Make a NewFile

Select FileName (if goes all the way thru you may try this option)

Copy FileName to:(NewFile

Select Dict.FileName

Copy Dict.FileName to:(Dict.NewFile (O

Rename FileName to BadFileName

Rename NewFile to FileName

Put Back on Indexes.

Hope this help and Good Luck.

[email protected] onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

View this thread on the forum...