ISAM Error when deleting

[Francisco Roldan]

Hi everybody,
I got a problem when deleting from a table.

I got the ISAM Error -103 "illegal key descriptor (too many parts or too
long) The ISAM processor has been given an invalid key descriptor. For
C-ISAM programs, review the key descriptor. Each key descriptor has a
maximum
of 8 parts and 120 characters. "

It is a simple delete with one condition on one field (the field is part of
a not-unique index), and the table doesn't have primary keys.

I don't understand the meaning of "key descriptor".

I would appreciate your help.

Thanks in advance

regards


sending to informix-list

[Paul Watson]

Try running an oncheck on the table to check the table is OK

Francisco Roldan wrote:

>
> Hi everybody,
> I got a problem when deleting from a table.
>
> I got the ISAM Error -103 "illegal key descriptor (too many parts or too
> long) The ISAM processor has been given an invalid key descriptor. For
> C-ISAM programs, review the key descriptor. Each key descriptor has a
> maximum
> of 8 parts and 120 characters. "
>
> It is a simple delete with one condition on one field (the field is part of
> a not-unique index), and the table doesn't have primary keys.
>
> I don't understand the meaning of "key descriptor".
>
> I would appreciate your help.
>
> Thanks in advance
>
> regards
>
> sending to informix-list

--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
[url]www.oninit.com[/url] #

[Cyrille Deleruyelle]

I think you got a corruption in the partition page corresponding to
the table you were doing the delete on.
"key descriptor" : Slot 4 of this page describes each index keys for
the table.
More likely, the corruption is there. First run oncheck -cc/-cDI. Even
if it doesn't correct anything, you'll perhaps be able to drop and
recreate the table. If it doesn't work, call the tech support.

Got a sql error too ?


Francisco Roldan <froldan@5b.com.gt> wrote in message news:<bgs5h4$g6s$1@terabinaries.xmission.com>...

> Hi everybody,
> I got a problem when deleting from a table.
>
> I got the ISAM Error -103 "illegal key descriptor (too many parts or too
> long) The ISAM processor has been given an invalid key descriptor. For
> C-ISAM programs, review the key descriptor. Each key descriptor has a
> maximum
> of 8 parts and 120 characters. "
>
> It is a simple delete with one condition on one field (the field is part of
> a not-unique index), and the table doesn't have primary keys.
>
> I don't understand the meaning of "key descriptor".
>
> I would appreciate your help.
>
> Thanks in advance
>
> regards
>
>
> sending to informix-list

[Francisco Roldan]

Just for the message list archive,
I solved my problem by droping the indexes and recreating them.

Thanks to everyone that replied my email.

regards



-----Mensaje original-----
De: [email]cyrille_deleruyelle@yahoo.fr[/email] [mailto:cyrille_deleruyelle@yahoo.fr]
Enviado el: Jueves, 07 de Agosto de 2003 11:17 a.m.
Para: [email]informix-list@iiug.org[/email]
Asunto: Re: ISAM Error when deleting


I think you got a corruption in the partition page corresponding to the
table you were doing the delete on. "key descriptor" : Slot 4 of this page
describes each index keys for the table. More likely, the corruption is
there. First run oncheck -cc/-cDI. Even if it doesn't correct anything,
you'll perhaps be able to drop and recreate the table. If it doesn't work,
call the tech support.

Got a sql error too ?


Francisco Roldan <froldan@5b.com.gt> wrote in message
news:<bgs5h4$g6s$1@terabinaries.xmission.com>...

> Hi everybody,
> I got a problem when deleting from a table.
>
> I got the ISAM Error -103 "illegal key descriptor (too many parts or too
> long) The ISAM processor has been given an invalid key descriptor. For
> C-ISAM programs, review the key descriptor. Each key descriptor has a
> maximum of 8 parts and 120 characters. "
>
> It is a simple delete with one condition on one field (the field is
> part of a not-unique index), and the table doesn't have primary keys.
>
> I don't understand the meaning of "key descriptor".
>
> I would appreciate your help.
>
> Thanks in advance
>
> regards
>
>
> sending to informix-list

sending to informix-list