For the backup I am using Copy_table Subroutine.

There are 3 tables, 2 tables are copied and 1 copied table is always corrupted - Group Format Error. This table .ov file size is big.

We have had this problem for a long time. We manually copied rev files for those tables which was corrupted.

What do I have to do?

There are two options. First, repair the GFE (Group Format Error). Please see the help file index topic "Procedure: To Verify Linear Hash Tables". Depending on the error, this may fix the problem and allow copy_table to succeed.

The second option is to write a custom recovery routine. Start by performing a latent select on the table and then a run a ReadNext/Write loop to put the accessible records into a new table. Note (or just ignore) the record keys that can't be accessed. This would allow you to skip over any corrupt records. Once you have all the readable records in a new table you can rename/replace the old table with the new table.

Thanks Jared,

Over 100 clients has to do this without our help. My question is why this happen and how I can copy the files without GFE. I think some of our files have problems.

If .OV file size is big, is that a problem to use copy_table subroutine? What do I have to look at?

Have you verified the original table doesn't have GFE?

The large .OV could be a problem depending on the Network Driver used. What OpenInsight version and client driver (according to netdrv.exe) does the system use?

If you fix the original table, then any copies you make using copy_table or copying the .LK/.OV files should be clean too.

We'd guess copying from a UD3+ file to a pre UD3 so it's not a GFE it's an unrecognisable header structure.

The Sprezzatura Group

The Sprezzatura Blog

World leaders in all things RevSoft

I checked the original table. It was clean. Driver version is All Networks Driver 2.1. Becouse we have had this problem for 2 years now I am testing with 5 tables. Only 1 table has this problem. But with other testing files it is random. With some testing tables 2 tables had GFE problem after copying.

* This is my program.

Account =IES'

Overwrite =1

Exist =0

Lock =0

Delete =0

Relational=0

Files='

Files=FEE_DEFINITIONS'

Files=FEE_TRANSACTIONS'

Files=FEE_PAYMENTS'

Files=FUNDS_TRANS'

Files=FUNDS_ACCOUNTS'

Location =DATAVOL\..\..\DATA\IES-FEES.' : xYear2

no.files=count(Files, @fm) + (Files '')

for ifil=1 to no.files

 File=Files

 gosub copy.file

next ifile

Copy.File:

Copy_Table(File, Location, Account, File, Lock, Delete, Overwrite, Exist, Status, Relational)

Return

* GFE Information

Group 2 Code 5 Overflow frame header type 1024 is incorrect.

The 2.1 All Networks Driver is past not an actively supported product. My inclination is you may be hitting a frame size limitation. If you can reproduce this with the Universal Driver 3+ there are more support options available.

What is the size of the .LK and .OV file of the table before and after the copy?

Does the file exist already in the target directory? What happens if you delete the target file first?

View this thread on the forum...