IT35130: 9600: INTERNAL ERROR. INSERT INTO TABLE WHICH HAS ROW AND MULTISET

APAR status

• Closed as program error.

Error description

• When we Insert into a temp Table (which has Row and Multiset
  involved). 9600: Internal error.
  
  14:58:59  Assert Failed: found errno 9600 in session 50
  14:58:59  IBM Informix Dynamic Server Version 12.10.FC14
  14:58:59   Who: Session(50, xxxxx@yyyyyy, 10425, 0x44f3bcf8)
          Thread(65, sqlexec, 44efb528, 1)
          File: rsdebug.c Line: 3116
  14:58:59   Action: Use onmode -I to stop verbose error trapping.
  14:58:59  stack trace for pid 20873 written to
  /opt/informix/IBM/12.10.FC14/manesh115_darkwood/af.4299da2
  14:58:59   See Also:
  /opt/informix/IBM/12.10.FC14/xxxxxxxx/af.4299da2,
  shmem.4299da2.0
  
  
  0x0000000001410459 (oninit) afstack
  0x0000000001413431 (oninit) afhandler
  0x0000000001413c12 (oninit) affail_interface
  0x0000000000e10757 (oninit) check_traperror
  0x0000000000701f21 (oninit) sqerr
  0x0000000000a3e31b (oninit) sqrowcompress
  0x0000000000a3ea7f (oninit) valstore
  0x00000000005fe815 (oninit) assign_col
  0x000000000088edc6 (oninit) chkrowcons
  0x000000000082dd50 (oninit) addone
  0x0000000000831a62 (oninit) insert_next
  0x000000000089b0a1 (oninit) doinsert
  0x00000000006c387d (oninit) aud_doinsert
  0x00000000005d2e28 (oninit) excommand
  0x0000000000a27753 (oninit) sq_execute_workhorse
  0x0000000000a27d6e (oninit) sq_execute
  0x0000000000ae7b71 (oninit) sqmain
  0x000000000154290b (oninit) spawn_thread
  0x0000000001401c70 (oninit) th_init_initgls
  0x0000000001448997 (oninit) startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 12.10.xC15 (when available) or    *
  * 14.10.xC6 (when available).                                  *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC15 and 14.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