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