Informix Error -23195: Reset locale failed. Connection refused.

Cause and resolution

Reset locale failed. Connection refused.

The database server failed to change the database processing locale to en_US.8859-1. The server refused the connection. Not enough memory is available in the server for the new locale table. Reexecute the program after you free some memory.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-23195 fires when the database server can't change the database processing locale to en_US.8859-1 and refuses the connection — per the official guidance, insufficient server memory is available for the new locale table.

Insufficient server memory for the new locale table, per the official guidance — the direct, only cause.

Solutions / Resolution

Free some memory and re-execute the program, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond memory exhaustion during locale reset.

Diagnostic Checks

Check server memory availability, and free memory before re-executing.

Related Errors / Related Topics

-23194 — "Code-set conversion restore failed." A related memory-driven locale error, on restoring the code-set conversion table rather than resetting the processing locale.

Resetting the database processing locale to en_US.8859-1 failed due to insufficient server memory — free memory and re-execute.