Technical article 104869

Running op udir returns the error "iserror no=117" on SCO OpenServer 5

OpenServer 5.0.0

Written · Last revised

Problem

I'm running op udir on SCO OpenServer Release 5, and this error message occurs:

iserror no=117

This error occurs after upgrading from earlier SCO releases and prevents access to the data.

Cause

This error will occur if op udir is run with the LANG environment variable set to a value different than that when the data files were created.

This is an ISAM error indicating a bad collating sequence. If your database is built using a specific LANG variable (and thus a specific collating sequence), you will only be able to read it while that specific LANG variable is set.

Solution

Ensure that LANG is set to its original "pre-upgrade" value. Do this by moving the appropriate entry in the file /etc/default/lang to the top of this file.

Here is a sample of the file:

LANG=C_C.C
LANG=english_us.ascii
LANG=en_US.ascii
LANG=german_germany.8859
LANG=french_france.8859
LANG=english_uk.8859
LANG=english_us.8859

If the original "LANG" was set to "en_US.ascii", the modified file would look like this:

LANG=en_US.ascii
LANG=C_C.C
LANG=english_us.ascii
LANG=german_germany.8859
LANG=french_france.8859
LANG=english_uk.8859
LANG=english_us.8859

See also

Another article in this database:

TA100620, "ISAM application returns error 117 - EBADCOLL, Bad Custom Collating.".

From the Xinuos technical article database, record 104869. Reproduced with permission. The original is at www.sco.com/ta/104869, which is reachable but blocked from search engines. Xinuos marks this article against a retired product line. That refers to the product’s lifecycle, not to whether the advice still works — plenty of it still applies to running systems.

Next step

Need this fixed rather than explained?

Tell us the release, what the system runs and what it is doing. We will reply by email with what we would do next.

  • You deal with the people who do the work
  • No obligation, and no upgrade required before we will help
  • We tell you plainly if something is not worth doing

Send an enquiry

We reply by email. If a server is down, say so in the first line. You can also write to help@scoexpert.com.