Hi all,

I've got some tables (DbIsam v330) from a client that are
reasonably corrupted. I do a repair and after that I'm doing a
optimize to get a fresh copy of the table to work with. When
doing the optimize Dbsys gives me the error message "Dbisam
Engine Error #9729 Duplicate key found in the Index 'Sys
Deleted' of the table '35762'.

I have seen thru Dbsys options to see if the temp directory was
ok and it is, as the message is referenced to a temp table.

Any way to fix this? If necessary I can send the table, it
isn't big (100K unzipped).

Thanks
Andrew

Andrew,

<< Any way to fix this? If necessary I can send the table, it isn't big
(100K unzipped).  >>

Use the RepairTable call with the ForceIndexRebuild parameter set to True.
That should fix the issue.

--
Tim Young
Elevate Software
www.elevatesoft.com

In article <9F7F450F-9D9A-4B71-902E-
C030815B95CE@news.elevatesoft.com>, timyoung@elevatesoft.com
says...
> Andrew,
>
> << Any way to fix this? If necessary I can send the table, it isn't big
> (100K unzipped).  >>
>
> Use the RepairTable call with the ForceIndexRebuild parameter set to True.
> That should fix the issue.

Already did it, but it didn't work. I ended up making a
transfer program and repopulated a new table.

Thanks anyway.
Andrew

Andrew,

<< Already did it, but it didn't work. I ended up making a transfer program
and repopulated a new table. >>

Could you send me the table ?  3.30 should fix any type of index corruption
without the ForceIndexRebuild, but at the very least using ForceIndexRebuild
should take care of it.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> Could you send me the table ?  3.30 should fix any type of index corruption
> without the ForceIndexRebuild, but at the very least using ForceIndexRebuild
> should take care of it.

Ok. Sent to timyoung at elevatesoft dot com.

Andrew

Andrew,

<< Ok. Sent to timyoung at elevatesoft dot com. >>

Are you sure that you're using 3.30 ?  I tried the 3.30 DBSYS repair on the
table, and it detected and repaired the index corruption.

--
Tim Young
Elevate Software
www.elevatesoft.com

> Are you sure that you're using 3.30 ?  I tried the 3.30 DBSYS repair on the
> table, and it detected and repaired the index corruption.

Yeah, pretty sure. Although I was doing the job at my client's
office and made a small transfer program because things weren't
working straight that day. Tried it again at my office with my
own computer today after reading your post and it worked...
Bites me what was happening. Wierd.

Thanks anyway.
Andrew