Thanks , will do that


At 12:33 06/09/2004, you wrote:

>Either upgrade to FB1 or FB1.5,
>or do not copy blobs inside SP and triggers.
>
>The blob that causes the error message is already lost,
>you just have to remove its blob-id from table.
>You can locate it using code like
> SELECT Count(*) FROM Tab
> WHERE BlobField STARTING 'X' AND PK BETWEEN 1 AND 10000;
>When the error occurs, you know the offending row is in the range
>of PKs specified, then just narrow it (e.g. 1 and 5000) and try again, etc.
>When you find the row, either delete it, or assign Null to blob field.
>
>Ivan
>
>
>
>----- Original Message -----
>From: "Johannes Pretorius" <johannes@...>
>To: <firebird-support@yahoogroups.com>
>Sent: Monday, September 06, 2004 12:14 PM
>Subject: Re: [firebird-support] Backup error = Blob not found
>
>
>> Good day
>> =\-=\-\==\-
>> sorry for the delay.
>> We use Interbase 5.6 on Windows 2000 Server
>>
>> Further the database is 1 GB in size
>>
>> Hope this helps
>>
>> Johannes Pretorius
>>
>>
>>
>> At 12:36 03/09/2004, you wrote:
>>
>> >What server do they use ? This error was usually caused by bug
>> >in pre-FB1 versions when copying row with blob inside SP,
>> >but the bug was fixed long time ago (FB1, FB1.5 should be o.k.)
>> >
>> >However, recently I heard about it to apper in FB1.5 too
>> >(do not know exact circumstances)
>> >
>> >The only solution is to locate row with blob which causes the error
>> >and delete it.
>> >
>> >Ivan
>> >
>> >
>> >----- Original Message -----
>> >From: "Johannes Pretorius" <johannes@...>
>> >To: <firebird-support@yahoogroups.com>
>> >Sent: Friday, September 03, 2004 11:14 AM
>> >Subject: [firebird-support] Backup error = Blob not found
>> >
>> >
>> >> Good day
>> >> \=-0==-=-
>> >>
>> >> We have a problem at a client side where the backup keeps on starting the following
>> >> error message
>> >>
>> >> error accessing BLOB column REPORT - continuing
>> >> ERROR: BLOB not found
>> >>
>> >> Can somebody please give some information or hints on this please.
>> >>
>> >> Thanks in Advance
>> >>
>> >> Johannes Pretorius
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.752 / Virus Database: 503 - Release Date: 03/09/2004

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.752 / Virus Database: 503 - Release Date: 03/09/2004


[Non-text portions of this message have been removed]