INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

Assertion messages in MSGPATH: 
 
14:46:22  IBM Informix Dynamic Server Version 12.10.FC4W1 
14:46:22   Who: Session(28, user@machine, 6292360, 
70000002048ce88) 
        Thread(55, sqlexec, 70000002044c188, 1) 
        File: mtex.c Line: 420 
14:46:22   Action: Please notify IBM Informix Techical Support. 
14:46:22  stack trace for pid 5178194 written to 
/dumpdir/af.41f7e0e 
14:46:22   See Also: /dumpdir/af.41f7e0e, shmem.41f7e0e.0 
14:46:27  Exception Caught. Type: MT_EX_OS, Context: mem 
14:46:27  (-9791): ERROR: Routine execution trap -- 
procname=<testspl> procid=533 
    reason: mem 
 
Stack trace for failing thread: 
 
afstack 
afhandler 
affail_interface 
mt_ex_throw_sig@AF11_4 
afsig_handler 
rvaldataChar 
chkralloc 
valstore_deepcopy 
IPRA.$ip_evalexpr 
runproc 
udrlm_spl_execute 
udrlm_exec_routine 
udr_execute 
udr_spl_curnext 
ip_curnext 
ip_fetch 
getrow 
fetchrow 
exfetch 
sql_nfetch 
sq_nfetch 
sqmain 
listen_verify 
spawn_thread 
th_init_initgls 
startup 
 
 
onstat -g ses output 
 
Sess       SQL            Current            Iso Lock       SQL 
ISAM F.E. 
Id         Stmt type      Database           Lvl Mode       ERR 
ERR  Vers  Explain 
32                        t1                 CR  Not Wait   0 
0    9.24  Off 
 
Stored procedure stack : 
 
   context            proc-counter       opcode name 
 
---------------------------------------------------------------- 
-- 
   0x07000000219dd058 0x70000002192f780+0x0010 EXPR       t1:jr1 
 
Current SQL statement (1172) in procedure t1:jr1 
   proc-counter 0x70000002192f780 opcode EXPR 
 
(|| p_arti.sum_fam[4], p_arti.sum_fam[8]) 
 
 
The let statement in the SPL code that generates the failure: 
 
create procedure testspl() 
returning char(2); 
 
define global p_arti row_arti default null; 
 
define v_sector_seccion char(2); 
 
let v_sector_seccion = (NULL::CHAR); 
LET v_sector_seccion  = p_arti.sum_fam[4]||p_arti.sum_fam[8]; 
 
return v_sector_seccion; 
end procedure;

**************************************************************** 
* USERS AFFECTED:                                              * 
* Those using single subscript in expressions inside SPLs      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC6                      * 
****************************************************************

Problem Fixed In IBM Informix Server 12.10.xC6

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

09.07.2015
30.12.2015
30.12.2015

12.10.xC6