Oninit
Talk to an expert →

Informix Error -29032

-29032 Application Server CCSIDs could not be determined.

The Gateway is required to perform outbound character code-set conversion for this client operating-system locale, but the Gateway could not determine the CCSIDs of the application server.

Notify the administrator of the Gateway. The administrator must set the GWASCCSID environment variable to match the single-byte CCSID of the application server. If network mode is being used, the Gateway administrator must stop and restart the Gateway daemon after setting the GWASCCSID environment variable. The Gateway administrator must then connect to the application server using either a CONNECT statement or a DATABASE statement. This connection captures all the CCSIDs in the cache file $INFORMIXDIR/gw/sysinfo/prnccsid.dat.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-29032 fires when the Gateway needs to perform outbound character code-set conversion for the client's OS locale but can't determine the application server's CCSIDs — per the official guidance.

  1. The application server's CCSIDs not yet captured in the Gateway's cache, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Have the Gateway administrator set GWASCCSID to match the application server's single-byte CCSID, per the official guidance.
  2. In network mode, stop and restart the Gateway daemon after setting GWASCCSID, per the official guidance.
  3. Connect to the application server via CONNECT/DATABASE to capture its CCSIDs into $INFORMIXDIR/gw/sysinfo/prnccsid.dat, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond undetermined application-server CCSIDs.

Diagnostic Checks
  1. Check whether GWASCCSID is set, and whether prnccsid.dat has been populated via a prior CONNECT/DATABASE.
Related Errors / Related Topics
  • -29036 — "Character codeset conversion file not found from, to, filename: from_cs_num, to_cs_num, filename." A related code-set conversion error, on a missing conversion table file.

The Gateway couldn't determine the application server's CCSIDs — the administrator must set GWASCCSID and capture CCSIDs via CONNECT/DATABASE.