Re: error 12115 and how to delete a smart blob

On May 16, 7:13 pm, DKano <t...@xxxxxxxxx> wrote:
hi
during dbexport of my db, i have got an error

----
*** Error fetching data row.

9810 - Smart-large-object error.

12115 - Smart Large Objects: The LO header page is a wrong length -
probably corrupted.
---

Using finderr, i found:
-------
An internal error probably occurred and corrupted the LO header.

Delete and recreate the smart large object or restore the sbspace from
an archive.
---------

Then, i found the line of my table where the corrupted blob is (the
first not in the unload file) and try to remove it.

  delete from document where id_document=nnn

fail, same error.

  update document set name_of_sblob_column = null where id_document=nnn

fail, same error.

  drop and recreate table... fail, same error.

So... how to remove the line or the blob, and continue my export ?

thanks
DKano

Hi,

you can try this at your own risk. I did it once on version 10 in
exactly the same situation as you and had no problems, exported and
then re-imported a lot of data without a glitch.
Smart blobs are placed in their own dbspaces. But in problematic table
row(s) you have the pointer to the exact location. You can use dd,
binary vi and/or whatever else to zero out the pointer completely. You
have to be very careful, first find out how wide (in bytes) the rest
of the data fields are, what's the data page structure in Informix,
how wide the pointer itself is (can't remember now at the top of my
head, but It was easy to find it in the docs back then) and then do
the dirty work.
If you have no idea what I'm talking about, THEN DON'T DO THIS,
PLEASE! Talk to IBM Tech Support instead.
And don't mention my advice to them :-)

Regards

Davorin
.

Relevant Pages

  • Re: Header Files and Interfaces Yet Again
    ... I get a foo.h user's header file ... Java's assignments are pointer assignments. ... If for some reason I'm forced to violate ...
    (comp.lang.cpp)
  • Re: Using CryptoAPI to do a DH key exchange with OpenSSL
    ... Endianness aside, what about the blob header, etc.? ... Moreover ENDIANNESS is different, ... CryptoAPI and the other is say OpenSSL, ...
    (microsoft.public.platformsdk.security)
  • Re: Using CryptoAPI to do a DH key exchange with OpenSSL
    ... I was just trying to see what's available in the DH key blob and in the DH ... That's all in the wincrypt.h header files. ... Maybe somebody from MS can give more info on the DH public key. ... But so far, CryptoAPI has gotten ...
    (microsoft.public.platformsdk.security)
  • Re: Separated headers
    ... and now I want to separate headers from code. ... I guess I need one more pointer in the header like this: ... \>XXXX and XXXX> move to and from a specific data area, ...
    (comp.lang.forth)
  • Re: komplexes Problem mit Funktionszeigern
    ... Es sind Header vorhanden, ... Pointer aufgerufen wird. ... So unterschiedlich sind diese Konventionen offensichtlich nicht. ... Schnittstelle besitzen, und für diese Schnittstelle passende Header ...
    (de.comp.lang.c)