English

Error: Informix -9793: User Defined Routine (x) module load failed

Error Message

This error occurs when attempting to insert or modify features in a layer. For example:

shp2sde -o create -f base_pts -l map_points,shape -u sde -p xxx -e p -g 1000 -x 1831000,861000,100 -a all -r rejects -c 1000

Produces this:

ESRI SDE Shape to Layer Loading Utility Tue Jun 6 16:39:07 2000
------------------------------------------------------------------------
SDE Code (-51)= Underlying DBMS error
Extended DBMS error code: -9793
[Informix][Odbc Informix Driver][Informix]User Defined Routine (assign)
module load failed.
S1000
Unable to setup attribute table for insert.
Delete layer "map_points" ...

Cause

Informix Spatial DataBlade relies in part on user defined routines (UDFs) to implement geographic data types. When needed, some of those routines are loaded from shared library files. This error occurs when Informix cannot find the shared library files upon start up.

Solution or Workaround

  • Make sure the UNIX path environment variable for your platform is correctly set:

    HP-UX: SHLIB_PATH
    IBM-AIX: LIBPATH
    All other UNIX: LD_LIBRARY_PATH

  • Make sure the following paths are included as part of the appropriate loadable library path environment variable for your platform:

    $INFORMIXDIR/lib
    $INFORMIXDIR/lib/esql
    $INFORMIXDIR/lib/cli
    $SDEHOME/lib
    /usr/lib
    /lib

    Some DataBlade's library files are copied to /usr/lib at installation time. This path is often overlooked, and that can cause this error.