Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 7 of 7 total |
Corrupted Table Problem |
Fri, Mar 24 2006 5:06 PM | Permanent Link |
Andrew | 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 |
Mon, Mar 27 2006 3:02 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Mon, Mar 27 2006 9:07 PM | Permanent Link |
Andrew | 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 |
Tue, Mar 28 2006 1:18 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Mar 28 2006 3:24 PM | Permanent Link |
Andrew | 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 |
Wed, Mar 29 2006 4:15 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Mar 30 2006 7:29 AM | Permanent Link |
Andrew | > 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 |
This web page was last updated on Wednesday, April 17, 2024 at 10:35 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |