Informix Error -9791: User-defined routine execution failed.
Cause and resolution
User-defined routine execution failed.
This error occurs under the following circumstances:
1. A language problem occurred or an internal server error exists. In this case, the following log message is entered in the log:
ERROR: Routine execution failed -- procname = routine_name procid = process_ID_number
2. The executing routine has caused one of the following exceptions:
mem -- memory fault
ill -- illegal instruction
fpt -- floating point or divide by zero
sys -- system call problem
"xxx" -- SAPI layer exception explanation
The following error message appears in the log:
ERROR: Routine execution trap -- procname = procedure_name procid = process_ID_number reason: error_string
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-9791 fires when a UDR fails during execution — per the official guidance.
- A language problem or internal server error, per the official guidance — logged as
ERROR: Routine execution failed -- procname = routine_name procid = process_ID_number. - The executing routine raising an exception, per the official guidance — for
example, a memory fault (
mem), among other documented exception types.
Solutions / Resolution
- Check
online.logfor the accompanying routine name, process ID, and exception type, and review the routine's implementation for the reported fault.
Examples
N/A
No specific triggering statement is documented; the routine and exception type vary.
Diagnostic Checks
- Check
online.logfor the "Routine execution failed" message, noting the routine name and exception type, and review that routine's implementation.
Related Errors / Related Topics
- -9790 — "Language Manager initialization failed." A related Language Manager error, on the Language Manager's own initialization rather than a specific routine's execution.
A UDR failed during execution due to a language/internal error or a runtime exception —
check online.log for the routine name and exception type.