Ivan,

are you sure, that copying blobs inside Triggers is not safe?

I always thought this bug affects only Stored Procedures.


Thank you

Robert



Ivan Prenosil schrieb:

>
> 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
>
>
>
>