IT14446: SERVER ASSERT FAILS IN FM_OPENANY AFTER UNEXPECTED CALL TO EXECUTE_BLOB_ASSIGN DUE TO UNINITIALIZED VALUE_T

APAR status

• Closed as program error.

Error description

• The sqlexec thread assert fails with the following stack:
  
  (Linux) <signal frame>
  fm_openany
  fmopenstaging
  fmbcreate
  scollasblob
  execute_blob_assign
  lrvaldata
  eval_projection_list
  dodmlrow
  dodelupd
  excommand
  sq_execute
  sqmain
  
  The session was performing a SQL update statement when 1 of the
  columns being updated had a slightly complex value assignment
  using nested DECODE statements like this:
  
  plu_nbr  = DECODE(?,-1,plu_nbr,DECODE(?,-1,NULL,NULL,NULL,?))
  
  This is likely a requirement to encounter the issue rather then
  just a standard host variable assignment for the updated value
  or some sort of constant value assignment.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of IDS 12.10                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC7                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC7
  

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

• RC10 PSY

     UP