Data corruption
Don Coleman
dcoleman at dgcreact.com
Wed Dec 12 11:29:48 PST 2007
> -----Original Message-----
> From: Kenneth Brody [mailto:kenbrody at bestweb.net]
> Sent: Tuesday, December 11, 2007 1:05 PM
> To: Don Coleman
> Cc: 'Filepro-List at Lists. Celestial. Com'
> Subject: Re: Data corruption
>
> Quoting Don Coleman (Tue, 11 Dec 2007 12:35:51 -0500):
>
> > Client had a hard drive fail over the weekend. I have identified some
> data
> > corruption in an archive file at this point. Most of the corrupted
> records
> > are in small batches of 20-50 records although a few are single
> individual
> > records. I am unable to delete the corrupted records (nothing happens
> on
> > the screen). Is there any way to get rid of these? The hard drive
> failed
> > during the backup and I can piece the data together if I can eliminate
> the
> > corrupted records.
> >
> > Windows 2003 server, fPv5.0.13, WIN2000 & WINXP Pro clients.
>
> Depending on how the records are corrupted, filePro may think that they
> are already deleted. In that case, update the records to create them
> and then delete them again.
>
> --
> KenBrody at BestWeb dot net spamtrap: <g8ymh8uf001 at sneakemail.com>
> http://www.hvcomputer.com
> http://www.fileProPlus.com
Ken (& others):
Updating the record, then saving the record does allow record deletion.
Thank you.
Next question. If I am displaying one of the corrupted records on the
screen, each field appears to contain a straight line similar to the
graphics characters in dscreen & dmoedef. So I'm thinking I can write a
clerk process to update, then save, then delete these records. Next task is
to make sure I correctly identify the corrupted records in the file. To
test (not a complete test) I check each position of an 8 character * edit
field where each position should range from 0-9. Again, the screen displays
a graphic dash. Yet if I run a report with the debug on and I display the
value contained in this field I get 00000211. Why does the debugger display
something different than the screen? This wouldn't be so bad except this
file contains 1.6M records. One at a time may take a while.
Don Coleman
Donald G. Coleman, Consultant
402 Andrew Circle
Indiana, PA 15701
dcoleman at dgcreact.com
(724) 349-6302
More information about the Filepro-list
mailing list