Repairing corruption in a memo field/file

[Stanley - stanlyn.com]

Hey Ken

OK, well, after verifying, blobfix hosed my data.  It does not error now, nor does it have anything, and it is bloated...

Just an update...

Thanks,
Stanley




-----Original Message-----
From: Ken Cole [mailto:ken.m.cole at gmail.com] 
Sent: Thursday, March 26, 2015 1:42 AM
To: Stanley - stanlyn.com
Subject: Re: Repairing corruption in a memo field/file

Stanley,

Have you tried any  of the normal command line options in case they have been added since that email?

Did you try -? to try and get a help output?

Lastly, having never used blobs/memos, for this very reason, you could try the following:

1. Copy the entire data folder to a backup 2. copy the appropriate qualified files, data, key, blob and any others to be the non-qualified equivalents 3. run blob fix 4. copy them back to their qualified equivalent files

It may be pertinent to remove all indexes prior to this and rebuild them afterward.

Ken

On Thu, Mar 26, 2015 at 4:05 PM, Stanley - stanlyn.com <stanley at stanlyn.com> wrote:
> Hi Ken,
>
> The PFQUAL export does not work.  I dug up an old email that says it wouldn't.  Take a look...
>
> On Tue, Feb 03, 2009 at 07:56:52PM -0500, Dennis DIller wrote:
>> I have a file and I need to fix the blob in it on field 26 with a 
>> edit of 16,memo some how it got corrupt. Its in a directory of 
>> /appl/eusa1/filepro/deest it does have a quality blobeusa what is the 
>> procedure to fix this I went to a blobfix utility that does not work
>
> the stupidly, non-intuitive way to run blobfix on a qualified file is:
> blobfix - -m qualifier_name
> select the filepro filename from the list of filepro files that comes up.
>
> blobfix is very unrefined - it does not take any other command line arguments that i'm aware of - not even filepro-file-name - the only argument that seems to work is -m -md and -mq do not work, PFQUAL and PFNAME do not work either.
>
> i don't think blobfix was intended for release originally so not much was put into it.  maybe if you complain or bug-report this to fp-tech it would get a higher priority to be made to work like all other fp programs.
>
> --
> -Joe Chasan-                           Magnatech Business Systems, Inc.
> joe - at - magnatechonline -dot- com   Hicksville, NY - USA
> http://www.MagnatechOnline.com         Tel.(516) 931-4444/Fax.(516) 931-1264
>
> Thanks, Stanley
>
>
>
>
> -----Original Message-----
> From: Ken Cole [mailto:ken.m.cole at gmail.com]
> Sent: Thursday, March 26, 2015 12:48 AM
> To: Stanley - stanlyn.com
> Subject: Re: Repairing corruption in a memo field/file
>
> try setting PFQUAL first and see if it runs with that set or most runtimes use -m from memory to set the qualifier.
>
> On Thu, Mar 26, 2015 at 3:44 PM, Stanley - stanlyn.com <stanley at stanlyn.com> wrote:
>> Thanks Ken,
>>
>> OK, I found blobfix in the /appl/fp folder.  When ran, it only asks for the table file name and NO qualifiers.  I ran it from the command line.  I need to run it on a qualifier.  Any suggestions?
>>
>> Thanks,
>> Stanley
>>
>>
>>
>>
>> -----Original Message-----
>> From: Ken Cole [mailto:ken.m.cole at gmail.com]
>> Sent: Thursday, March 26, 2015 12:25 AM
>> To: Stanley - stanlyn.com
>> Subject: Re: Repairing corruption in a memo field/file
>>
>> Stanley,
>>
>> Look in the fp folder and sub folders as their used to be a fixmemo or some such application.
>>
>> Might be worth searching the mail archives as this has been discussed previously.
>>
>> Regards
>>
>> Ken
>>
>> On Thu, Mar 26, 2015 at 3:19 PM, Stanley - stanlyn.com <stanley at stanlyn.com> wrote:
>>> Hi,
>>>
>>>
>>>
>>> SCO Unix sys5 with filepro dreport 5.0.14d4.
>>>
>>>
>>>
>>> Any fix for memo field/file corruption.  I have identified the 
>>> record that segvios.  Issuing 212="";write does not help where 212 is the memo field.
>>>
>>>
>>>
>>> Thanks,
>>>
>>> Stanley
>>>
>>>
>>>
>>> -------------- next part -------------- An HTML attachment was 
>>> scrubbed...
>>> URL:
>>> <http://mailman.celestial.com/pipermail/filepro-list/attachments/201
>>> 5
>>> 0
>>> 326/5185a15c/attachment.html>
>>> _______________________________________________
>>> Filepro-list mailing list
>>> Filepro-list at lists.celestial.com
>>> Subscribe/Unsubscribe/Subscription Changes 
>>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes 
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes 
> http://mailman.celestial.com/mailman/listinfo/filepro-list