Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Informix > error 12115 and...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 14061 of 15119
Post > Topic >>

error 12115 and how to delete a smart blob

by DKano <tg96@[EMAIL PROTECTED] > May 16, 2008 at 08:13 PM

hi
during dbex****t 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 do***ent where id_do***ent=nnn

fail, same error.

  update do***ent set name_of_sblob_column = null where id_do***ent=nnn

fail, same error.

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

So... how to remove the line or the blob, and continue my ex****t ?

thanks
DKano
 




 3 Posts in Topic:
error 12115 and how to delete a smart blob
DKano <tg96@[EMAIL PRO  2008-05-16 20:13:28 
Re: error 12115 and how to delete a smart blob
Davorin Kremenjas <dav  2008-05-19 05:22:24 
Re: error 12115 and how to delete a smart blob
DKano <tg96@[EMAIL PRO  2008-05-20 17:30:55 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:52:28 CST 2008.