Smart Blob errors
I'm using the Spatial Datablade with Informix 11.50FC9 and am encountering
smart large object errors in one of my tables. I understand the meaning of the
error below - that there is a row in the table that refers to a smart large
object that is no longer there. (Although I don't understand how this
situation happened). My question is, is there a way to delete this row so that
I can continue working with the table without explictly bypassing the corrupt
rows in my query? Alternatively, is there a way to quickly determine which
rows are corrupt so that I can exclude these in an unload and then reload the
table? I've tried oncheck -cs/S & -cd/D but it doesn't turn up any errors.
In my onconfig file I have defined SBSPACETEMP and SBSPACENAME. Both refer to
blob spaces with logging turned on.
> select * from ... where se_row_id = 275015;
9810: Smart-large-object error.
12097: Smart Large Objects: open: Bad smart-large-object address. Object mighthave
been deleted.
Thanks,...
Mike
Hello.
Have you tried to select rowid from [table] ?
If you could get it´s rowid, you could delete it, easily.
Hope it helps.
Regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Database Administrator - Cleartech Ltda
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: mike@barrodale.com
> Subject: Smart Blob errors [27408]
> Date: Wed, 20 Jun 2012 10:50:51 -0400
>
> I'm using the Spatial Datablade with Informix 11.50FC9 and am encountering
> smart large object errors in one of my tables. I understand the meaning of
the
> error below - that there is a row in the table that refers to a smart large
> object that is no longer there. (Although I don't understand how this
> situation happened). My question is, is there a way to delete this row so
that
> I can continue working with the table without explictly bypassing the corrupt
> rows in my query? Alternatively, is there a way to quickly determine which
> rows are corrupt so that I can exclude these in an unload and then reload the
> table? I've tried oncheck -cs/S & -cd/D but it doesn't turn up any errors.
>
> In my onconfig file I have defined SBSPACETEMP and SBSPACENAME. Both refer to
> blob spaces with logging turned on.
>
> > select * from ... where se_row_id = 275015;>
> 9810: Smart-large-object error.>
> 12097: Smart Large Objects: open: Bad smart-large-object address. Objectmight
> have
> been deleted.
>
> Thanks,...
> Mike
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Thanks, but I'm not sure how you mean to do the delete by rowid - I did the
following:
> select rowid from ... where se_row_id = 275015;
rowid
23759361
1 row(s) retrieved.
> > delete from ... where rowid = 23759361;
240: Could not delete a row.
12097: Smart Large Objects: open: Bad smart-large-object address. Object mighthave
been deleted.
Error in line 1Near character position 59
Yes, that´s exactly what I should try for "orphaned" objects.
But if you can´t delete it using rowid, I think you might need to contact
support team.
Regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Database Administrator - Cleartech Ltda
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: mike@barrodale.com
> Subject: Re: RE: Smart Blob errors [27411]
> Date: Wed, 20 Jun 2012 11:16:46 -0400
>
> Thanks, but I'm not sure how you mean to do the delete by rowid - I did the
> following:
>
> > select rowid from ... where se_row_id = 275015;>
> rowid
>
> 23759361
>
> 1 row(s) retrieved.
>
> > > delete from ... where rowid = 23759361;
>
> 240: Could not delete a row.>
> 12097: Smart Large Objects: open: Bad smart-large-object address. Objectmight
> have
> been deleted.
> Error in line 1> Near character position 59
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>