IC77511: ASSERT FAILED: EXCEPTION CAUGHT IN COL2EXPR() WHILE INVOKING A TRIGGER THAT EXECUTES SPL USING 'WITH TRIGGER REFERENCES'

APAR status

• Closed as program error.

Error description

• The situation involves a trigger such as:
  
  create trigger "informix".triggername update on
  "informix".tablename
      referencing new as new
      for each row
          ( execute procedure "informix".procname() with trigger
  references );
  
  When the trigger is fired via an update in this case, the
  procedure is executed and returns a -9791 error.  The stack for
  the thread is:
  
  afstack
  afhandler
  mt_ex_throw_sig
  afsig_handler
  col2expr
  bf_detach
  dotted2expr
  expr2expr
  op_bind_rtn
  buildexpr
  expr2expr
  op_bind_rtn
  buildexpr
  expr2expr
  ip_bldsexpr
  dcmpbody
  decompile_proc
  retrieve_cache
  udr_getbyid
  find_lresrout
  find_resrout
  udr_determine
  expr_determine
  common_routine2expr
  routine2expr
  expr2expr
  exec2cb
  p_sp2cb
  dotrstmts
  dotrigs
  ferafttrig
  dodmlrow
  dodelupd
  aud_dodelupd
  excommand
  ip_evalsql
  runproc
  udrlm_spl_execute
  udrlm_exec_routine
  udr_execute
  exroutine
  execproc
  aud_execproc
  excommand
  dotrstmts
  dotrigs
  ferafttrig
  dodmlrow
  dodelupd
  aud_dodelupd
  excommand
  sq_execute
  sqmain
  listen_verify
  spawn_thread
  startup
  
  Note: the stack above shows an update/delete to a table that
  fires a trigger that executes a procedure that does an
  update/delete to another table which has a trigger that executes
  a procedure.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users having SPL which are created using triggers "with      *
  * references" clause                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When trigger SPL are created using "with references" clause, *
  * server can crash during procedure exection.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * upgrade to 11.50.xC9                                         *
  ****************************************************************
  

Problem conclusion

• fixed in 11.50.xC9
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP