Oninit
Talk to an expert →

Informix Error -29000: Application server error (server_error_number).

Cause and resolution

Application server error (server_error_number).

A generic application-server error occurred. Examine the original foreign SQLCODE. You can find it in either SQLERRD[1] or as part of SQLERRM. Look up the explanation for this SQLCODE in the documentation for the foreign server product. Apply the tokens, if any, that are returned in the SQLERRM field to the explanation.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-29000 fires as a generic passthrough for an error the foreign (remote) application server reported — per the official guidance, server_error_number is the original foreign SQLCODE.

  1. A foreign application-server error, reported via its own SQLCODE, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Find the original foreign SQLCODE in SQLERRD[1] or SQLERRM, per the official guidance.
  2. Look up that SQLCODE's explanation in the foreign server product's own documentation, per the official guidance, applying any tokens returned in SQLERRM.
Examples
N/A

No specific triggering statement is documented beyond a foreign SQLCODE passthrough.

Diagnostic Checks
  1. Extract the foreign SQLCODE from SQLERRD[1]/SQLERRM, and consult the foreign server product's documentation for it.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -29000 in this set yet.

A generic foreign application-server error was returned — look up its SQLCODE (from SQLERRD[1]/SQLERRM) in the target DBMS's own documentation.