ISAM error number 117. ISAM error: bad custom collating sequence. 
Author Message
 ISAM error number 117. ISAM error: bad custom collating sequence.

Hi all!

I've been working with 4GL RDS 4.10 as a networked client for
Online 7.10 for a couple of years with no problems but some
minor bugs in the DB engine.

As the databses grow, Online 7.10 is giving me more trouble so I
downloaded Online 7.22 (it's the latest available for SCO OS 5)
and started to experiment.

Unfortunatly, I started to get random error messages when the
4GL programs (or isql, by the way) try to connect to the new
server. The message is:

    Program stopped at "program.4gl", line number 0.
    SQL statement error number -908.
    Attempt to connect to remote system failed.
    ISAM error number 117.
    ISAM error: bad custom collating sequence."

This error appears half the times I run a program. The other
half times it works OK.

Finderr says I should contact Informix but they probably will
tell me to upgrade 4GL, witch I can't do because our clients
would have to do it too (we have some clients happily running
SE 4.10 and don't wish to upgrade).

Can anyone share some experience with this?

TIA,

Fernando

--
Fernando Fernandez
http://www.***.com/



Wed, 18 Jun 1902 08:00:00 GMT
 ISAM error number 117. ISAM error: bad custom collating sequence.

Quote:

> [...]
> Unfortunately, I started to get random error messages when the
> 4GL programs (or isql, by the way) try to connect to the new
> server. The message is:

>     Program stopped at "program.4gl", line number 0.
>     SQL statement error number -908.
>     Attempt to connect to remote system failed.
>     ISAM error number 117.
>     ISAM error: bad custom collating sequence."

Try looking up 117 in /usr/include/sys/errno.h (or /usr/include/errno.h).
There's a chance that it will be a meaningful network-related error.

If it isn't that, then the problem is GLS-related (which a 7.1 to 7.2
engine change makes more likely).  Somehow, something isn't picking up the
GLS locale stuff correctly.

Yours,

Guardian of DBD::Informix -- see http://www.perl.com/CPAN



Wed, 18 Jun 1902 08:00:00 GMT
 ISAM error number 117. ISAM error: bad custom collating sequence.

Quote:


> > [...]
> > Unfortunately, I started to get random error messages when the
> > 4GL programs (or isql, by the way) try to connect to the new
> > server. The message is:

> >     Program stopped at "program.4gl", line number 0.
> >     SQL statement error number -908.
> >     Attempt to connect to remote system failed.
> >     ISAM error number 117.
> >     ISAM error: bad custom collating sequence."

> Try looking up 117 in /usr/include/sys/errno.h (or /usr/include/errno.h).
> There's a chance that it will be a meaningful network-related error.

It's probably this one: #define EUCLEAN 117 /* Structure needs cleaning */
I should have added that I'm running this in Linux 2.0.27+iBCS...

I've been strugling for months against the will to upgrade the kernel
and iBCS but it seems that the time has come...

Thanks for the advice!

Fernando



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Error -105 ISAM error : bad isam file format

2. Help! 7.14 on HP 10.10 / 7203 ISAM 117

3. ISAM: Reserved error 1070 (ISAM)

4. ISAM: 107: ISAM error: record is locked when Installing DBD::Informix

5. 111 isam & 100 isam errors

6. 171 ISAM error: Isam file format change detected (Informix SE 7.23 / 7.24

7. ERROR Number 3170 ISAM non installable,Working examples!!!!!!!!!

8. Couldn't find installable ISAM.error number 3170

9. DOS Informix - ISAM error number -24 (fwd)

10. DOS Informix - ISAM error number -24

11. Error 117 when executing a UDF on a remote server

12. Error 117: maximum prefixes for table name


 
Powered by phpBB® Forum Software