IT09963: LET STATEMENT CONCATING 2 GLOBAL SPL VARIABLES CAUSES PROCEDURE TO GENERATE ASSERTION FAILURE AND 9791 ERROR

APAR status

• Closed as program error.

Error description

• 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;
  

Local fix

Problem summary

• ****************************************************************
  * 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 conclusion

• Problem Fixed In IBM Informix Server 12.10.xC6
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels

• RA10 PSN

     UP

• RA10 PSY

     UP

• RB10 PSN

     UP

• RB10 PSY

     UP

• RC10 PSN

     UP

• RC10 PSY

     UP