Informix - Problem description
Problem IT30427 | Status: Closed |
SPL CALLING A DELETE ISSUING A TRIGGER CALLING ANOTHER SP RETURNS ERROR 5849 | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
From within a stored procedure, when executing a delete on a table and on this table is defined a delete trigger calling an SP with references, the execution of the SP returns after the second call the error -5849 with the stack: (oninit) afstack (oninit) afhandler (oninit) affail_interface (oninit) check_traperror (oninit) sqerr1 (oninit) d_conblock (oninit) d_qplan (oninit) qd_getqplan (oninit) ip_evalsql (oninit) runproc (oninit) udrlm_spl_execute (oninit) udrlm_exec_routine (oninit) udr_execute (oninit) exroutine (oninit) execproc (oninit) aud_execproc (oninit) excommand (oninit) sq_execute (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 14.10.xC3 * **************************************************************** * PROBLEM DESCRIPTION: * * SPL CALLING A DELETE ISSUING A TRIGGER CALLING ANOTHER SP * * RETURNS ERROR 5849 * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC3+. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 14.10.xC3 * **************************************************************** * PROBLEM DESCRIPTION: * * SPL CALLING A DELETE ISSUING A TRIGGER CALLING ANOTHER SP * * RETURNS ERROR 5849 * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC3+. * **************************************************************** | |
Comment | |
Problem fixed in Informix Server 14.10.xC3+. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.09.2019 02.12.2019 02.12.2019 |
Problem solved at the following versions (IBM BugInfos) | |
14.10.xC3 | |
Problem solved according to the fixlist(s) of the following version(s) |