Oninit
Talk to an expert →

Informix Error -26042: Function (explain_sql) failed in %s.

Cause and resolution

Function (explain_sql) failed in %s.

In the explain_sql UDR, the execution failed in the specified function.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-26042 fires when the explain_sql UDR's execution fails in an internal function — per the official guidance, with no further named detail.

  1. Execution failed in the named internal function of explain_sql, per the official guidance — the direct, only cause; the source gives no further detail.
Solutions / Resolution
  1. Contact IBM Informix Technical Support to resolve the problem, per this project's convention for internal-error codes the official text doesn't attribute to a user-actionable cause.
Examples
N/A

No specific triggering statement is documented beyond an internal explain_sql failure.

Diagnostic Checks
  1. Check the server log around the same time, and escalate to IBM Informix Technical Support if the issue persists.
Related Errors / Related Topics
  • -26043 — "Function (explain_sql): The required parameter %s is NULL" A related explain_sql error, on a specific missing-parameter cause rather than a generic internal failure.

The explain_sql UDR failed internally — this is an internal error; escalate if it persists.