At 06:48 PM 02-10-01 +1000, you wrote:

>Hi People,
>
>One of my databases has just experienced an error that I have not seen
>before...
>
>335544382 "Blob Not Found"
>
>Problem happened with Firebird 0.9.4 on NT4 Server SP6a
>
>Presumably this is due to the blob-id not being valid, or not pointing
>to a valid blob. There are no transactions in limbo and no other
>apparent problems with the database.
>
>
>Just wondering if anyone has experience with this problem? Is there
>anyway to rectify the problem without deleting the record? I tried a
>direct UPDATE on the appropriate field but it failed with "Blob Not
>Found".
>
>Any guesses as to how this may have happened? There are several
>hundred other records in the table which all seem fine.

Geoff,
At a guess, you seem to be bumping into that IB6 bug (ib 5.6 too, if I recall correctly) that it loses the original BlobID if you pass the blob into a stored proc and update it inside the procedure. Could this be the case?

It's fixed in FB 1, incidentally - thanks to the handiwork of our dear Claudio, if I'm not mistaken. Borland's "fix" for the problem was to mention in the documentation that blobs can't be passed as arguments to a SP. In fact they can, but with this interesting effect.

cheers,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________