Changing file corrupted file

[Richard Kreiss]

I would suggest using fp opt to make a copy of the file with a different name. 

Then check this file for ant bad records. If none is found, delete the key and data files and change the field. Then post records to the new file. 

The other thing you should is your hard drive. It is possible that it may have bad sectors. The other piece to check is memory. One or both being bad will cause issues. 

Also, delete any indexes before posting as building the indexes will slow your posting. 

Is the field you are expanding used in any of the indexes?  If so, delete them.  You would have to rebuild them anyway with the new field size. 

Also, try reducing the size of the file for test purposes. Cope the key file to keybak and the delete all but 1,000 records. Then try expanding the field. If this is corrupted , see above. 

Richard
Sent from my iPhone

> On Dec 26, 2018, at 2:41 PM, Rod Caddy via Filepro-list <filepro-list at lists.celestial.com> wrote:
> 
> Is it possible that someone has a record in the file open or it was left open somehow? 
> 
> ⁣
> Rod Caddy
> 817-793-4148 Cell
> 1-877-657-1480
> 
> Sent from BlueMail ​
> 
>> On Dec 26, 2018, 12:50 PM, at 12:50 PM, scooter6--- via Filepro-list <filepro-list at lists.celestial.com> wrote:
>> I have a file that has 16 fields in it so it only has key and no data
>> file
>> 
>> I have a field I changed from 3,# to 4.#
>> It has about 15 million records in it
>> 
>> After it finished it had corrupted the file - there were a lot of
>> characters like you'd see in a drawn screen corner and the fields were
>> all
>> garbled...
>> 
>> So I restored the file from backup and ran it again and it did the same
>> thing?
>> 
>> I've never seen this happen when changing a filePro file layout
>> 
>> Has anyone encountered this or know what may cause this?
>> 
>> thanks
>> 
>> Scott
>> 
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
>> Virus-free.
>> www.avast.com
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL:
>> <http://mailman.celestial.com/pipermail/filepro-list/attachments/20181226/229d4ee1/attachment.html>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20181226/acff1282/attachment.html>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: 189.png
> Type: image/png
> Size: 4239 bytes
> Desc: not available
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20181226/acff1282/attachment.png>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list